Sunday, January 1, 2012

Cognos 10 Creating Dashboard in Report Studio

Creating Dashboard in Report Studio:
In information technology, a dashboard is a user interface that, somewhat resembling an automobile's dashboard, organizes and presents information in a way that is easy to read.

We will see how to create various Dashboards using a Simple Report Studio Principles.

1- Drag and Drop a Table - 2C x 2R. (C- Column / R-Row)
2- Drag a list in the table Top Left@ 1C-1R
3- Drag a Column-Chart in the table Top Right@ 2C-1R
4- Drag a Bar-Chart in the table Bottom Left@ 1C-2R
5- Drag a Line-Chart in the table Bottom Right@ 2C-2R
6- In the list Drag Year/Country/City/Sales Amount/Sales Quantity
7- Now, this list query can be used to feed in data for the various different charts.
8- Associate List Query-1 to all the charts. Select one chart at a time and in the properties pane, Link Query-1
9- From the data Items Tab, In the measure / axis section drag and drop various query items as shown.  Run the dashboard.
10- Now, lets make it more interactive - add two prompts - year/country at the dashboard page itself.
11- Make these prompts optional / enable auto-submit.
12- You may need to refer - P-2 Creating Prompts video for more information on prompts.
13- Run the dashboard.
14- Format the dashboard as per your creativity - add colors etc to make it look good.


No comments:

Post a Comment