I\'m a complete newb to MDX / OLAP, \"data warehousing\" in general. I have the following MDX query and would like my results to display the month\'s number (1 = January, 12 = December). Luckily, the
I can get the MAX() of some Measure based on Dimensions specified. I have no issues with that. What I am looking for is Second MAX(). Means if I sort th开发者_运维知识库e some Measures in DESC order i
Pretty much what the title says. Is it possible to show the MDX that is 开发者_JAVA百科sent to OLAP source when using a pivot table in Excel 2007?You can download the OLAP Pivot Table Extensions from
I\'m new to MDX and have a problem regarding filtering out values from a summation. We want to perform normalization calculations, specifically a quantity (q) divided by a basis (b) to get an Intensi
This is a pretty straight forward question that may or may not be possible but, when you create a measure in a SSAS 2005 cube, there is a descriptio开发者_StackOverflow社区n property which can be set,
Wondering if I could get some advice and direction on this following 开发者_StackOverflow社区requirement:
I\'m building a report in Reporting Services 2005 based on a SSAS 2005 cube.The basic idea of the report is that they want to see sales for this fiscal year to date vs. last year sales year to date.It
I am trying to build a calculated measure in SSAS that incorporates a dimension parameter. I have two facts: Members & Orders and one Dimension: Date. Members represents all the unique members on
I wanted to use dimension properties on columns. So, in the mdx que开发者_开发知识库ry, I dragged in those properties from the dimension \"member properties\". But, for some reason, the values for tho
I have the following table , Database Table: BatchIDBatchNameChemicalValue ----------------------------------------------
加载中,请稍侯......