Hi all!
I would like to get a list with all the reports that:
-
It´s Data Source is an Universe.
-
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)