Skip to Content
0
Former Member
Oct 07, 2009 at 05:52 AM

MDX used in Universe for Prompt returns Incorrect Result

29 Views

Hi All,

I have created an optional predefined filter in the universe like so... (and for many other characteristics too...)


<OPTIONAL>
<FILTER KEY="[0COMP_CODE].[LEVEL01]">
<CONDITION OPERATORCONDITION="InList">
<CONSTANT CAPTION="@Prompt('Select Company Code(s)','A','Company code\Company code',multi,constrained)">
</CONSTANT>
</CONDITION>
</FILTER>
</OPTIONAL>

The code works i.e The prompt comes up, the text is correct, the list of values are correct. BUT....

This is a multi value prompt i.e In List... So when I select only 1 Comany code i.e CODE-1, run the Webi report, the result is as expected, the reports displays all the data for Company code - CODE-1.

When I refersh the report and add CODE-2, so the list now has CODE-1 and CODE-2 in the prompt... only the data for CODE-1 is displayed in the report, and CODE-2's data is not returned.

I also find that when I select CODE-2 first, then CODE-1, then only CODE-2's data is returned, so I can safely say that only the first selected Company code is returned in the Webi report irrespective of how many Company codes where selected in the list.

This behaviour also affects any other characteristic on which filter is created in this manner.

Has anyone experienced this behaviour? Is there something on the BW side that needs to be checked? or is this a bug?

Thanks

J