Skip to Content
0

Pass Crosstab Measure Selection(s) to Second Crosstab

Feb 24 at 05:35 PM

47

avatar image
Former Member

I have a summary crosstab showing multiple types of counts for a given dimension. The user wants to be able to select any of these counts and see the underlying detail. How do I identify the dimension member and measure name of the count selected?
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mustafa Bensan Feb 25 at 01:53 AM
0

Hi Meredith,

In the "On Select" event script of your Crosstab you can apply code similar to this, where DS_1 is the data source assigned to your Crosstab:

 var measuresDimension = DS_1.getMeasuresDimension();
 
 var selectedMeasures = me.getSelectedMembers(measuresDimension.name);
 
 var selectedDimensionMembers = me.getSelectedMembers(<Evnt Org Level 2 Technical ID>);

You can then use selectedMeasures and selectedDimensionMembers to drive the detail Crosstab.

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded