Not able to see select Hierarchy option in lumira discovery

[former_member599736]

hello,

I am trying to create/Display hierarchy in lumira designer. I am able to drill down and drill up. but i want it as parent child in output which i am not able to see.

When i checked some posts, it says very clear that create on dimenssion in cross tab and select hierarchy and select parent-chile Hierarchy. But i am not able to see that option it self.

I am using HANA view, using HANA live connection as my source. Lumira version is 2.1 SP1 Patch 1.

current Output

Options i get

Desired Output

[former_member599736]

Hi Tammy,

Thanks for reply. I did check that note. But when i click on Dimension (Point 4) - i am not able to see "Select Hierarchy" as option.

Thanks.

[TammyPowlas]

Please see SAP Note https://launchpad.support.sap.com/#/notes/2539779

It states "

Cause

• Parent-child hierarchy are supported by Hana live connection (Hana online).
• Only supported by Crosstab.
• It will not be listed in object pick like level hierarchies.

Resolution

1. Create a Lumira document and choose Crosstab.
2. Right click on the Crosstab, then select Maximize.
3. Assign dimension and measures from object picker.
4. In Crosstab, right click on the dimension to show hierarchy, click Select Hierarchy.
5. In hierarchy picker, the parent-child hierarchy is displayed, click the hierarchy.
6. In Crosstab, hierarchy is displayed."