Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 27, 2010 at 04:10 PM

    Michael,

    Are you looking for a list of all reports that use a specifc (eg. a table/column) object in a universe or all reports that use a specific universe.

    I think Anil's query will list all reports attached to a specific universe.

    Best,

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello, Srinivas.

      I'm using SAP BI Platform 4.1.

      I can't find the object  Action Type In List: SQL Value, you use in BO 3.1

      Which is the equivalent object I have to use instead of it, please?

  • avatar image
    Former Member
    Nov 24, 2015 at 09:11 PM

    Is there is any way to get report level filter details for all reports ? I need to get list of all reports where there is either block level /table level / report level filter is applied.

    - Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 26, 2010 at 03:20 PM

    Query the Universeu2019s Reports

    SELECT si_id, si_name, si_webi, si_cuid FROM CI_AppObjects WHERE si_name = 'UNIVERSE_NAME' AND si_kind = 'Universe'

    Take that list of report object IDs from the previous step and parse the list so that each ID is separated by a comma. Then substitute that list for the string u201C111111,222222,33333 below in the SQL:

    SELECT si_id, si_name, si_universe, si_cuid FROM CI_InfoObjects WHERE si_id IN (111111,222222,33333) AND si_kind = 'WebI' AND si_instance = 0

    Thanks,

    Anil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Anil,

      I was able to get to the Query Builder from the http path. I will run the queries to get results.

      Thank you for the quick reply and answers,

      Mike