Skip to Content
0

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

Apr 18, 2017 at 05:27 AM

30

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 18, 2017 at 07:15 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded