(Not Assigned) Not displaying attribute values

[former_member566306]

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

[ChandranGanesan · Accepted solution]

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

[former_member566306 · Accepted solution]

The source for this Infocube is Datasource which is of type transaction you mean ,I need to change the

datasource type as masterdata .

[ChandranGanesan · Accepted solution]

Hello,

No. The datasource for InfoCube is Transaction only. For displaying StudentName as Characteristics then it has to be loaded as a part of transaction data.

But if you want to display the Studentname as Attribute, then you need to maintain StudentID as master data and load the data for StudentID, Studentname etc via Master datasource.

Hope its clear now.

BR,

Chandran

[former_member566306 · Accepted solution]

Sorry ,I couldn't get you.Could you elaborate your answer.

How can we make StudentID as master data once we created the Data source of transaction type ?

Edited by: dharmatejandt on Oct 25, 2010 8:58 AM