Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Function to show Universe Objects used by reports

Is there a function in XI3.1 to see all of the reports in which a particular Object is being used?

I don't see any of the canned audit reports that would show this.

Example: I have a Universe Object called "Ins. Proper Name'' and I want to see how many of our reports are using this object.

Thanks,

Mike

Former Member
Former Member replied

Mike,

Here is what I use:

Result Objects:

-Universe Name from Actions/Action Details

-Action Type from Actions

-Document Name from Actions/Document Operation

-Action Time from Actions

-Action Type Detail from Action/Action Type

Query Filters:

-Action Time Between <Begin Date> and <End Date>

Report Filters:

-Action Type In List: SQL Value

Note: Action Type Detail contains the SQL for every query that is run within the date range provided. While the SQL contains the name of every query in every report, it does not use reference a universe object by name. i,e, to check whether a specific universe object exists in the report, you will have to search for the object's sql.

Also, I use an additional another query filter to return only objects that match a specific pattern.

Let me know if you need anything else.

Best,

Srinivas

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question