Skip to Content
avatar image
Former Member

Query filters measures

Hi,

on SAP WEBI tutorial is showed that it is possible to add Filter Query for measures but I can't do this. When I'm doing it like in YouTube video, I only get an info that I have to "select valid object first"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 24, 2017 at 03:01 PM

    what is your BO version..BI 4.2?

    If yes then this issue is resolved in the BI 4.2 SP03 Patch3.

    see attached sap note.

    2389311 - Select a valid object first error when trying to use a subquery on a measure in Web Intelligence

    Add comment
    10|10000 characters needed characters exceeded

    • I know support packages are cumulative but not very sure about Patches.

      I have checked the Patch 8 and Patch 3 release information documents and found mentioned sap note is in Patch 3 only.

      I am not sure if this fix is included in the Patch 8.

      untitled.png (11.3 kB)
  • Jan 17, 2017 at 02:51 PM

    what is your webi query source?

    It seems your Webi query source is Bex query (BICS conneciton).This feature is not enabled with BICS conneciton.

    It will work with relational universe.Try with universe.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 09:24 AM

    Hi Lukasz,

    If you have created Universe and you are creating WEBI document then you will be able to create query filters on measures.

    Thanks,

    Swapna

    Add comment
    10|10000 characters needed characters exceeded