Impact analysis In BO 4.1 Webi.we want to know that how many reports has been used the particular table.

[former_member1245769]

Hi Friends,

I am working on SAP BO 4.1..I have one query here.

we have 400 webi reports.Now we want to know that how many reports has been used the  particular table.

In the Data base side they are going to change the table.so we want to know how many report has been used that particular table. Manually its bit difficult because we have more than 10 query's for each report

Just we want to know If that table has been used in the report.

1)which query has been used.

2)what is the object name

Could you please tall me any automated way to this.

Thank you in advance.

Regards,

Ramki.

[former_member201488 · Accepted solution]

If you have auditing enabled and configured appropriately, you should be able to query the objects the report uses, but not by table or query (in my experience).

See:

Objects Associated with a Universe

If auditing is configured appropriately and you're recording the query SQL, you could potentially parse this for mention of the table - but in my experience, this approach is extremely resource intensive - plus it won't tell you which query contains the object.

See:

Report Queries

Suggest this is a job for the SDK.

HTH

NMG

[naveen_kumar29091984 · Accepted solution]

Hi Neil,

I have a requirement, which I need to automate -Universe Impact analyer.

We are currently using query builder and notepad ++ as manual activity to do Impact on unverse objects,what are all the steps do I need to follow in order to integrate via Java SDK or .Dot net.

Please let us know.

Many Thanks

Naveen

[former_member201488 · Accepted solution]

Apologies, I cannot assist with your request (Java / SDK). You may want to repost in an alternative forum (SDK) for greater visibility?

[naveen_kumar29091984 · Accepted solution]

Yes,I do Thanks