IBM Cognos Proven Practices: Troubleshooting Prompts with SAPBW in IBM Cognos Lifecycle Manager

Nature of Document: Troubleshooting; Product(s): IBM Cognos Lifecycle Manager; Area of Interest: Upgrade/Migration

This document describes how to resolve issues regarding prompts with Lifecycle Manager against a SAPBW reporting data source.

Share:

John Cho, Senior Technical Analyst, IBM

John Cho is a Technical Analyst with AVP (Accelerated Value Program) support team in Business Analytics and has been working with IBM Cognos for 3 and half years. During that time John has worked as a Problem Resolution as well as Defect Escalation Analyst. John specializes in IBM Cognos product with SAP BW and TM1.



Greg McDonald, Product Manager, IBM

Greg McDonald is a Product Manager on the platform team and has been part of Cognos for 12 years. During that time Greg has work in the Customer Support and Product Management areas. Current product management responsibilities include Lifecycle Manager, Upgrade, Application Lifecycle and Content Manager.



Amrita Sasane, Staff Software Engineer, IBM

Amrita Sasane have 6.5 years experience in Quality Assurance (software testing) out of which 3 years of experience with LCM product and currently leading the QC effort and Automation.



Niraj Modi, Software Developer, IBM

Niraj Modi has 7+ years of Product Development experience in Java/J2EE and open source technologies, and has been leading the Development activities in LCM for the last 3 years.



Amit Nagar, Software Developer, IBM

Amit Nagar has 7+ years of IT Industry experience in Java/J2EE domain, working as Developement Technical Lead in the LCM product for approximately 3 years and undertaking various development-related activities.



Mrunal Lohar, Associate Software Engineer, IBM

Mrunal Lohar works as an Associate Software Engineer on development of the server side and the GUI of the IBM Cognos Lifecycle Manager. She has been part of the Cognos Group for the last 2.5 years.



09 August 2011

Also available in Chinese

Introduction

Purpose

When using Lifecycle Manager 10.1, the status on some reports that require prompt values are automatically set to 'New' instead of 'Prompt Values Missing' for Cognos reports using SAP BW as reporting data source. This document will assist you to address this issue.

Applicability

The techniques shown and discussed in this document were validated using:

  • IBM Cognos LifeCycle Manager 10.1, IBM Cognos BI 8.4.29.13, IBM Cognos LifeCycle Manager 10.1 and IBM Cognos BI 10.1.4707.544

Scenario

Immediately after creating an Lifecycle Manager (LCM) 'Validation Project', the status on some reports that require prompt values are automatically set to 'New' instead of 'Prompt Values Missing'. The icon 'Open Parameter Viewer' along with the 'Prompt Values' tab (within the report properties) is not displayed, making it impossible to capture or modify the prompt values. This behavior is the same in both 'Source' (e.g IBM Cognos 8.4) and 'Target' (e.g IBM Cognos 10.1).

After executing 'Validate in Source', the status changes from 'New' to 'Fail' with a description of : Unable to complete action for this report because there were unfulfilled prompts. Please verify the report's prompt values.

This behavior can happen when Cognos environment does not have ‘signon’ created for SAP BW data source connections. Often, this is required for customers who are using SAP BW reporting environment to force end-users entering their SAP credentials whenever executing interactive or batch reports against SAP BW.

What needs to be done is to embedding the data source connection signon for specific user (for example, LifeCycle Manager admin user) to SAP BW data source allows SAP prompt variables to be displayed properly in LifeCycle Manager.

Lifecycle Manager Validate screen showing the status of a report as 'New'
Lifecycle Manager Validate screen showing the status of a report as 'New'

Steps in creating a signon for a SAP BW connection

  1. Log in to IBM Cognos Administration, click on the Configuration tab and then Data Source Connections.
  2. Click down on the SAP DW connection till you are at the screen with the database user signons.
    Data Source Connection screen on the Configuration tab in IBM Cognos Administration
    Data Source Connection screen on the Configuration tab in IBM Cognos Administration
  3. Click ‘New Signon’ button near the top right of the screen and provide the same name as data source connection. Click Next.
    New signon wizard
    New signon wizard
  4. Enter in the SAP credentials. Click Next.
    New Signon wizards ID and password screen
    New Signon wizards ID and password screen
  5. Assign the SAP credential to same user who is administering LifeCycle Manager. Click on the Add link to add the user. Once complete click on Finish.

Now test the report in Cognos Connection. Login as the user that has the SAP credential assigned to it.

Test in Lifecycle Manager

  1. Create a new project.
  2. Click on the Configure button and configure both source and target.
  3. Make sure above user, that was in Section 2.1 step 5, is used to connect with both source and target. Test the connection to make sure they worn and save connection.
  4. Now generate report list, notice that LifeCycle Manager now displays correct status as ‘prompt values missing’.
    Lifecycle Manager Screen showing a report with the status 'Prompt Value Missing'
    Lifecycle Manager Screen showing a report with the status 'Prompt Value Missing'

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Big data and analytics on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Big data and analytics, Information Management
ArticleID=750748
ArticleTitle=IBM Cognos Proven Practices: Troubleshooting Prompts with SAPBW in IBM Cognos Lifecycle Manager
publish-date=08092011