mdx
Making a dropdown using Analysis Cube Data
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.[详细]
2023-03-15 21:37 分类:问答Conditional records count with MDX, SQL Server BI
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:[详细]
2023-03-15 16:14 分类:问答Reporting services put data from two DataSet rows in one tablix cell
I need to create report with table which looks like this Country 1Country 2Country 3Total Category 11(2)2(1)5(6)8(9)[详细]
2023-03-14 06:14 分类:问答MDX Query - 0 if Empty
Having a hard time doing this simple thing: return 0 instead of \"null\" SELEC开发者_C百科T { [Measures].[Count][详细]
2023-03-13 18:34 分类:问答Business Intelligence and OLAP/MDX
What are good (no vendor related) blogs about Business开发者_如何学编程 Intelligence and OLAP/MDX ?[详细]
2023-03-13 16:41 分类:问答How can I determine whether dimensions are related?
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:[详细]
2023-03-13 08:46 分类:问答Merging two tuples in the same hierarchy into one (in MDX WITH SET command)
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[详细]
2023-03-12 05:28 分类:问答MDX on multiple hierarchical dimensions
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[详细]
2023-03-11 20:13 分类:问答MDX measure as on date
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[详细]
2023-03-11 15:54 分类:问答Why AVG function perform the SUM?
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.[详细]
2023-03-11 04:10 分类:问答