Print Page - Filtering for a measure in a mdx query in Report Studio

Title: Filtering for a measure in a mdx query in Report Studio
Post by: sbhat on 05 Apr 2017 06:27:12 PM

I have a report in Report Studio that is built off a cube.

I want to filter one measure with an additional filter critieria than the query.

How can I achieve this? This is my first time with mdx functions.

Thanks in advance

Title: Re: Filtering for a measure in a mdx query in Report Studio
Post by: Raghuvir on 06 Apr 2017 05:06:59 AM

Quote from: sbhat on 05 Apr 2017 06:27:12 PM
I have a report in Report Studio that is built off a cube.

I want to filter one measure with an additional filter critieria than the query.

How can I achieve this? This is my first time with mdx functions.

Thanks in advance

can you be more specific about your requirement ?

Title: Re: Filtering for a measure in a mdx query in Report Studio
Post by: bdbits on 07 Apr 2017 11:27:45 AM

Quote from: sbhat on 05 Apr 2017 06:27:12 PM
I want to filter one measure with an additional filter critieria than the query.

I am not really sure what that means, but you might be looking for the filter() function.

Title: Re: Filtering for a measure in a mdx query in Report Studio
Post by: MFGF on 10 Apr 2017 02:56:38 AM

Quote from: bdbits on 07 Apr 2017 11:27:45 AM
I am not really sure what that means, but you might be looking for the filter() function.

...or the tuple() function? Sbhat, can you share details on your requirement?

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sbhat on 05 Apr 2017 06:27:12 PM