Posts Tagged ‘Report Studio’

Parameterized URLs

July 23, 2010

Cognos Connection is a well designed UI for navigating through all your reports, but there will always be a need for calling Cognos reports from outside of Cognos Connection. You will always have a requirement for integrating Cognos 8 into third-party applications or linking a report.

You can directly use the report URL in other applications/URLs; a sample report URL is shown below:

 http://biapps03:80/cognos8/cgi-bin/cognos.cgi?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2ffolder%5b%40name%3d%27Hire%20Live%20Reports%27%5d%2freport%5b%40name%3d%27Booked%20Ex%27%5d&ui.name=Booked%20Ex&run.outputFormat=

You can check the URL of a report from Set Properties>View the search path, ID and URL:

But reports are generally not that simple; and you will need to play with the parameters of the URL.

Most commonly used parameter will be p_<parameter-name> which will enable you to send parameter values to report prompts. Check the URL below:   

http://biapps03:80/cognos8/cgi-bin/cognos.cgi?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2ffolder%5b%40name%3d%27Hire%20Live%20Reports%27%5d%2freport%5b%40name%3d%27Booked%20Ex%27%5d&ui.name=Booked%20Ex&run.outputFormat=&run.prompt=false&p_ProdID=234

As you may have noticed we used the parameter p_ProdID to feed the report parameter ProdID with the value “234”. Please note that we also used the parameter run.prompt with value “false” in order to get rid of the prompt page.    

There is a very detailed document on IBM website about how to use parameterized URLs. “Performing Tasks using Parameterized URLs in Cognos 8”

Advertisements

IBM Cognos 8 Report Studio Cookbook

July 17, 2010

I have recently finished reading a new book : IBM Cognos 8 Report Studio Cookbook”

It is written by a Cognos consultant: Abhishek Sanghani.

(You can also check his blog: http://biandcognos.blogspot.com/ )

You may need & use other studios in Cognos according to your business requirements but in most cases you will be using Report Studio for your BI development; and the book is entirely focused on Report Studio.

Unlike official structured Cognos books or training guides, Report Studio Cookbook is designed to have individual recipes; some of them simple ones for beginners and some of them advanced ones for more experienced report developers.

Each recipe is written with the same formula:

  • Introduction: Real-life business requirement for the recipe and/or the goal of the scenario
  • Get Ready: Initial steps for the solution
  • How to do it: Solution with lots of screenshots which you will enjoy to follow since the actual report writing work is a very visual-interactive process.
  • How it works: Some brief discussion about how the solution –the implementation in the previous step- works.
  • There’s more: And finally some further references or suggestions.

 If you are a beginner, this book is for you; you can start with first two chapters which include basic recipes to explore Report Studio features.

 If you are an experienced developer, the book is again for you; you can just open any recipe and learn new tips & tricks about advance topics like JavaScript, XML Editing or Macros.  

 You can check the book from the publisher’s website:

https://www.packtpub.com/ibm-cognos-8-report-studio-cookbook/book

is missing?

June 17, 2010

Simple arithmetic may not work sometimes when you are after just a simple variation. Please see the attached report screen-shot: 

A simple subtraction will not work for you to calculate the variance between Actual data and Prior year data when one of them missing.

 If we update the simple formula [Actual]-[Prior] with a nested if statement we can check the missing numbers:

 

See the correct results both in rows and also in total:

Prompt Pages in Report Studio

March 28, 2009

 

For simple prompts, you do not need to create a prompt page and then try to drag and drop the ‘Prompt Object’ and use the wizard. Here is a simple trick for the beginners:

 

 ·         First select the columns you want to create a prompt for, then simply click ‘Build Prompt Page’ button. (Figure 1)

Figure 1

  

 (Figure 1)

  ·         Prompt page will be created for you; all you need to do is to play with the ‘Properties’ now in order to get what you exactly want. (Figure 2)

 

Figure 2

(Figure 2)