I want to run report based on 0MATERIAL on two cubes 0PCA_C01 and ZCOPC_C08. I dont have 0MATERIAL in cube 0PCA_C01.
Both of the cubes are in production. I am trying to enhance the data source 0EC_PCA_1 (for cube 0PCA_C01) to bring in 0MATERIAL.
> Is this the right way to do it?
If it is then, do i need to write the code in funciton module after appending the 0MATERIAL fields to the
data source. does any body have the code or plz help me step by step to write the code in CMOD....which tables should i go to get the 0MATERIAL.
> Most importantly, does enhancing the datasource 0EC_PCA_1 with omaterial affect the omaterial in the datasource for my second cube (can the same infoobject be in two data sources..bcoz master data is common for all cubes)....
I want to do this right....as both the cubes are in production.....plz help me..
Plz address any issues like data loss bcoz of enhancing datasource in production or something like that
thanks in advance,
> useful inputs will be rewarded