Promotion jobs and OLAP Connections

[Former Member]

Hi,

We are using BI Platform 4.0 SP2 patch 8. We are trying to understand what 'overrides' mean in the LCM environment.

We are trying to move some webi reports from our development server to the production server using promotion jobs. When we add a webi report inside a job, and manage dependencies we can see that OLAP connections needed are also included, and also the corresponding BEx query. Promotion job always finishes with partial success and the only error message is about the OLAP Connection:

Resolution Status=Copied, Dependency Status=Some of the required dependencies are not selected., Commit Status=Commit attempted and failed., Promotion Status=Failure : Must create object under it's defined root folder.

All dependencies are, for sure, selected but the OLAP Connection is the only object that is not moved to production system.

Override for this OLAP Connection is active and promoted.

As far I know overriding connections is the mechanism needed to 'copy' the object and adapt it to the production environment, for example a connection in dev system that points to a test datawarehouse system is converted to a connection in prod system that points to a production datawarehouse. Quite similar to the conversion of logical system names that we have in SAP datawarehouse when transporting objects. Do I'm right ?

Regards,

Joan B. Altadill

CELSA IT Services

[Henry_Banks]

Hi,

LCM questions should be posted here: SAP BusinessObjects BI Solution Architecture

.. as it concerns server administration accross the deployment. (rather than report design)

You should check the online Help files in the LCM application itself, or check the LCM administrators guide. It has loads of sections about overrides

including ths definition (for starters)

Override Settings - This option enables you to override the properties of infoobjects such as data connection, CR connection, and Qaaws, within the job that were promoted to the destination system. It overrides the properties of infoobjects that were promoted from the source system.

Cheers,

H

[denis_konovalov]

and all connections that will be overrriden should be promoted prior to creating overrrides...