Cube Enhancement - clarrifications,

[Former Member]

Hi frnds,

im going to enhance a cube with some additional fields, but before that im in the process of analyzing the existing dataflow into the cube, the cube is loaded from 7 different datasources all Standard ones,

now from the fields i have in datasources i need to find from which table it is excatly picking the data from..

so could any one tell what is the best way to work on this ( i.e) how to find the db table from where the data is picked from ?? , because i am fing it very difficult to do this,

and also kindly refer some documents on cube enhancement

Thanks for any help ,

raky

[Former Member · Accepted solution]

Hi Rakesh,

There are lots of discussions already. Search the forum. u will get it!

Regards,

Sree

[Former Member · Accepted solution]

hi sree,

thanks,

now from the fields i have in datasources i need to find from which table it is excatly picking the data from..

can u suggest some easy way for this?

thanks,

raky

[former_member188975 · Accepted solution]

Hi Rakesh,

Among other ways, as you mention that the data sources are standard, there is a good chance that you can get this information from looking up the data source in SAP help. Post back with the name of the data sources if you need more help on this.

[Former Member · Accepted solution]

Hi bhanu,

These are the datasources,

0IM_FA_IP_1 , 0IM_FA_IP_2, 0CO_OM_OPA_3,0CO_OM_OPA_1,

0CO_OM_OPA_2,

Thanks for any help,

raky

[former_member188975 · Accepted solution]

Hi Raky,

Check these links:

0CO_OM_OPA_1: http://help.sap.com/saphelp_nw04/helpdata/en/3c/848fc1effdcc4c9869e7c1a55a8baf/content.htm

0CO_OM_OPA_2:

http://help.sap.com/saphelp_nw04/helpdata/en/43/de43fcf6e2154bbbbcecbc63cdf287/content.htm

0CO_OM_OPA_3:

http://help.sap.com/saphelp_nw04/helpdata/en/60/0f07d3532c864aab7ec5f113146da2/content.htm

0IM_FA_IP_1

http://help.sap.com/saphelp_nw04/helpdata/en/a9/d9383ffcca450ee10000000a114084/content.htm

0IM_FA_IP_2:

http://help.sap.com/saphelp_nw04/helpdata/en/05/da383ffcca450ee10000000a114084/content.htm

Hope this helps...

[Former Member · Accepted solution]

HI Bhanu,

Really a great help , thank you very much,

Actually i was in the process of debugging the system program behind the datasource, and really it takes up a lot of time to investigate..

Thanks,

raky

[Former Member]

Rakesh,

There is no easy way to link an InfoObject in BW to a field in an R/3 table. Has to be through debugging or asking around!

Quickest way is to use the name of the object. For e.g. 0CUSTOMER comes from the customer master table, etc.

Cheers

Aneesh