mdx
individual day calculations ,in MDX, with Start and End date in fact table
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).[详细]
2023-03-10 21:14 分类:问答List dimension members with MDX query
Is there a way to list dimension members without fetching default Me开发者_高级运维asure for each member?You could SELECT nothing on the opposite axis:[详细]
2023-03-10 19:52 分类:问答A shorter way of specifying a set in MDX
Is there a brief开发者_如何学JAVAer way of specifying a set in MDX? I know I can do something like :[详细]
2023-03-09 22:15 分类:问答how to apply IIF condition in mdx query in rows
my data are look like this: > Columns开发者_高级运维ABC > > RowsTotal Audit Complete Audit Not Complete Audit Total[详细]
2023-03-09 10:31 分类:问答MDX and AVG function
Not sure if this is the right place for MDX question but it seemed to be the most appropriat开发者_高级运维e.[详细]
2023-03-08 20:46 分类:问答MDX query "with member" and sum problem
I have a query like WITH MEMBER [measures].[Count] AS SUM(([Location].[Hierarchy].[Zone].[1].Children),[Measures].[Length])[详细]
2023-03-08 06:49 分类:问答MDX support for Hive (Hadoop)
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[详细]
2023-03-07 13:02 分类:问答Cursor in a MDX expression?
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.[详细]
2023-03-06 12:47 分类:问答Include Empty Values in SSAS MDX query to use in SSRS
I have a cube derived from one fact table that has a key and three other attributes fact_event (eventid, ageband, location, type)[详细]
2023-03-05 03:50 分类:问答Best Way for BI dash board drill down
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[详细]
2023-03-03 15:55 分类:问答