Skip to Content

(Not Assigned) Not displaying attribute values

I created a simple cube with Datasource as source.One of the characteristics of a dimension of this cube has an attribute.I created a query on this infocube .In the analyzer its displaying all the values of the characteristics but its not displaying the attributes value of the corresponding characteristic .It's showing ' Not Assigned'.At the dimensional level the attribute which i have created for a characteristic has also been added as a characteristic in the dimension.

The characteristics I have added for the dimension are mentioned below.

studentid->studentname(This is the attribute I assigned to studentid)

studentname ->as characteristic

studentclass->as characteristic

studentgrade->as characteristic

Edited by: dharmatejandt on Oct 25, 2010 7:56 AM

Edited by: dharmatejandt on Oct 25, 2010 7:56 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2010 at 06:15 AM

    Hello,

    It looks the Student Master data is not maintained.

    The attribute will not display until you maintain the master data, but for characteristics Studentname you will have to load the value via transaction data.

    Regards,

    Chandran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2010 at 07:09 AM

    To get these valus in reports, you can do two things:

    1. Load the data with all these details - studentid, studentname , studentclass, studentgrade->as you have added these in the dimensions as characteristic. So, the flat files should contain all these values in the coulumns. OR

    2. Add only studentid in the dimension. And add studentname , studentclass, studentgrade as the attribute of the studentid. Now, you have to laod the master data for studentid. So, the file in this case should contains studentid, studentname , studentclass, studentgrade. Sice cube follows extended start schema, youwill get these vaklue in your reports.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 26, 2010 at 05:56 AM

    Thank you all,

    Finally I got it. I created studentid as " Infoobject as Infoprovider" and I used that in the dimension.Finally I got the data(attributes values) in the analyzer.

    Regards

    TEJA

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 26, 2010 at 05:56 AM

    Thank you all,

    Finally I got it. I created studentid as " Infoobject as Infoprovider" and I used that in the dimension.Finally I got the data(attributes values) in the analyzer.

    Regards

    TEJA

    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.