mdx
How to calculate current month and next 6 months in an mdx query ?? Please help !
i want to calculate current month and n开发者_高级运维ext 6 months in an mdx query as columns..Please help !!I have tried this within MDX, and it can be a pain. String manipulation with VBA was the mo[详细]
2023-01-31 18:49 分类:问答MDX Query for Parent Child Relationship
I have an OLAP Basically there is a dimension that has parent-child relationship. So the dimension has a parent-id and a child-id.[详细]
2023-01-30 01:34 分类:问答MDX query to use a set but return a single row
I am new to MDX and have just started using Named sets to group severa开发者_开发知识库l members of a dimension.[详细]
2023-01-29 08:01 分类:问答MDX - Concatenate level's properties and level's members
I an using mondrian and I have this issue: using a query mdx I need to concatenate in each member name belonging to a certain level, its name and a the value of a certain level properties for that mem[详细]
2023-01-29 00:06 分类:问答Calculated measures in MDX not working
I wanted to have results something like this: cityziprevenuex A|1|2000|10000 A|2|3000|10000 A|3|5000|10000[详细]
2023-01-27 17:47 分类:问答MDX result categorisation
I\'m new to mdx and have been trying to solve the following problem for about a day now. Any help would be appreciated:[详细]
2023-01-25 03:11 分类:问答SQL Server Analysis Service: Need to suppress empty results
We have a very sparse cube in SSAS. The size of the cube is only 50M bytes in MOLP storage. When writing your own MDX query, you can use NON EMPTY/NONEMPTY to suppress/filter out empty results. But we[详细]
2023-01-24 10:04 分类:问答Parameter Pentaho Report Designer with MDX
I am doing a report, using Pentaho Report Designer. My datasource is a Mondrian Cube with MySQL JDBC. I am using MDX queries, and I want to put paramerize开发者_C百科 it. I have to configure a paramet[详细]
2023-01-22 18:51 分类:问答Using MDX Correlation() function to find correlation of 2 dimentional members
I\'m trying to find the Pearson correlation of a single measure between two members of a dimension, but the msdn docs a开发者_如何学JAVAre a bit sparse.Specifically I have a cube with a fact count mea[详细]
2023-01-22 16:10 分类:问答MDX calculation has wrong order of precendence
Im having an issue with an MDX query, and I think it boils down to the order of precedence between calculating an aggregate and a calculated member.[详细]
2023-01-22 08:31 分类:问答