BOBJ Queries

Below are the SQL queries used to read reports from BOBJ server


Reading folders
query://{select * from ci_infoobjects where  SI_SPECIFIC_KIND like '%Folder%'}

Universes
query://{select * from ci_appobjects where  SI_SPECIFIC_KIND = ''DSL.Universe''}

Webi
query://{select * from ci_infoobjects where  SI_WEBI_DOC_PROPERTIES like %QUERY_001%}

Lumira
variant = 'query://{SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND = ''VISILums''}'

Design Studio
query://{SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND = ''AAD.AnalysisApplication''}

Reading Documents
PDF    :   query://{select * from ci_infoobjects where  SI_SPECIFIC_KIND like ''%pdf%''}
Excel  :   query://{select * from ci_infoobjects where  SI_SPECIFIC_KIND like ''%excel%''}
PPt      :   query://{select * from ci_infoobjects where  SI_SPECIFIC_KIND like ''%powerpoint%''}
Word  :    query://{select * from ci_infoobjects where  SI_SPECIFIC_KIND like ''%word%''}