Impact of table

[naveen_kumar29091984]

Hi

I want to do impact analysis on a database table

1.what are all the universe using this table?

2.what are all the reports will get impact from this table?

3.List of all reports belongs to that universe and tables.

please try to give the query  rather than links (query builder query)

Regards,

NK

[former_member191664 · Accepted solution]

Query Builder won't cut this for you; check out SAP BusinessObjects Information Steward.

Hope this helps,

Jin-Chong

[naveen_kumar29091984 · Accepted solution]

Ok thanks .

But is it possible  to list of all reports and universe which got changes in live or promoted to live for last month.

Universes, deskI, webi.

Point 3 any query

[former_member191664 · Accepted solution]

To list all the reports that use a specific universe

SELECT SI_ID, SI_NAME, SI_KIND, SI_OWNER FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS

Where PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'") AND SI_INSTANCE = 0 AND SI_UPDATE_TS > '2014.08.31'

Note that

- the SI_KIND will tell you what type of report it is, Webi, Crystal, FullClient, etc.

- assuming the report is updated since 9/1/2014.

Hope this helps,

Jin-Chong

[naveen_kumar29091984]

Hi,

How to get list of all universe and their reports along with universe and report Path.?

Please send me query, So that I can close this tread.

Regards,

NK