Skip to Content
avatar image
Former Member

Prompt: Unable to see all master data value

Hi guys

I created a Analysis Office report and I can't see all the members of the dimension when I open the prompt, only those members with transactional data values,

Could you help me?

Following you can see the configuration

Thanks

capture.png (44.9 kB)
bex-query.png (82.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 22, 2017 at 04:24 PM

    I found the problem.

    My composite provider has assigned all the characteristics, with the option "Filter Values Selection: Only posted values for navigation".

    I changed it to "Values in master data tables" and it works.

    Thank you!

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 22, 2017 at 03:23 PM

    Hi Niels - I am not familiar with the BPC/planning side of things

    Could you check the Access Mode Members setting from the Analysis side?

    See below:

    Add comment
    10|10000 characters needed characters exceeded