Skip to Content
0

Using crosstab as filter to show measure

Feb 27, 2017 at 10:19 PM

120

avatar image
Former Member

Hello, I am using DS 1.6.4.1 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?

0
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)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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.

Regards,

Mustafa.

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

Thanks Mustafa!

1