Crystal off Query Builder

[Former Member]

can you create a crystal report off this query builder statment?

SELECT SI_ID, SI_NAME, SI_Webi, SI_OWNER

FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS

Where PARENTS("SI_NAME='CrystalReport-BusinessView'","SI_NAME ='Xtreme Business View'")

[Former Member]

Unfortunately, you can not. In fact you will not find these tables for example CI_INFOOBJECTS in the CMS database.

The reason being BusinessObjects employs a persistence framework to serialize the object model to the CMS repository (which is a database). A persistence framework is a structure that persists the object model to an underlying data source.In BusinessObjects Enterprise, the persistence framework does not encapsulate class retrieval. Therefore, you write your own persistence code to retrieve classes from the CMS repository.

Hope this helps!

[Former Member]

So the only way of reporting off the CMS is via SDK? You can not use the ci or si tables in Webi, Deski or Crystal?

[Former Member]

Yup.

[former_member11696]

Also it's recommended NOT to report off the CMS data directly, this causes delays and could have performance issues in Enterprise for your users.

Thank you

Don