Report Portal

Slice on a Calculated Member that uses the Aggregate function

A user reported seeing two different behaviors by running two slightly different MDXs statement with a where clause on a calculated member that used the Aggregation function. In this post, we will try to look at the 2 queries in question and explain the difference in behavior with the Adventure works Sample DB.


Tags: excel, mdx, slicer


2007-2015 VidasSoft Systems Inc.