BusinessObjects Board

Lcm_cli.bat Query for WebI Reports that Source From Specified Universe

general discussion
#1

I’m trying to build a .properties file to pass to the lcm_cli.bat that will promote all of the reports that are sourced from a specified universe. I’ve tried the following queries:

Select SI_NAME, SI_AUTHOR, SI_WEBI_DOC_PROPERTIES From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'") And SI_KIND = 'WebI'And  SI_INSTANCE = 0

and

Select SI_NAME, SI_AUTHOR, SI_WEBI_DOC_PROPERTIES From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'") And DESCENDANTS("SI_NAME='Folder Hierarchy'", "SI_ID in (23)") And SI_KIND = 'WebI'And  SI_INSTANCE = 0

Both of these options return errors

Failed to get dependencies of the job.(PRS 00048)
The property with ID SI_CUID does not exist in the object (FWM 02021)
GetRelatedDependenciesFailed

Both queries return the expected reports when run in Query Builder.

Searching for the error codes on the SAP Site hasn’t offered anything productive.

Any suggestions?

#2

Try SELECT * FROM …

You need to add at least SI_CUID to get around that error, but I’m pretty sure other properties are needed for LCM to function.

#3

Yes, I ended up using the following for the query:

Select top 10000 static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH, SI_NAME, SI_AUTHOR, SI_WEBI_DOC_PROPERTIES From CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Webi-Universe'", "SI_NAME = 'eFashion'") And DESCENDANTS("SI_NAME='Folder Hierarchy'", "SI_ID in (23)") And SI_KIND = 'WebI'And  SI_INSTANCE = 0