Skip to Content
0
Apr 18, 2017 at 05:27 AM

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

53 Views

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

Attachments

enpsg.png (11.3 kB)
db55t.png (19.2 kB)
kpio5.png (10.0 kB)
nqzyh.png (11.2 kB)