Design studio crosstab drill down

[former_member252869]

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

[TammyPowlas]

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)?

[former_member265529]

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