cancel
Showing results for 
Search instead for 
Did you mean: 

where can we see the loaded texts in a cube

Former Member
0 Kudos

hello,

I use 0MATERIAL_ATTR and VENDOR_ATTR datasources to load text information in infocube 0PUR_C01 by creating the dataflow(trasformation,Infopackage, DTP) between these datasources and infocubes respectively.I ran the infopackage and i am able to see the data in PSA.I ran the DTP and it ran perfectly alright.I go to contents of infocube but not able to see these text descriptions for material and vendor.Where exactly can i go and view this text desc in infocube 0PUR_C01 for material and vendor.

would appreaciate any information on this.

Thanks,

SS

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Though you are not able to see it in the Cube, when you run a query/report on this cube and pull in Vendor or material key, , you will see that the text gets pulled next to it in the report or you can do the setting to see the text alone from contect menu.

Text is not physically stored in the cube & is stored as part of master data text.

So if you for some business reasons need the text values of Vendor or material to be in the cube (not recommended ), the you have to create objects in the cube to hold these values and have the Vendor/Material text Datasource as the source and map it.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi SS,

0MATERIAL_ATTR is the DS used to load the Attributes of the Master data 0MATERIAL. If you want to load the text we have one more datasource 0MATERIAL_TEXT to load texts to material.

You can see the data for attributes/texts by right click on the 0MATERIAL Masterdata IO --> Maintain master data --> Execute.

Here you will be able to see all the masterdata loaded to 0MATERIAL.

Also note that both 0MATERIAL & 0VENDOR has to be part of Infocube. You will be able to see the data for its attributes/text when you drag these IO's in the Query designer & display them as Key & Text so that you will be able to see both keyvalues & the text loaded for them.

Hope it is clear & helpful!

Regards,

Pavan

Former Member
0 Kudos

Hi,

According to star schema that BW infocubes used, text of master data does not store in infocube, they are stored in texts of master data.

To see what the texts are loaded into info objects;

1. go to RSD1 t-code.

2. Give the info object (0MATERIAL or 0VENDOR)

3. press dispay and go to master data/texts tab.

4. Go to text table properties, and double click text table

5. when you see the contents of this table, you can see the texts.

Former Member
0 Kudos

Thank you.

I see 2 rows after i finish the last step.

But when i select the first row with field VENDOR dataelement /BI0/OIVENDOR and click on mainmenu that says contents it says(no table entries for a specified key). Does this mean the texts are not loaded.

But i am able to see the texts in PSA.Please advise.

Thanks

Former Member
0 Kudos

If you are looking for the data in text tables for material -you should be looking at /BI0/TMATERIAL

To get the exact text table name -RSA1 - infoobject: material : 3rd tab : Master data/texts and this gives you the text table name.