Complete Report Analysis for an Object

[system]

Hi All,

Is there a way to document all places within a report that an object is being used .

Ex : Object A could be used as an operand in variable definitons or formula, as a table filter, as a where condition in Data Provider, in breaks, sorts etc

Actually many times we get a requirement to analyse the impact of change in data values for the objects or decommissioing an object. Rigth now we do the impact anlaysis manually, so we want to know if there is a better way to do it.

Thanks for help in advance!!
Regards,
Ankit

---

at&t (BOB member since 2007-04-05)

[system]

Hi,

This utility can help to some extent:

DeskI Documents Inspector

Author: Marek Chladny Author notes: Platform: BO XIr2 How to use it: Save all DeskI reports that will be checked into a separate working folder. Open DeskI Documents Inspector in DeskI of BO XIr2. Enable macros (if you get the message that the report contains macros). Use “Select working folder” button and navigate to the folder that contains reports. Type in a keyword in the “search keyword” box. Use * (asterisk) for all. Set what will be searched (variables and formulas, data provider …

---

Marek Chladny (BOB member since 2003-11-27)

[system]

You could also look at BO Metadata Manager, although, it will cost you…

---

Mak 1 (BOB member since 2005-01-06)

[system]

There are solutions available for your needs. It will all depend on your requirements and needs. All solutions will have some limitations.

It is not possible to know exactly where in a report the object is used.

It is fairly easy to get database table/column --> Universe objects --> Report --> data provider --> formulas

beyond that level it is more complex or not feasible.

Another thing not to underestimate is that there is big difference between used in a report /universe and is it actually used by the users.

---

ClaireB (BOB member since 2002-08-09)

[system]

Dear All,

Can you kindly give any pointers to a third party tool or application which can help to document the metadata details about all the web intelligence reports in a BO XI R2 environment ?

By metadata, I mean the actual web intelligence report structure details like the number of prompts, the number of data providers, the number of variables, the number of formulas, the charts, the number of tabs, the number of filters, etc.

I did try searching about the BO metadata manager but could not get much details. Kindly see if you can give more pointers about this please.

Thanks a lot.

Yours Sincerely,
Ramesh

---

BOXI_Learner (BOB member since 2004-10-08)