Skip to Content

Drill Down in Chart based on BW Hirarchy (Present only in One Dimension)

Design Studio Version : 1.6 SP1 Patch 2

BW Version : 7.3

My requirement are :

Requirement 1 : I want to drill down from Material Category to SubCategory in the same chart.

Hierarchy is present in same Dimension itself. In BW side Hierarchy can not be segregate in different Dimension.

Bw Hierarchy:

Material Group:

1.(a). 01

1.(a-1). 02

1.(a-2). 03

1.(b). 300105

1.(b-1). 300106

2.(b-2). 300107

1.(c). 310104

2.Not assign

When I execute dashboard :

Before:

After:

I have clicked level1, level2, level3, level4, level5, then we are getting report below screen like.

I tried but it's not working.

Kindly provide solution.

Requirement 2 : Please provide me code for Interaction between KPI Tiles and Chart.

For E.g. : When I Click on KPI Tile , chart should get Filtered when I clicked on KPI Tile.

Thanks in Advance

enpsg.png (11.3 kB)
db55t.png (19.2 kB)
kpio5.png (10.0 kB)
nqzyh.png (11.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 18, 2017 at 07:15 AM

    Hi Mahesh,

    You can use the below code to drill down in the hierarchy assigned to your bar chart.

    DS_1.setFilter("Dimension", INFOCHART_1.getSelectedMember("ZRFD_RIG"));

    DS_1.expandNode("Dimension" , "HIERARCHY_NODE/0HIER_NODE/" + INFOCHART_1.getSelectedMember("Dimension").internalKey);


    To revert it back use below code

    DS_1.clearFilter("Dimension");

    DS_1.collapseNode("Dimension" , "HIERARCHY_NODE/0HIER_NODE/" + INFOCHART_1.getSelectedMember("Dimension").internalKey);

    You can use the code in your chart selection to drill down.

    Thanks,

    Poovarasan

    Add comment
    10|10000 characters needed characters exceeded