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!


yeneb (BOB member since 2019-10-07)

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.


joepeters :us: (BOB member since 2002-08-29)