Skip to Content

What is Promotion Management Wizard?

Promotion Management Wizard is a tool that aims to ease the task of CMS content copy. Instead of using the Command Line Interface (CLI), Promotion Management Wizard offers a Graphic User Interface (GUI) for performing a full copy or a selective copy. LCMBIAR files are the same compared to the CMC or CLI versions of Promotion Management.

For more details about the new features of SAP BI 4.2 SP5, please read this blog post from Christian:

https://blogs.sap.com/2017/10/23/sap-bi-4.2-sp5-whats-new-in-web-intelligence-and-semantic-layer/

DISCLAIMER

The content of this blog post is provided “AS IS”. This information could contain technical inaccuracies, typographical errors and out-of-date information. This document may be updated or changed without notice at any time. Use of the information is therefore at your own risk. In no event shall SAP be liable for special, indirect, incidental or consequential damages resulting from or related to the use of this document.

Overview

Promotion Management Wizard is step based user interface:

  • Welcome step
  • Scenario step
  • Objects step
  • Dependencies (only for selective content promotion)
  • Summary step
  • Finish step

Promotion Management Wizard will not create a job that could be reused within the Central CMS. This will save some space too.

Full copy/promotion scenario

Full copy can be achieved by exporting the full content and later importing the LCMBIAR generated.

Full copy can be achieved by running a live to live scenario. In that case, the tool will do – behind the scene – an export and once finished an import. Once this task is achieved, the temporary file will be deleted.

What are the things to consider when performing a full copy?

  • Space allowed to the Temporary folder is critical. If the space allocated is not enough the process will fail. The tool provides within the summary step an estimate of the space needed. The safe formula is FRS size x 2.5 (i.e.: 50GB x 2.5 = 125 GB). Temporary location can be defined at the beginning of the process.
  • Stop unnecessary processes
  • On the destination machine (CMS), disable monitoring, auditing and search to maximize throughput
  • Allocated enough memory (including swap) for the whole process. The more objects you import, the more memory is required although optimizations have been implemented. Here some estimate guidelines:
    • At least, 2GB of memory to run the Promotion Management Wizard itself
    • 1 GB of memory for importing 10K objects. Examples:
      • Example 1 – For importing 60K objects, 8GB sounds reasonable (2+6)
      • Example 2 – For importing 140K objects, 16GB sounds reasonable (2+14)
  • Make sure that Platform add-ons (Explorer, Lumira…) are installed prior to import/promote the content, otherwise objects will likely to fail.

How long it will take?

The time needed for performing a full copy depends on:

  • Load on the source and/or the target system
  • Network bandwidth and latency
  • Memory (RAM) allocated
  • Disk…

The time needed for importing an existing LCMBIAR is more or less 150% the time needed for exporting this LCMBIAR. Why?

  • Writing on a disk and the corresponding Database takes more time than reading
  • Post-processing could happen to ensure that relationships between objects are kept
  • Some errors could happen when attempting to append objects that could slow down the process. Promotion Management Wizard will switch to a “safe mode” for ensuring objects can be added. This safe mode takes more time than the “regular mode”.

For example, if the time needed for exporting is 1 hour. Importing will take between 1.5 and 2 hours. The whole process (live to live) should be a little bit less than splitting in two (export then import).

Memory tuning

As mentioned earlier, it is really important to know how to modify the memory parameters.

  • Step 1: Go to C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64
  • Step 2: Open PromotionManagementWizard.ini
  • Step 3: locate the Xmx memory parameter and change based on your needs like -Xmx16g

Because Promotion Management Wizard is an eclipse-java based application, some additional memory parameters can be added too. Lot of resources are available using your favorite search engine.

Copy tuning – keep the date

By default, Promotion Management Wizard will update the modification date. A dedicated parameter can be set to avoid this behavior. This will only work for objects that do not require a post-processing.

  • Step 1: Go to C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64
  • Step 2: Open PromotionManagementWizard.ini
  • Step 3: Uncomment #-Dcom.businessobjects.lcm.commit=LEGACY
  • Step 4: Modify the parameter: -Dcom.businessobjects.lcm.commit=KEEP_TS

This parameter is also available for selective promotion.

Video available here.

Selective copy/promotion scenario

Selective copy is designed to support two main use cases:

  • Full copy cannot be done in one process
  • Some objects were not copied (objects created after running the full promotion)

The phased approach for a full copy

Q: How to split the full copy scenario into smaller scenarios?

A: By following the same rules explained in the Promotion Management online help!

  1. Export/Import/Promote user groups and users
  2. Export/Import/Promote the dependencies (connections, universes…) required for documents
  3. Export/Import/Promote the public folders (documents…)
  4. Export/Import/Promote the content generated by the users (inboxes, personal folders…)

