cancel
Showing results for 
Search instead for 
Did you mean: 

Characteristic XXX has no master data issue in AO

Former Member
0 Kudos

Hello

I use Analysis for Excel 2.2 SP1 and for 2 days my restricted users start to get below error :

Characteristic XXXX has no master data for YYYY or you do not have authorization (com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.selection.SingleMember-NoMasterdata)

Interestingly it is only in AO, RSRT does not give this message.

In the forum i found a few corrections which are not applying to my setup, My versions are like below

AO : 2.2 SP1 (also tested with SP4, same issue)

BO : Version: 14.1.7.1986

BW : 7.4 SP13

MS Office: 14.0.7172.5000

So i can not use  2092810, 2040915 or 2101188

What do you think?

Thank you for your helps

Accepted Solutions (0)

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

I would try a security trace back in BW and try it again using Analysis Office.  The security trace will highlight missing authorizations.  Ask your BW admin to use transaction STAUTHTRACE

Former Member
0 Kudos

Hello Tammy

I should elaborate my case:

In my workbooks there is mandatory selection of Business Unit and all users are restricted to see some business units.

When i am saving the workbook for the first time as admin, i select any of the business units (e.g. A100) in prompt, and i save the workbook.

After that, when  a user who has no authorization to see A100 opens the workbook, this message pops up.

Store Prompts with Workbook -> This option is unchecked

Remove Data Before Saving -> This option is checked.

So i don t understand where my selections are being kept.

Thank you for responding.