Skip to Content
author's profile photo Former Member
Former Member

Characteristic 'X' has no master data for "0" or you do not have authorization

Hi Experts,

I'm getting an error while executing a BEx query in portal.

Background:

There is a NAV attribute(CHAR(5)) in multiprovider. This object can hold positive values, negative values and 0. (-3. -2, -1, 0, 1, 2, 3)

We have created a user entry variable in query on this NAV attribute.We have created as CHAR, as we want to hold negative values in it and wanted to use it as NAV attribute.

Query is running fine when I'm entering positive and negative values however when I'm entering 0, it is giving following error:

Characteristic 'X' has no master data for "0" or you do not have authorization.

An invalid selection for characteristic has been discarded.

All selections for characteristic 'X' are invalid and have been discarded.

The same query works absolutely fine in RSRT with all types of values - positive, negative and 0.

Please suggest.

Any help would be highly appreciated.

Regards,

S

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 01, 2013 at 08:56 PM

    Hi S,

    Is this working fine in Bex Analyzer?

    Also check SAP Note - 1384942 - Numeric variable with replacement from KEY intensified

    Br,

    Arpit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2013 at 05:12 PM

    Hi Experts..

    Please suggest, I'm still not able to get through this.

    Regards,

    Sonal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2013 at 09:46 PM

    We experience this issue since we upgraded to 7.30 SP8 and tried many things with SAP's support but never managed to find a solution for it. For us, this occurs only on JAVA stack (in BEx web) though, as the same reports work as expected in BEx Analyzer.

    Has anyone else faced this issue and resolved it?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Issue is resolved. Goto the relevant info object in RSD1-->Business Explorer tab-->change the option of the field 'Selection'( 4th field) to "No Selection Restriction" from the value 4.

      Thanks

      Prithvi

  • Posted on Jul 21, 2016 at 01:39 PM

    Hi,

    I am also facing the same issue, if I give the selection as date and fiscal year period in the BEx reports. These are the Key figures..

    Error message: Characteristic Key Figures has no master data for "X" or you do not have authorization

    Does anyone have solution for this issue?

    Thanks,

    Sheetal

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.