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
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.
I am new to MDX and have just started using Named sets to group severa开发者_开发知识库l members of a dimension.
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
I wanted to have results something like this: cityziprevenuex A|1|2000|10000 A|2|3000|10000 A|3|5000|10000
I\'m new to mdx and have been trying to solve the following problem for about a day now. Any help would be appreciated:
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
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
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
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.
加载中,请稍侯......