Report Objects and List of System Tables/Views in XI R2

building semantic layer
1

Hi BOB,

I want to query specific tables/views from the system/repo database in our XIR2 environment. I am looking for report specific items, such as universe objects and corresponding filter definitions. Do you know how to retreive this information?

If so, PLEASE SHARE! :slight_smile:

If not, please read on, maybe you can assist with another inquiry…

I cannot retreive a list of tables/views from our system database b/c I do not have access. Though, I can use Query Builder. If I can atleast get a list of tables/views in the system database, then I can analyze the data via QB and hopefully find what i am looking for. Do you know how to retreive this list, maybe query a table like “ALL_TABLES”?

Thank you in Advance!

Jdog (BOB member since 2006-05-31)

2

I do not think those are stored in the repository in XI - please see this old topic.

Anita Craig :us: (BOB member since 2002-06-17)