Skip to Content
0

Design studio crosstab drill down

Nov 08, 2016 at 11:10 AM

93

avatar image

Hi,

I would like to filter and drill down on a value selected in a crosstab two levels down. For example when clicking on Division - I want to drill down to Sub-Division and sub-division must replace the division column in the crosstab. Then I want to drill down another level, when clicking on Sub-division I want to drill down to Department and department must replace sub-division in the same crosstab.

Can someone please help me with code for doing this. I can get one level down, but two I can't get to work.

Thanks

10 |10000 characters needed characters left characters exceeded

Maybe you can share how you are getting one level to work? What is your data source? Is it a BEX query? Are you using RRI (report-to-report interface)?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Poovarasan Boopalan Nov 08, 2016 at 11:27 AM
0

Hi Erika Schoombee

This below code can help you to change dimensions and filter selected value in crosstab.

var Dim=DS_1.getDimensions(Axis.ROWS)[0];

var sel_val=CROSSTAB_1.getSelectedMember(Dim);

if(Dim.text=="Division")

{ DS_1.setFilter(Dim,sel_val);

DS_1.swapDimensions(Dim, "Sub_division"); }

else if(Dim.text=="Sub Division")

{ DS_1.setFilter(Dim,sel_val);

DS_1.swapDimensions(Dim, "Department"); }


Thanks,

Poovarasan

Share
10 |10000 characters needed characters left characters exceeded