Skip to Content
0
Former Member
Aug 01, 2016 at 02:48 PM

TOP N/ BOTTOM N "Filter by Measure" does not work

42 Views

Dear SAP Experts,

I am experiencing the following issue.

We have a simple procurement spend BEX query, which shows how much data was spend per vendor.

It is binded to a crosstab in Design Studio (Design Studio 1.6 for BI Platform 4.2, Version: 16.2.1.788).

We tried to use the "Filter by Measure" function of Crosstabs to calculate top N vendors

]

Unfortunately nothing happens.

For all other queries/crosstabs the function is working as expected.

I am fully aware of the restrictions for "Filter by Measure" function:

queries with two structures

queries with no structure

queries with no structure and a measure restriction in the fixed filter (selection space)

queries with one non-measure structure (and a measure restriction in the fixed filter)

Non of these is valid in my scenario.

Any idea what could be the issue?

Best regards,

Yuri

Attachments