BI:Tables for Query and InfoCube

[Former Member]

Hi All,

Is there any table in SAP BI which shows the relationship between a query and a InfCube?...Meaning a table where I can find the InfoCube on which a query has been built?

Also How will I find the authorization releavant InfoObjects within an InfoCube?

Awaiting your reply

Thanks in advnance,

Ramkumar

[jabella]

Hello Rankumar,

The best option is to use the Repositoy to view all these data.

To access this tool execute transaction RSA1 and in the left bottom click on "Metadata Repository". You will get a list of all the object, including queries, infocubes, infoareas, etc. Clicking on each one, you will get lot of info regarding the object.

Regards, Jose

[Former Member]

Hi Ramkumar,

There's a very informative Wiki on this and it helped me a lot with these things

https://wiki.sdn.sap.com/wiki/display/BI/ImportantTablesinSAPBI%28NW2004%29

Regards,

Zaheer

[Former Member]

Hi.

You can find the relation between Query and InfoCube in table RSRREPDIR.

Use the following selections:

OBJVERS = 'A'

COMPTYPE = 'REP'

COMPID = technical name of your query

regards,

Lars