Mindmajix

Creating a parameter map

PARAMETER MAPS:

Use parameters to create conditional query subjects that allow for substitutions when the report is run. Parameter maps are objects that store key-value pairs.

Parameter maps are similar to data source look-up tables. Each parameter map has two columns, one for the key and one for the value that the key represents. You can manually enter the keys and values, import them from a file, or base them on existing query items in the model.

It is a key value pair which allow to substitute a value at query run time.

Do not place quotation marks around a parameter value. You can use quotation marks in the expression in which you use the parameter.

The value of a parameter can be another parameter. However, you must enclose the entire value in number signs (#). The limit when nesting parameters as values is five levels.

When you use a parameter map as an argument to a function, you must use a percentage sign (%) instead of a dollar sign ($).

Assign an alias to a query item that uses a parameter map as part of its name and to add the multilingual names to the object in the Language tab (Properties pane).

Parameter maps can be thought of as simple data lookup tables. Each parameter map has two columns, a key column and a value column holding the value that the key represents.

          KEY                         VALUE

       EN_AUS                         EN

       EN_US                            EN

       EN_UK                           EN

       EN_BE                            BE

Well, to construct your map, you can:

  • enter the keys and values (for your map) manually,
  • import them from an external file, or
  • base them on query items in your Meta model

Procedure:

In the project viewer pane

  • From project
  • Select parameter maps
  • Right click
  • Select create
  • Click on parameter maps
  • Enter the name localemap
  • Click on import file
  • Click on browse to select a file which contains keys & values
  • C:/programfiles/cognos/c10/webcontent/samples/models/gosales_goretailers/lan
  • Click on finish

Screenshot_74

Screenshot_75

Screenshot_76

Screenshot_77

Screenshot_78

Screenshot_79

http://ibm.co/1TxGjIq

 

Enroll for LIVE, Instructor LED ONLINE COGNOS TRAINING


0 Responses on Creating a parameter map"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.