BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

List objects used in Web Intelligence reports
9 members found this topic helpful
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next
 
Search this topic... | Search SDK (VBA/ASP/JSP)... | Search Box
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Author Message
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Wed Dec 28, 2011 1:10 pm 
Post subject: List objects used in Web Intelligence reports

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 shouldn’t be any new line values in the file
-- Also replace ^t (tab value) with empty.Reason: To make sure that there shouldn’t 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.


Last edited by Rupesh G on Wed Oct 30, 2013 8:06 am, edited 5 times in total
Back to top
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Wed Dec 28, 2011 4:45 pm 
Post subject: Re: List objects used in Web Intelligence reports

Hi All,

While i was testing the code- if found one exception and i have fixed it.
The exception was with fetching number of condition objects in the code.
To handle this i just added if(query.hasCondition()) block in the code.

Pleas find the updated version of the code and let me know if there any issues, so that i can fix it and will update the same.

Also, attaching sample output of the dump (excel format).

Note:
To debug the code, you can add System.out.println("message/variable") in the code which would be easy to fix if there is any issue.

Thanks,
Rupesh
Back to top
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Wed Dec 28, 2011 4:48 pm 
Post subject: Re: List objects used in Web Intelligence reports

Attaching Sample output Webi Report dump.

Thanks,
Rupesh
Back to top
KA_Analyst
Senior Member
Senior Member



Joined: 24 Feb 2009

Posts: 99


flag
PostPosted: Wed Jan 11, 2012 11:19 am 
Post subject: Re: List objects used in Web Intelligence reports

Rupesh, I'm looking into extracting the objects and variables used in my report but I'm not that technical minded.

What do I need to do to follow your instructions?
Back to top
nychiller786
Forum Member
Forum Member



Joined: 22 Feb 2010

Posts: 21



PostPosted: Wed Jan 11, 2012 1:29 pm 
Post subject: Re: List objects used in Web Intelligence reports

I am trying to excrete the objects from the Webi reports but I am not unable to do so. I am not getting anything back when I open the excel document. Can you please let me know how to use this code? Thanks for your help.
Back to top
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Tue Jan 24, 2012 5:42 am 
Post subject: Re: List objects used in Web Intelligence reports

Hi,

There are few exceptions in the code ( Query condition nodes, sub-query conditons, rank, combined queries).

Currently, i'm working to eliminate these exceptions.
I would post the code once i'm done with and also, i will provide a doc which contains a screen-shots on how to execute a java code using Eclipse IDE.

Thanks,
Rupesh
Back to top
nychiller786
Forum Member
Forum Member



Joined: 22 Feb 2010

Posts: 21



PostPosted: Tue Jan 24, 2012 11:44 am 
Post subject: Re: List objects used in Web Intelligence reports

I would really appreciate it, if you can provide the code once you done, It is kind a urgent requirements we have from the client. Thanks for your reply.
Back to top
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Wed Jan 25, 2012 7:44 am 
Post subject: Re: List objects used in Web Intelligence reports

I have updated the java code(ListObjectsUsedWebI_V1.2.txt)

Please note that while taking report dump, do not include the reports having DB ranking at DataProvider level (as i have not included in the code to handle,so it will thrown an error). Remaining exceptions which i have mentioned earlier have been fixed.

Do let me know if any exceptions.

Thanks,
Rupesh


Last edited by Rupesh G on Wed Sep 05, 2012 2:59 pm, edited 2 times in total
Back to top
nychiller786
Forum Member
Forum Member



Joined: 22 Feb 2010

Posts: 21



PostPosted: Wed Jan 25, 2012 11:10 am 
Post subject: Re: List objects used in Web Intelligence reports

Thanks for providing the code, I have a question regarding the code, do I need to run the code in Eclipse IDE?
Back to top
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Wed Jan 25, 2012 12:06 pm 
Post subject: Re: List objects used in Web Intelligence reports

Yes , run the code using eclipse IDE. In the code mention either report ids or report names(Si_ID,SI_NAME).
Back to top
nychiller786
Forum Member
Forum Member



Joined: 22 Feb 2010

Posts: 21



PostPosted: Wed Jan 25, 2012 12:53 pm 
Post subject: Re: List objects used in Web Intelligence reports

I am getting an errors while running the code, Can you please find the attached screen shot. Let me know the steps how to resolve this issue. Thanks for your help.
Back to top
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Wed Jan 25, 2012 1:00 pm 
Post subject: Re: List objects used in Web Intelligence reports

Unable to see the attachment
Back to top
Rupesh G
Senior Member
Senior Member



Joined: 22 Oct 2009

Posts: 52



PostPosted: Wed Jan 25, 2012 1:04 pm 
Post subject: Re: List objects used in Web Intelligence reports

Make sure that class name and java file name is same. Give all the required credentials and environment details in the code.
Back to top
nychiller786
Forum Member
Forum Member



Joined: 22 Feb 2010

Posts: 21



PostPosted: Wed Jan 25, 2012 2:26 pm 
Post subject: Re: List objects used in Web Intelligence reports

Yes, the class name and the java code are same. Can you please find the attached file?

Last edited by nychiller786 on Tue Jan 31, 2012 1:54 pm, edited 1 time in total
Back to top
nychiller786
Forum Member
Forum Member



Joined: 22 Feb 2010

Posts: 21



PostPosted: Wed Jan 25, 2012 3:02 pm 
Post subject: Re: List objects used in Web Intelligence reports

The code seems to be working now; however I am getting some other error now.
Today. toString 20120125
Logged in....!
Not a valid query. (FWB 00025)

Session logged off
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 1 of 10 All times are GMT - 5 Hours
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0327 seconds using 17 queries. (SQL 0.0026 Parse 0.0010 Other 0.0291)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo