1695453 - LOV prompt groups are not visible after using Promotion Management to promote Crystal Reports (CR) along with Business View dependencies

• When promoting a Crystal report with dynamic cascading prompts (List of Values) from Business Intelligence (BI) server to another BI server using LifeCycle Manager/Promotion Management, the report that is migrated fails to call the values from the prompt group, and instead shows a blank text box for prompt values.

• SAP BusinessObjects Business Intelligence (BI) platform 4.x
• SAP BusinessObjects Enterprise (BOE) XI  3.1
• Lifecycle Management / Promotion Management

1. Create a promotion job.
2. Add Crystal Reports based on LOV prompts. (These reports have specific security assigned to them.)
3. Include all depencies in promotion job (do not include security).
4. Promote the job.
5. In the destination environment, the prompt values are blank while viewing the report.

• This behavior has been confirmed by our developers as by design.
• Security (Promote object security) was excluded from the job.

• Whenever promoting content such as Crystal Reports with Business View dependencies always promote object security along with the same job. 
• Delete Business View from target system and promote only the BV, no reports. Select all dependents and security.
• LOV content will not be brought over if security and dependencies are not selected. This is the recommended and supported workflow by design.

Note:

• If this report has previously been promoted without object security and no updates have been made to the report then the report will need to be deleted from the destination to apply the update in the destination environment.
• If Business View dependencies are not included with the job then object security is not required.
  
  

To re-promote reports with dependencies and object security:

1. Logon to the Central Management Console (CMC) of the environment where the reports are not showing a List of Values.
     
2. Go to Folders, and locate one of the report previously promoted, and delete it.
   
   IMPORTANT NOTE: Before performing this step, double check to confirm you are indeed in right environment, as you do not want to delete the report from the environment where it works.
       
3. Go to the Recycle Bin, and click "Empty Recycle Bin"
      
4. Under "Manage", select "Promotion Management"
     
5. In Promotion Management, in the toolbar, click on "New Job"
      
6. In the New Job:
   - Give a name to the new job
   - Select the source SAP BusinessObjects BI Server
   - Select the Destination server.
      
7. Then click "Create"
     
8. In "Add Objects from the system...", under folders, select the report that uses dynamic parameter,
   and click on the button: "Add & Close"
     
9. In the next screen, in the toolbar, click on "Manage Dependencies"
     
10. In "Manage Dependencies", select all of the objects.
    ( Data Connection, Data Foundation, Business Elements, Business Views, List of Values, ... )
      
11. Click on the button: "Apply and Close"
      
12. Back to the job, in the toolbar, click "Promote"
       
13. In "Promote", in the left pane, select "Security Settings", and select the option "Promote Security"
      
14. Then promote the report.
      
15. Once you confirmed you can see you List of Values for the report just promoted, then you can re-promote any other reports following the same steps.

CR, Crystal, CR2008, CR 2013, CR 2011, CR 2016, LCM, LifeCycle Manager, PM, Promotion Management, 4.0, DCP, Dynamic Cascading Parameters, BV, blank, empty, prompts, missing, values, ADAPT01616233, LOV, empty LOV, missing, not visible, List of values, BVM, Business View Manager, LCM, BIAR, promote, migrate, report, CR4E, not viewable, unable, view, unable to view, static lov, upgrade , KBA , BI-BIP-LCM , Lifecycle Management Console - Promotion mgmt, Version mgmt , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , How To

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016