Hi Guys,
I have an issue in my existing webi reports with saved prompts variants:
> when we run the report with fresh query by applying hierarchy prompts (Postal Code) we get the results as expected, once we saved the same prompts as variants and run the report, the result table is empty.
We have a three level of hierarchy and found once we saved the parameters as variant it's assigned all the time to first level of hierarchy attribute in backend query causing empty dataset in report, especially if 2nd or 3rd hierarchy member selected in the variant.
We are using SAP BO IDT 4.3 sp02 universe and Webi reporting and Postal Code list of values created as a custom hierarchy in universe with three members.
Is there any suggestions or workaround?
Thank you very much!
Nav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.