Prior to make a selection:

Go to options of the Objects Step
Select “Exclude Dependencies”
Check “Object Security”. If needed check “Top Level Security”  

Video available here.

The selective copy/promote… for other cases

You can simply export/promote some objects, folders. You need to pay attention to the dependencies and the time/CPU needed to calculate them. Select few objects at the beginning and test by performing an export.

The tool gives you the ability to check/uncheck the dependencies calculation.

When the dependencies are displayed you can also exclude some of them or all of them.

Reminder: The tool is designed for mass copy. No rollback doable!

Source and Destination

Once installed, Promotion Management Wizard can access to previous versions of the Business Intelligence platform (4.x). So typically, you can export the CMS content of SAP BI 4.2 SP3 and import to SAP BI 4.2 SP4 CMS using Promotion Management Wizard running on SAP BI 4.2 SP5.

However, the tool won’t stop you when attempting – for example – to copy the content of SP4 to SP3, you should avoid that. Objects serialization can evolve between service pack and backward compatibility of objects is often not guaranteed nor supported.

The tool won’t be able to copy the content from XI 3.x. Instead, use Upgrade Management Tool for this task.

Linux

Yes. Promotion Management Wizard works on Linux, with a Graphic User Interface (GUI)! If you are familiar to Linux, you should be able to setup X11 (X Window). A regular remote desktop could do the work too.

Typically, for launching X11 with Promotion Management Wizard

ssh -Y root@mylinuxbox

Then

./PromotionManagementWizard

Promotion Management Wizard requires GTK2+ to work properly. Here the command line for installing it:

yum install gtk2 libXtst xorg-x11-fonts-Type1

sometimes sudo could be necessary:

sudo yum install gtk2 libXtst xorg-x11-fonts-Type1

 

After, Promotion Management Wizard will properly work:

Final words

We hope that this tool will help you. You can watch the two videos:

To report this post you need to login first.

16 Comments

You must be Logged on to comment or reply to a post.

  1. Joe Peters

    Alex, does this provide a way to selectively not override content in the destination?  That was one feature in Import Wizard that is sorely missing in LCM, PM, BIAREngine, and PM Command Line.

    Also, is the Dependency Viewer hierarchical?  It isn’t in UMT, and has been the source of significant frustration.

    (1) 
    1. Former Member Post author

      Hello,

      This option is not available in the UI. However, we added an option to rename objects when an object is in the destination but do not have the same CUID.

      I’m not sure if I’ll answer properly, but the Dependencies step display the list of objects in a tree. The discovered object as root element, the objects which triggered as “children”.

      Hope it helps

      Alex

      (0) 
  2. Mike Quinn

     

    Hi

    following your workflow and have migrated users/groups to BI 4.2 SP5 from BI 4.1

    However, a simple folder with some Webi reports, there’s no way I can get the security on the folders to go across.  No matter what options I try.  The summary screen looks fine and it looks like its going to move the CALs, groups etc … it just doesn’t.

    Any ideas?

    Cheers

    Mike

     

     

    (0) 
  3. Former Member

    Hi

    Is it possible to do selective content promotion in LCMBIAR to live system scenario?

    The button Selective content promotion is not active. And it does not matter if a LCMBIAR file was exported in full or selective mode.

    Thanks.

    (0) 
  4. Austin Guentner

    FYI – I installed an SP5 update to an SP4 system, but the PMW did not install.  I didn’t do that intentionally, could it have been caused by a ‘custom’ SP4 installation?

     

    I could later go back into control panel and modify the installation to install it, but that did mean a SIA downtime to do this.

    (0) 
  5. OLIVIER ARMANI

     

    Hello,

     

    Thank you for this article.

     

    Just one question: what is intended to the status “ignored”? I mean, under which circumstances the PMW will treat an object as “ignored” rather than “imported” or “failed” ?

     

    I’am trying to perform a Full content promotion Live to Live from a BI4.2 SP4 to a BI4.2 SP4.

     

    Thank you for your advice.

    (0) 
  6. Austin Guentner

    We are seeing this tool run very slowly and importing 8000 (objects plus instances) can take over an hour.  Per the formulas here, we have memory settings high enough.  There doesn’t appear to be any bottleneck on the server from a system resource perspective.

    There does appear to be a lot of writing to disk to a derby database, but that doesn’t seem to be saturating throughput in any way.

    Are there any tips you have for further troubleshooting slow performance with this tool?

    We’ve already applied all the best practices from: https://launchpad.support.sap.com/#/notes/2531264

     

    (0) 
  7. abdul peera

    I assume PMW imports content from 4.x environment only.  Could it also work with importing 3.1 content?  Also, is this a replacement for UMT?

    (0) 

Leave a Reply