Skip to Content

S4HANA - Analysis for office- unable to see filter values

Hi all ,

I am trying to use a standard query in Bex and i am not able to see master data values in filter selections,

Instead of analysis , values are available in query designer and in filter value selection area i have selected "Values in Master Data Table"

From RSRT i am able to see the inputs but i am coming accross with another problem, no value could be determined for variable /ERP/P_0FISCVARNT01 error appears , but there are values in /ERP/SFIN_V01 table , (I have added CAC, GJR and COC parameters to user profile)

Regards

Selin

sc1.png (130.0 kB)
sc3.png (115.4 kB)
sc4.png (77.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 31 at 03:17 PM

    Hi Selin,

    Can you try enabling the Analysis office -->.settings-->advanced settings -->Show access mode for member display ,

    Then in value help screen check the setting Display-->Access mode-->Values in Master data.

    Add comment
    10|10000 characters needed characters exceeded

    • Ça─člar ,

      thanks a lot for the answer but problem still exists..

      I have 2 queries which are nearly the same, only difference between them is one of them(lets say Q001) includes 0UNIT characteristic. Q002 doesn't.

      While opening Q001 query from bex analysis i am able to see all characteristic filters but in Q002 query characteristic filters selection is not possible.

  • Jan 28 at 04:47 PM

    Hello Selin - please follow the troubleshooting steps outlined in SAP Note https://launchpad.support.sap.com/#/notes/0002530566

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tammy ,

      thanks a lot for the answer , from rsrt i am able to execute the report now , but from analysis still unable to see master datas in filter selections,