Skip to Content

Apply Filter on a measure variable SAP BO

Hi all,

I'm trying to apply a filter on a measure variable and it doesn't work, not even applying Sort or Ranking. This variable was created based on the results of "original" measures. Do you know how can I solve this?

I'm using SAP BusinessObjects BI Platform 4.1 Support Pack 6 Patch 3

Version: 14.1.6.1805.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 13 at 12:41 PM

    try to create dimension variable and see or share the screen shots of your issue

    Add comment
    10|10000 characters needed characters exceeded

    • Someone told me that the problem can be caused by the fact that these numbers are not all in the same unit in the database (some are in kg, others in m and others in un), is that true? If yes, how can I overtake this problem?

  • Apr 23 at 01:13 PM

    Rather than filter on a measure, you could create a variable that returns 1 or 0

    then rank on the top 1 value of the variable to return all rows equal to 1

    Add comment
    10|10000 characters needed characters exceeded