Drillback in SAP Lumira 2.2

[former_member544949]

Hi Experts,

I know drilling back (going one level up/higher in hierarchy) was not doable in Design studio 1.6, but is it possible in SAP Lumira Designer 2.2 ?

Thanks!!!

[reiner_hille-doering]

Hello Afreen,

hierarchies don't have the operation "drill-down" and "drill-up".

"Drill-down" is an operation that you can do between two dimensions: For Dimension1, you filter on a member and replace it - instead you add Dimension2. Drill-up is the opposite: Remove Dimension2, add Dimension1 and clear the filter.

In Lumira 2.x you have 2 possibilities for those operations:

1. In Right-click a member in Crosstab or Chart and choose Drill-down... . Then choose target dimension. There is no "Drill-up", but you could enable undo/redo and go a step back.
2. Define a so-called drill-path (which corresponds to Lumira 1.x hierarchy). You can't define a drillpath in Designer, but in Discovery for offline data sets. And for HANA level-based hierarchies, such a drillpath is created automatically. In this case the Context menu allows to choose a drill path and afterwards allows to nicely drill-down and drill-up.

Hierarchies generally don't support "drill-down" and "drill-up", but "expand" and "collapse". The dimension stays, but you show or hide child-members.

"Expand" and "Collapse" work very nicely with a Crosstab, but not with a chart, as you would compare child values with parent values.

To resolve this, we have implemented a quite cool feature in Lumira 2.3: If you have a chart showing a dimension with active hierarchy, you have two feature:

• Hide Expanded nodes: This prevents that you see values of parent and child in parallel.
• Drill-down Hierarchy and Drill-up Hierarchy context menu entries. This simulate the behavior of a drill-path by expanding a node and filtering the parent or vice versa.

Best you download a Designer 2.3 and try the feature - if it fulfills your requirement.

Regards,

Reiner.

[reiner_hille-doering]

Hello all,

drilldown and drillup are used for quire a lot of different things in Analytics in general and therefore also in Design Studio / Lumira, mainly:

• Drill to a dimension: set a filter to a member, remove a dimension and add another dimension.
• Drillpaths (also called "Hierarchy" in Lumira 1.x and Discovery): same as above, but defined by some metadata.
• Expanding and collapsing a BEx hierarchy member.

The "undo " of such a operation can be tricky. For Drillpath, there is a specific "Drill-up". For all cases the Lumira "Undo" feature works nicely. If enabled with Application properties, it also appear in Context Menu as "Back one step".

And last but not least: in Lumira 2.3 there is a new "Drill-down Hierarchy" and "Drill-up Hierarchy" feature for BEx hierarchies. It is a combination of 1 and 3 - and is especially usefulll in charts, where you can't expand and collapse individual nodes.

Reiner.

[former_member490510]

Hi Afreen, did you find the solution for this.

We have same requirement in my current dashboards.

Please let me know:)

[former_member680888]

Hi all,

We are also looking for drill up feature. any solution to this.

Regards

Hari

[michael_tocik5]

Hi

I am not 100% sure in which version this function was added but we are 2.1 and you can achieve this using

DS_1.expandNode

[former_member544949]

Thanks Michael for your response.

I have displayed my org. hierarchy in a dimension Filter. I want to display the one level back of hierarchy in the dimension Filter when I click a button.

I have tried the function on “On Click” event of a button as you suggested like this.

DS_2.expandNode("ZXORG","HIERARCHY_NODE/ORGEH/01",1);

It’s not working. DO I need to replace 1 with -1 to go one level back in Hierarchy ?

Thanks!!