So I am working on a project that requires me to make a dropdown using the data from analysis service cube. This is what i have come up with by googling.
This may be a simple MDX question but I\'ve spent 2 days without any luck. I have a simple fact table with the following columns:
I need to create report with table which looks like this Country 1Country 2Country 3Total Category 11(2)2(1)5(6)8(9)
Having a hard time doing this simple thing: return 0 instead of \"null\" SELEC开发者_C百科T { [Measures].[Count]
What are good (no vendor related) blogs about Business开发者_如何学编程 Intelligence and OLAP/MDX ?
I am developing a query builder application that generates MDX and trying to get customer counts from a cube using the following, which works just fine:
The following MDX query returns measure X on 3 tuples: 2001, 2002-1 and 2002-2. What I am trying 开发者_Go百科to do is merging 2002-1 and 2002-2 into one tuple and have the measure X for 2001 and 2002
2 hierarchical dimensions (for location and time) are defined on a cube. My question is about possibility of writing a single MDX query for retrieving following structure. I mean 开发者_运维百科writin
I need a help in MDX My product data(ProductId and Launch date) is like this... P14/1/2011 P2 5/5/2011 P3 3/6/2011
I would to execute a query with a calculated member which returns the AVG (of th开发者_StackOverflowe measure) of the Coil belonging to a particular LINESPEED.
加载中,请稍侯......