Friday, February 3, 2012

Cognos 10 Framework Manager Advanced Concepts - Working with Parameter Maps.

Cognos 10 Framework Manager Advanced Concepts - Working with Parameter Maps. 
Working with Parameter Maps.
a- Parameter maps are used to create conditional query subjects that allow for substitutions when the report is run.
b- Parameter maps are objects that store key-value pairs.
c- Parameter maps are similar to data source look-up tables.
d- Each parameter map has two columns, one for the key and one for the value that the key represents.

Steps:
1- Open the framework Manager
2- Right click on Parameter Map, create 'Lang_Thanks' and enter Key Value Pairs
You can also import these values from a file or use an existing
Query Items from the Query Subject.

3- Create three Query Item Calculations - English, Dutch and Hindi
English - 'Thank You'
Dutch - 'Dunkiwell'
Hindi - 'Dhanyavad'

4- Depending upon the run-locale session parameter, we would like to select a query Item Either English or Dutch or Hindi.

5- Create a Calculation; as shown
#'[Database Layer].[Customer Dimension].[' +  $Lang_Thanks{$runLocale} +']'# 

6- Based on the run-locale value passed to this calculation, we can dynamically select the required query item.
7- Now lets over-ride the run-locale to another value and test.
8- Test the calculation

So, THATS IT......





 

No comments:

Post a Comment