cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy prompts variants are not working in webi report

navakh
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (0)