SID where-used in cubes list

[Former Member]

We are on BW 3.5 ..

Is there a module / program which will give me where-used list of a given master data SID value in cubes ?

I am trying to locate which cube(s) a master data value is stored .

I know the long hard way of going through the dimensions and fact table s etc ..

Thanks.

Hitesh

[Former Member · Accepted solution]

First find out the SID value by looking at the S table.

Then use the function module RSDDCVER_USAGE_MDATA_BY_SID.

I_IOBJNM = InfoObject technical name

I_T_SID_CHECK = SID Value

I_FIRST_CALL = X

Depending on how 'popular' the InfoObject is and how big the InfoProviders are, the search may run for very long time.

Good luck.

[Former Member]

Hi Krishna

i have a doubt here..

i will explain one scenario

i have one master 0abcd.  it is getting loaded from some souce X. this 0abcd is used in one of the cube C1 and it is getting data from some dso D1.

So because of this transaction data, we get few values like z1, z2, z3 into my 0abcd.

to be noted.  This z1, z2, z3 dint come to 0abcd from its own source.  It came because of some transaction data.

Now if i used the above mentioned step. ie. "You can go to RSADMIN tcode and select Pack.Mas.Data Del. checkbox to enable the new MD deletion tool" would it show me the where used list of z1, z2, z3 values also ?

Because when i tried it, it dint show me those where used lists.  share your view regarding this.

Thanks,

Annapoorani

[former_member188080]

see if this document is of any help for u

http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2012/01/01/bw-730-different-ways-to-...

also in RSRV there is option to delete the unwanted DIMIDs.

Thanks and regards

Kiran

[Former Member]

Hi Kiran,

I still use BI 7.0 and i dont have this feature that is mentioned in the document. is there any other way i could use to get the dimension table details.

Thanks,

Annapoorani

[Former Member]

Hello,

This new tool is available in BI 7.0 (SP 23). Check if you are in SP23. If yes,

You can go to RSADMIN tcode and select Pack.Mas.Data Del. checkbox to enable the new MD deletion tool.

Regards,

Krishna Tangudu

[Former Member]

Thanks Krishna.. Your reply was realy help ful.. I have SP 23 and i could complete my task.

[Former Member]

Hi,

you can simply use metadata search and find out in which cubes the object is used.

Then look if those infocubes are filled.

Derya

[Former Member]

Sudhi and Derkya,

I finally ended up writing a abap to locate the dim tables where SID values exist which is much quicker and can selectively find SID .

I could have used the master data delete option which would then give me where used list but runs a lot longer for bunch of SIDS.

Appreciate your help guys.

Hitesh

[Former Member]

Hitesh,

This is an interesting way, could you please share your code with me also. derya.akcakaya at gmail.com

Thanks

Derya

[Former Member]

Hi Derya,

Sent you the code. Hope you find this useful. One thing, it only checks for SID values for objects located in Dimension tables and not for attributes...

Hope it helps ..

Hitesh Mehta

[Former Member]

Hitesh,

would you mind to share code with me christian.roettgers (at) nurdie.com

Thanks in advance!

Regards,

Christian

[Former Member]

Hi,

would you mind to share code with me christian.roettgers (at) nurdie.com

Thanks in advance!

Regards,

Christian

[Former Member]

Hi

Is the function module RSDDCVER_USAGE_MDATA_BY_SID given by sudhi is not working?

Regards,

Venkatesh

[Former Member]

I tried using that FM. but i am getting some runtime error while executing it.  Am not sure if i had given some wrong parameters.

[Former Member]

Hi Hitesh,

Can you able to send the code to apvision.2014@gmail.com urgently

thanks for your help in advance..

Cheers,

Ram

[Former Member]

It works fine for Cubes for fetching the where used list  but it seems returning only one DSO for each SID though it has more relevant DSOs for a given SIDs,

It looks like there is some issue with FM : RSDDCVER_USAGE_MDATA_ODSO which gets triggered  in turn of this FM.

Best Regards,

Ram