Skip to Content
0
Former Member
Feb 22, 2011 at 02:04 AM

MDXTEST not showing PARETO data

38 Views

Hi All,

I need some help regarding MDX and Pareto condition in Query.

I have a BW query, in this query, i have a pareto condition to filter sales > 80%

I get the MDX code for this query, i selected the characteristic and key figures i wanted to display in the mdx.

I executed this MDX code in transaction - MDXTEST, although it only show partial data, but for the first few rows of the returned data, i can confirm it's not within the pareto condition.

Question: does this mean, when we use MDXTEST, the pareto condition will not apply?

Thanks if someone can verify this.