Query builder - CMS Metadatabase

[Former Member]

Hi BusinessObjects Gurus,

Does any have experience with the query builder, for 4.0, accessing the CMS metadata repository?

I would like to identify which webi reports that has been modified in a given
time period and was thinking of building a query which could be launched in Query Builder Tool.

Does any know if there is an “4.0” version of this wiki page:
http://wiki.sdn.sap.com/wiki/display/BOBJ/How+to+browse+CMS+repository

or where I can get the same information. 

Another approach could be to scan the input file repository on OS level based
on time parm but I think the best solution would be to query the Metadat
arepository.

[liliana_gil]

Hi Bruce, for sure the information is comming late for you, but it will be useful for other colleagues:

Please see this document for 4.0: http://scn.sap.com/docs/DOC-42952

Best Regards,

Liliana

[Former Member]

Hi,

I have tested following query with success in query builder 4.0, it will retrieve all webi reports changed in the last year:

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='Webi' and SI_UPDATE_TS between '2011.12.16' and '2012.12.16'

BR

[TammyPowlas]

Hi

This is the top level BI space, and your question will be better answered in the BI Platform space. 

I will move this thread.

Tammy (Moderator)