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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (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 Previous  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
jvmauricio
Principal Member
Principal Member



Joined: 03 Aug 2009
ASUG Icon
Posts: 377
Location: Bagong Silang, Caloocan


flag
PostPosted: Tue May 05, 2015 4:53 am 
Post subject: Re: List objects used in Web Intelligence reports

Unfortunately, the file is currently unreachable icon_sad.gif anyone have a mirror of the updated program?
_________________
---------------------------------------------------

“Attempting to force one technology or tool to satisfy a particular need for which another tool
is more effective and efficient is like attempting to drive a screw into a wall with
a hammer when a screwdriver is at hand: the screw may eventually enter the wall but at what cost?”


-Dr Edgar “Ted” Codd (1923-2003)
-The Father of OLAP principles
Back to top
hoang09876543
Forum Member
Forum Member



Joined: 04 May 2015

Posts: 6



PostPosted: Mon Jun 08, 2015 7:59 am 
Post subject: Re: List objects used in Web Intelligence reports

Hello,

We are in BI 4.1 and this Jar file is returning empty excel file.

Please advise
Back to top
Madu
Senior Member
Senior Member



Joined: 08 Feb 2008
ASUG Icon
Posts: 87
Location: los Angeles


flag
PostPosted: Tue Jul 07, 2015 6:25 pm 
Post subject: Re: List objects used in Web Intelligence reports

Thanks for the great tool.

I have tried on BOXI R3 it work well but not in BI 4.1 (producing empty excel) . Any suggestions experts.
Back to top
nishant2419
Forum Member
Forum Member



Joined: 25 Jan 2016

Posts: 1



PostPosted: Mon Jan 25, 2016 3:58 am 
Post subject: Re: List objects used in Web Intelligence reports

Hi ,

Is this will code work with BO 4.1 and also couldn't able to find documents ?

Could you please re-send the documents to post ?

Regards,
Nishant
Back to top
Navneet Kaur
Senior Member
Senior Member



Joined: 18 Nov 2015

Posts: 33



PostPosted: Wed Mar 02, 2016 5:41 am 
Post subject: Re: List objects used in Web Intelligence reports

Hi Rupesh,

Thanks for the utility shared by you. Its really helpful.

I have list of objects and i want to see which report is using those objects, Can i get this information from your code.Extracting each and every report is a very long process, because we have 2000+ reports
Your help would be appreciated.
Many thanks in advance.

Regards
Navneet Kaur
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Wed Mar 09, 2016 10:14 am 
Post subject: Re: List objects used in Web Intelligence reports

This code probably will NOT work in 4.1 - most of the ReportEngine SDK, which this uses, has been deprecated and the functionality moved to the RESTful Web Services SDK.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
preethimala
Forum Member
Forum Member



Joined: 18 Apr 2016

Posts: 4



PostPosted: Mon Apr 18, 2016 1:10 am 
Post subject: Re: List objects used in Web Intelligence reports

Hi Rupesh,

The code you posted is not working in BO 4.1 as many methods were deprecated.

To get objects and variables, i used Restful web services SDK.
But I would like to find out the class name where an object belongs to.

Could you please help me in getting class name for an object using restful webservices in BO 4.1

Thanks and Regards,
Preethi
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Mon Apr 18, 2016 11:33 am 
Post subject: Re: List objects used in Web Intelligence reports

Please see my response to your question on SCN: http://scn.sap.com/community/bi-platform/java-sdk/blog/2015/09/16/get-universe-objects-used-in-a-web-intelligence-documents-dataprovider#comment-664861

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
ash0550
Principal Member
Principal Member



Joined: 12 Sep 2011

Posts: 257


flag
PostPosted: Fri Jun 10, 2016 3:54 pm 
Post subject: Re: List objects used in Web Intelligence reports

Does this work with BO 4.1 SP4
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Mon Jun 13, 2016 8:32 am 
Post subject: Re: List objects used in Web Intelligence reports

The code that was posted with this will not work in 4.x. Most of the ReportEngine SDK was deprecated. Instead, you have to use the RESTful Web Services SDK to get information about which objects are used on a report.

This is actually not a bad thing - the RESTful Web Services SDK does not require the installation of any design-time or run-time files. All it requires is that a Web Application Container Server configured with the RESTful Web Services service is running in your server cluster. The only other thing you need is the ability to parse either XML or JSON to get the data.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
izzino
Forum Member
Forum Member



Joined: 29 Jun 2016

Posts: 6



PostPosted: Wed Jun 29, 2016 12:21 pm 
Post subject: Re: List objects used in Web Intelligence reports

Thanks for the update Hilfy, it's kind of crazy how a solution from so long ago is still so relevant. However, I have a bit of an addition to the original question. I'm trying to create a dashboard that will give me the health of the data in any given report based on the ETL jobs that bring the data into our database. I currently have a table with all the ETL jobs and their statuses consolidated into a table. What I'd like to be able to do is match the reports to the tables that populate them so I could then match those tables to jobs. Currently the only way I have found to do this is to go each individual report and look at the query script, but doing that for all of them would take forever! nonod.gif
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Wed Jun 29, 2016 3:53 pm 
Post subject: Re: List objects used in Web Intelligence reports

If you pulled the information about the reports and stored it in a database, then updated it on a regular basis, you could link to that instead of trying to get the info on the fly.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
izzino
Forum Member
Forum Member



Joined: 29 Jun 2016

Posts: 6



PostPosted: Wed Jun 29, 2016 5:14 pm 
Post subject: Re: List objects used in Web Intelligence reports

That makes a lot of sense.Thanks! What would a program like that look like though? How could I make the the program look through the query scripts and pull that data? Would I be using the BI platform java sdk or could I use the restful API?

Sorry if these are novice questions while I do have experience in java this is the first time I've worked with the BOBJ SDKs and this is also the first time I've had the opportunity to speak to an expert haha
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Wed Jun 29, 2016 7:19 pm 
Post subject: Re: List objects used in Web Intelligence reports

Here's how I have done it. The loadFolders method is recursive so that it will walk down the folder tree to get the reports.

1. Log-in to the CMS. Use a token to log in to the RESTful Web Services under the same session.

2. Select SI_ID, SI_NAME from CI_INFOOBJECTS where SI_KIND = 'Folder' and SI_PARENTID = 23 (this is the top-level "Public" folder in 4.x, use 0 instead if you're on 3.1.)

3. For each folder InfoObject in the above query, call loadFolder() with the SI_ID.

4. loadFolder() logic:
a. Select SI_ID, SI_NAME from CI_INFOOBJECTS where SI_KIND = 'Folder' and SI_PARENTID = the SI_ID value from the current call to loadFolder().
b. For each sub-folder InfoObject in the query, call loadFolder() with the sub-folder's SI_ID.
c. Select SI_ID, SI_NAME CI_INFOOBJECTS where SI_KIND = 'Webi' and SI_PARENTID = the SI_ID value from the current call to loadFolder().
d. For each Webi InfoObject in the query, call loadReport().

5. loadReport() logic:
a. Get the IDs of all of the data providers in the report: http://server:6405/biprws/raylight/v1/documents/SI_ID value from current call to loadReport[/]/dataproviders
b. For each data provider, get it's query: http://server:6405/biprws/raylight/v1/documents/[i]SI_ID value from current call to loadReport[/]/dataproviders/[i]Dataprovider ID

c. In the resulting XML, get the contents of the "query" element to get the SQL. Also, the "expression" elements will tell you which objects from the universe are being use (but it doesn't give the field info for the object...)
d. Save the data for the report.

This particular process can be done with either the .NET or Java SDK.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
izzino
Forum Member
Forum Member



Joined: 29 Jun 2016

Posts: 6



PostPosted: Thu Jun 30, 2016 8:55 am 
Post subject: Re: List objects used in Web Intelligence reports

Wow, thanks a lot Hilfy. It's people like you that keep this community going and keep people like me in a job! I might be back with a couple of follow ups, but this should keep me busy for awhile.

Btw, would you happen to know where I could find some sample code for a similar program?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 8 of 10 All times are GMT - 5 Hours
Goto page Previous  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.0367 seconds using 17 queries. (SQL 0.0073 Parse 0.0010 Other 0.0284)
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