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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

BO Query Builder


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
yeneb
Forum Member
Forum Member



Joined: 07 Oct 2019

Posts: 2



PostPosted: Tue Jun 30, 2020 3:22 am 
Post subject: BO Query Builder

Hi all!

I would like to get a list with all the reports that:

1. It´s Data Source is an Universe.

2. It´s Data Source is a BEX Query.

I have to do with Query Builder.

For the 1. Reports using universe i can do in 2 steps:
1 Step:
SELECT SI_NAME, SI_ID
FROM CI_APPOBJECTS
WHERE SI_KIND='Universe'
(I get all universe name incluiding it´s webi list ID)

2 Step: Then, I use the list of IDs to get a list of report names that use this Universe
SELECT SI_NAME,SI_DESCRIPTION, SI_ID,SI_AUTHOR,SI_PARENT_FOLDER,SI_UNIVERSE,SI_HAS_PROMPTS
FROM CI_INFOOBJECTS
WHERE SI_ID IN (nnnnn,nnnnn,nnnnn)

Maybe another option could be something like that:
SELECT SI_ID, SI_KIND, SI_NAME FROM CI_INFOOBJECTS WHERE SI_UNIVERSE.SI_TOTAL>0


But I have NO IDEA how I could get Webi with BEX Query as Data Source.
One way could be :
SELECT

SI_NAME , SI_WEBI_DOC_PROPERTIES

FROM CI_INFOOBJECTS

WHERE

SI_KIND = 'Webi' AND

SI_WEBI_DOC_PROPERTIES like '%DSNAME=%Z%'

But we our DSNAME have not name rule, so.. it won´t work.

Any idea?

Thanks!
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6701
Location: Connecticut, USA


flag
PostPosted: Sat Jul 04, 2020 11:25 am 
Post subject: Re: BO Query Builder

Hi, yeneb.

We don't use BEX so I can't answer your question directly. But I would suggest simply doing "select * from ci_infoobjects where si_id=...", using the ID of a known WebI report with a BEX query. Then see if you can identify the properties in the result that tie to the BEX query.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
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.0272 seconds using 17 queries. (SQL 0.0028 Parse 0.0008 Other 0.0235)
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