Skip to Content

Using crosstab as filter to show measure

Feb 27, 2017 at 10:19 PM


avatar image
Former Member

Hello, I am using DS and using a HANA view to create my dashboard.

I want to use a crosstab as filter to show the results in a text box. Everything is working but when i click outside the cell in the crosstab, brings all the information, it's ok but the result is not ok.

The data source I used has stores and warehouses and i have a filter only for warehouses but it brings me everything.

This is my dashboard:

When i select one warehouse is working:

But when I click outside the warehouse description the results is diferent that the first one:

It should be 130 instead of 131

I am using this script in the crosstab to create the filters (the text box used to be invisible at the beginning, are visible only to show the diferences):

I have 2 datasources:

One for the cross tab and other for the text components, both of them are filter by the warehouses

Is something missing in the script and that's why i see the sum of warehouses and stores together?

6.png (8.5 kB)
10 |10000 characters needed characters left characters exceeded

Hi Alejandra,

Can you provide a screenshot of the Property Sheet of your Crosstab showing all the details? Also, when you say "when I click outside the warehouse description", what do you mean exactly? Are you clicking another column in the same row or are you clicking outside the Crosstab altogether?

Former Member
Mustafa Bensan

When i click in other column, i put single in selection type, so when i click in other column (Saldo/Saldo vencido)

7.png (21.9 kB)
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mustafa Bensan Feb 27, 2017 at 11:55 PM

Hi Alejandra,

This is an unfortunate limitation of the Crosstab selection functionality at the moment. When you click another column, such as a key figure column, getSelectedMember() returns "(ALL_MEMBERS)". This is why your result shows a total.

The issue has been raised before on the SCN but I couldn't find the relevant post. One suggested workaround was to place a panel component over the measure columns to prevent triggering of the Crosstab "On Select" event. This way, the user can only select the dimension column.

Perhaps others can provide a more sophisticated workaround that doesn't require the overlay panel.



Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Mustafa!