Skip to Content
0

S4HANA - Analysis for office- unable to see filter values

Jan 28 at 02:16 PM

88

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jan 28 at 04:47 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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,

0
Caglayan Adiguzel Jan 31 at 03:17 PM
0

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.


masterdata.jpg (85.6 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0