Skip to Content
Author's profile photo Former Member

Promotion Management Overrides

1.     Concept

In a standard development cycle, all the BI content is created in an “Origin” (Dev) system and then moved to other environments. The main challenge faced in this process is updating the Database credentials as per the destination environment.

To overcome this challenge in BI 4.0 we have Promotion Management Overrides. It was present in BOE 3.1 and was known as LCM Mapping. However in BOE 3.1, Mapping was LCM job specific but in BI 4.0 the Overrides are system specific.

You can modify the database credentials for OLAP Connection, Universe Connection, QAAWS Connection and Crystal Reports.

/wp-content/uploads/2014/02/1_385749.jpg

Following is the generalized workflow of LCM Overrides. Database credentials for the entire object in the subsequent LCM jobs will be modified as per the overrides set.

/wp-content/uploads/2014/02/2_385588.jpg

2.     Procedure

Below are the detailed steps with screen shots for the above workflow.

a)     For Movement from Dev to QA

  1. Login into CMC àPromotion Management in Development System.
  2. Click on “Setting “and browse to “Manage Systems”

/wp-content/uploads/2014/02/3_385750.png

3. Highlight the System from which all the content would be migrated to other environments. In most cases it would be the Dev System. Check the “Mark as Origin” box.

/wp-content/uploads/2014/02/4_385769.jpg

1.      4. Save the changes.

2.      5. Browse to “Overrides Settings”.

/wp-content/uploads/2014/02/5_385771.jpg

1.       6. Login into the “Origin” CMS and Scan for Overrides.

/wp-content/uploads/2014/02/6_385776.jpg

1.       7. Once the scan is completed, select the particular override which you want promote and change the status from “Inactive” to “Active” and save the changes.

1.       8. Select the Override which needs to be promoted and click on “Promote Overrides” button.

          /wp-content/uploads/2014/02/7_385775.jpg

1.       9.In the subsequent screen, select the required destination server (QA system) and click on “login”. Enter the credentials of “Destination CMS”. The “Export” button will be replaced with “Promote” button. Click on “Promote” to complete the Promotion.

/wp-content/uploads/2014/02/8_385777.jpg

1.       10. Log off from the “Origin CMS” and Login into the “Destination CMS” and again scan for Overrides.

/wp-content/uploads/2014/02/9_385615.jpg

1.     11.  We should see the Override which we promoted from the Origin CMS. Highlight the Override and click on Edit. Make the necessary changes and save it.

2.      12. If the subsequent LCM Jobs contain the same “Connection” object, the connection properties will be automatically updated as per setting defined in previous steps.

b)     For Movement from QA to Production

Repeat steps 1 through 12, but mark “QA” server as “Origin” and “Production” server as “Destination” system.

3.     Exceptions & Corrective Actions

1.      1. Object Export through BIAR files

a.       Export the Overrides to a BIAR file.

b.      Import the overrides biar in the “Destination CMS”

c.       Scan the “Destination CMS” and edit the imported overrides.

Now you can import LCM BIAR files with objects and overrides will work as expected.

2.       2. Reverse flow of Ad-hoc reports from Production to Development

a.       Use a different CMS as your LCM CMS.

b.      Mark your Prod system as “Origin” and follow steps 1 through 12.

4.     Related SAP Notes

SAP Note

Description

1805615

How to backup and restore the Promotion Management Overrides Database in BI 4.x

1801682

How to reset the “LCM Overrides database” in BI 4.0

1628154

Promotion Management (LCM) usage across multi domain environment

1634962

How to import or export a LifeCycle Manager BIAR file in BI 4.0 using command line utility

1651890

How to export a Job to a LifeCycle Manager BIAR file in BI 4.0

1651874

How to import a LifeCycle Manager BIAR file in BI 4.0

1777956

BI 4.0: Promotion Overrides not working for Dashboards

8.

Assigned tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Daya Jha
      Daya Jha

      Nice Document....

      Author's profile photo Former Member
      Former Member

      Thank you Chinmay for sharing this 🙂 Top stuff !

      Author's profile photo Former Member
      Former Member

      Informatory!!!

      Author's profile photo Sandeep Chandran
      Sandeep Chandran

      Thank you for sharing this information.. 🙂

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Hello Chinmaya Poopal,

      Perfect document to understand the basic concepts of  "Promotion Mngt Overrides". Very nicely written articles. Thanks for the examples used.. I learnt the key views. It has been summarized very nicely

      -Regard Ashok

      Author's profile photo Former Member
      Former Member

      Nice doc.....keep it up

      Author's profile photo Former Member
      Former Member

      Very useful information and well presented too ℹ

      Keep it up!

      -Regards Nag

      Author's profile photo Andreas J A Schneider
      Andreas J A Schneider

      A couple of things to mention:

      1. It seems one needs Admin rights to manage OverrideSettings, or not?
        See SAP note 176560 / 2014
      2. It would be really nice if one would not have to constantly log On/O(ff between source and target system(s). Instead log into source system as well as into 1 or many target systems and then re-map your connections in ONE go, in a matrix on ONE screen! See also David's great post about this here: Demystifying LCM Overrides | David Lai's Business Intelligence Blog
      3. Finally, the Scan for Overrides does not take into Account the CUID, instead it concatenates the properties of a connection to build a surrogate primary key. I just wonder why that path was chosen, this leads to loads of confusion, when a connection is later changed in DEV for example and then picked up as a NEW connection when scanning for overrides with its own entry...
      Author's profile photo ABHISHEK SINGH
      ABHISHEK SINGH

      Nice Document

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks All for the feedback.

      Regards

      Chinmaya

      Author's profile photo Former Member
      Former Member

      good one chinmay

      Author's profile photo Alejandro Balderas
      Alejandro Balderas

      What about Bex connetions? we have in our DEV environment dozens of BICS connections and "Relational" Bex connections, is there any way to modify easily the connection parameters?

      Author's profile photo Xavier Hacking
      Xavier Hacking

      Yes we also have a lot of Webi reports with OLAP Connections to SAP BW Queries and we have the same question. Is it possible to have the source for the Webi's automatically changed after promoting the Webi report so the production BEx queries are used through the production OLAP Connection to SAP BW? Just like it works in SAP BW transports?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Alejandro and Xavier,

      Yes it is possible to modify the credentials for your OLAP connections to Bex. If you scan your source system, you should see the OLAP connections and should be able to promote it as override.

      Regards

      Chinmaya

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi All,

      The Overrides were previously saved in a Apache Derby Database. They have been moved to CMS database starting BI 4.1 SP 03. Refer SAP BusinessObjects BI4.1 SP3 What's New

      This is a very positive move towards a more stable Promotion Management.

      Regards

      Chinmaya

      Author's profile photo Alejandro Balderas
      Alejandro Balderas

      Thanks by info, it was useful.

      Author's profile photo Balaji Vivekanandan
      Balaji Vivekanandan

      hi Chinmaya,

      Thank for your doc,

      Under my BW connection, there are two Database Type are showing(CCIS.DataConnection and Common Connection), i need to select both while transporting the webi report? what is this two types referring?

      Author's profile photo jayant kapse
      jayant kapse

      Thanks Chinmaya for the detailed info.