Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I\'m currently struggling with the creation of a cube. Below is a simplified version of my relational data...
In Sql Server Management Studio once I browse a cube I can drop column fields, row fields an开发者_开发技巧d filter fields. This displays the required data.
I have one data warehouse table that contain one row for each item sold. Each row contains the item\'s type.
Using : Analysis Services 2008, Excel 2007 I\'ve created a Cube and am able to connect from Excel. Cube does have some Calculated Measures, Named Sets and KPIs.
I am customizing one of the CMMI reports in TFS 2010. One of them is \"Bug Status\". When I open the query in the Query Designer of BIDS, i see that two backslashes (//) are used for c开发者_C百科omme
with member [Measures].[BoughtDispenser] as Sum(Descendants([Customer].[Customer].CurrentMember, [Customer].[Customer]),
We use a cube built in SSAS and we would like to show the effect of deltas against a forecast. So, we have data like this:
I have taken a perfectly working MDX piece of code to Windows 2008R2 (all DX drivers installed) and am getting the following, rather bizarre, error. Any idea what this could mean?
How can i round a calculated mdx measure up to the nearest integer without having Excel on the server? The Excel-function is CEILING(number, significance), but it is not possible to install Excel 开发