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:
SELECT SI_NAME, SI_ID
(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
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 :
SI_NAME , SI_WEBI_DOC_PROPERTIES
SI_KIND = ‘Webi’ AND
SI_WEBI_DOC_PROPERTIES like ‘%DSNAME=%Z%’
But we our DSNAME have not name rule, so… it wonÂ´t work.
yeneb (BOB member since 2019-10-07)