1 / 10

Using Parameterized URL’s to Extend Cognos Capabilities

Using Parameterized URL’s to Extend Cognos Capabilities. Stephanie Jesperson Denver Water Department. Why Use Parameterized URL’s?. Leverage your organization’s current investment in Cognos. Minimize purchase and licensing costs Develop & deliver single versions of the truth

ailis
Download Presentation

Using Parameterized URL’s to Extend Cognos Capabilities

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Using Parameterized URL’s to Extend Cognos Capabilities Stephanie Jesperson Denver Water Department

  2. Why Use Parameterized URL’s? • Leverage your organization’s current investment in Cognos. • Minimize purchase and licensing costs • Develop & deliver single versions of the truth • Hiring additional developers for Source Apps may not be needed • Enhance the user experience. Provide a single point of entry to either a specific report, its output or a focused list of applicable reports.

  3. Source Application - eWOR

  4. Embedded URL: • http://UATCOG02/cognos8/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/launch.xts&ui.tool=CognosViewer&ui.action=run&ui.object=/content/package[@name='eVoucher Data']/report[@name='eWOR - Work Order Request Snapshot']&ui.action=run&p_WONum=W98107&p_Pid=1234&run.prompt=false

  5. Components of the URL: • Base URL: • http://UATCOG02/cognos8/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/launch.xts • Name of the Cognos Tool to be Opened: • &ui.tool=CognosViewer&ui.action=run& • Search path to the Object (See Report Properties): • ui.object=/content/package[@name='eVoucher Data']/report[@name='eWOR - Work Order Request Snapshot'] • Action to take with this Object: • &ui.action=run • Define Parameters and Prompt Answers: • &p_WONum=W98107&p_Pid=1234 • Define if the Prompt Page Should Appear: • &run.prompt=false

  6. Additional Parameters • Launch Report in a New Window • launch.openJSStudioInFrame • Remove any combination of Cognos Default Headers, Menus and Toolbars • &ui=h1h2h3h4 • Define what page should be displayed when the user closes the report or if the back button is used. • ui.backURL=http://<server-name>/cognos8/

  7. Removing Headers & Toolbars Original URL URL Includes H1,H2, H3 & H4 parameters

  8. Resources • IBM Support Links: • Tech Doc: http://download.boulder.ibm.com/ibmdl/pub/software/dw/dm/cognos/reporting/scripting_techniques/using_urls_in_cognos_8.pdf • Multimedia Video: http://www-01.ibm.com/support/docview.wss?uid=swg21341180

  9. Linking to an External Application Standard Drill Through URL

  10. Linking to an External Application

More Related