Report Portal

How can solve order effect your MDX calculations

Have a look at this query

   1:  WITH
2: MEMBER [Measures].[REFUNDS] AS [Measures].[Internet Sales Amount] – [Measures].[Internet Sales Amount] * .4
3: MEMBER [Measures].[PROFIT] AS [Measures].[Internet Sales Amount] – [Measures].[REFUNDS]
4: MEMBER [Product].[Product].[Top10] AS
5: sum(
 Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.