SAP BO .unx universe level hierarchy based on custom SQL list of values

[former_member630262]

Hi Guys,

I have couple of scenario's where need to create a .unx universe level hierarchy based on custom SQL list of values.

SAP BO 4.2 Sp7 p1

Scenario 1:

I have following five different levels of classifications based on custom SQL LOV's

Class1LOV,Class2LOV,Class3LOV,Class4LOV and Class05LOV

After mapping each classification level to corresponding dimension and creating the custom hierarchy of these five dimension associated with classification LOV's , results are not populating in Parent-child relationship.

Scenario 2:

how to create a .unx universe level custom hierarchy based on custom SQL list of values where universe is based on SQL Stored Procedure passing the parameters > Province>Division>City

any idea please!

Both universes are eventually using in Webi reporting.

Thanks

NAV