I have a ssas cube with the fact table containing: FactID Status StartDate EndDate the dates are linked to a date dimension (status to the status dimension).
Is there a way to list dimension members without fetching default Me开发者_高级运维asure for each member?You could SELECT nothing on the opposite axis:
Is there a brief开发者_如何学JAVAer way of specifying a set in MDX? I know I can do something like :
my data are look like this: > Columns开发者_高级运维ABC > > RowsTotal Audit Complete Audit Not Complete Audit Total
Not sure if this is the right place for MDX question but it seemed to be the most appropriat开发者_高级运维e.
I have a query like WITH MEMBER [measures].[Count] AS SUM(([Location].[Hierarchy].[Zone].[1].Children),[Measures].[Length])
Is there any support for Multidimensio开发者_如何学Cnal Expressions (MDX) for Hadoop\'s Hive ?Connecting an OLAP solution with Hadoop\'s data is possible. In icCube it\'s possible to create your own d
I have a TABLE A( Type INT, Value INT ) Now I want to calculate the difference between the Value of each two subsequent lines of the same Type.
I have a cube derived from one fact table that has a key and three other attributes fact_event (eventid, ageband, location, type)
What is the best way of MDX querying for each drill down of BI dash board c开发者_开发问答hart? as a example if you have four drill level every drill down we should execute four MDX query or execute o
加载中,请稍侯......