Hi All,
Based on the below code which I had created earlier, with the help of my team I have created a utility(with UI) which would generate the Report dump into .xls in one click.
Utility is of size 17MB and you can download it from the below location:-
https://drive.google.com/folderview?id=0B1uumRTyou6KWW45TjhnZFJLMEU&usp=sharing
Currently, the utility is running fine with Enterprise credentials.
Please check the same and let me know if you find any issues.
Regards,
Rupesh
To get the list objects used in Web Intelligence reports, a Java code has been built which would pull the below information in the text file:-
Report Name
Folder Full Path
Report ID
DataProvider Name
Universe/Source
Has Combined Queries in DataProvider
Number of Result Objects/Condition objects in DataProvider
Class Name
Object Name
Operands
Attached java code would consider all the reports present in the repository (Favorites and Public Folders). If a particular folder or reports to be considered then need to do respective changes in the query ( Eg:- select SI_NAME, SI_ID from CI_INFOOBJECTS Where SI_Kind=‘Webi’ would retrieve all the Webi reports present in the repository. We can have some extra condition in the query if required. For example: SI_NAME).
For more information please go through the comments mentioned in the Java Code.
Please use the below steps to get the final dump in an excel sheet:-
– Select the environment to run (do the respective changes in the code)
– A Text file would be created under C:\repdump{todays date} (if required, folder location can be changed in the code)
– Change the extension of the file(.txt) to .doc
– Open the .doc file and hit CTR+H, replace ^013(new line value) with empty.Reason: To make sure that there shouldnt be any new line values in the file
– Also replace ^t (tab value) with empty.Reason: To make sure that there shouldnt be any tab values in the file
– Replace *** with ^013(new line). *** is used as a delimiter to divide the entries of each row
– Change the extension of the file to .xls
– Go to data->Text to Columns->Delimited ->choose # as delimiter
– Save the excel file
Note:
Attaching a Document which contains the screenshots to Configure Eclipse to run BO Java codes.
BO and Eclipse.zip (999.0 KB)
ListObjectsUsedWebI_V1.2.txt (9.0 KB)
Rupesh G (BOB member since 2009-10-22)