S4HANA - Analysis for office- unable to see filter values

[slnkpsl]

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

[Former Member]

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.

[slnkpsl]

Ç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.

[mayiya]

Hi Selin.

Have the same issue. Could you resolve it ?

[TammyPowlas]

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

[slnkpsl]

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,