Skip to Content
0
Oct 09, 2020 at 09:29 PM

remove/move dimensions to the crosstab

37 Views

Hi All,

There are 5 cascading dropdowns and one crosstab which are working fine. Dropdowns are based on show/hide feature one after another. Everything is working fine. It is based on when dropdown 2 is selected, it makes dropdown 3 visible and moving dimensions to the crosstab accordingly. the problem is, It is not moving dimension to the crosstab when Dropdown is visible. its is getting effective after making selection to the dropdown then it works fine.

I want dimension to move right away when dropdown3 is visible not after making selection. Seems like it gets active after the dropdown selection.

I wrote this code on dropdown 2 which is not working as expected

if (dropdpwn3.setVisible(true))

{ DS_1.setFilter("DS:2,DIM:id_108",dropdpwn3.getSelectedValue());

DS_1.moveDimensionBefore("DS:2,DIM:id_5", "DS:2,DIM:id_17");}

else

{DS_1.removeDimension("DS:2,DIM:id_5");

DS_1.removeDimension("DS:2,DIM:id_11");}

Any idea how to resolve this issue? Thanks in advance.