(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

[former_member566306]

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

[former_member566306]

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

[Former Member]

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.

[former_member566306]

1) When I follow the first procedure In the cube level I am getting the data here the data source is of transaction type .But at the report level I am not getting the data for attributes why so ?

2)In the second procedure how can we load master data for studentid you mean I have to create a datasource of type master data?

Edited by: dharmatejandt on Oct 25, 2010 9:30 AM

[ChandranGanesan]

Hello,

Create StudentID as a Master data with StudentID as key and Studentname, other required fields as attributes and load the data by creating a Master datasource for this in RSO2.

Example :

StudentID , StudentName, Std....

Here StudentID is the Characteristics with master data where studentname and std are its attributes.

Example values

001, Name1, Std-1...

002, Name2, Std-2 ....

BR,

Chandran

[Former Member]

yes, you have to create a DS of type master data and load the student master data. It will have 4 fileds depending on your requirement. Once the master data is loaded, use only studentid in your tranaactional data records. All these values will be fetch by OLAP with joined among fact table, DIM table, and SID table. System will take care of the join.

[former_member566306]

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

Edited by: dharmatejandt on Oct 26, 2010 8:03 AM