Hierarchical Dimension Tree component

[former_member598128]

Hi, good day, i have a issue, this is the environment:

1.- Information Design Tool 4.2 SP6

2..- Sap Lumira Designer 2.2 SP0 Patch3

3.- SAP BusinessObjects BI 4.2 SP4

There is an Oracle database release 11, that has the schema entity relationships , so,

With IDT I have created an universe unx, the connection is relational and the DBMS engine is oracle 11,

so i get the classes and objects to publish the universe, to here all right.

Sap Lumira designer add data source the universe, so add the basic component tree , but is does not show the hierarchy.

In the IDT in business layer i have created a custom Navigator Path , even LOV too, but when i open lumira designer and edit initial view, there is no hierarchies.

I need to get hierarchies I have three dim tables: Countries, States , Cities and the fact table with the amount and prices, measures i need to get a node tree to navegate from Country to City and get the total amount according the level.

According the environment is possible?

how?

Thank you for all your advices