A parameter map is a collection of Keys and Values that may be used to replace values during the execution of the query. Manually or depending on query elements, we may generate parameter mappings. This article will walk you through the process of creating parameter mappings in Cognos framework manager.
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:
Frequently Asked Cognos Interview Questions & Answers
Procedure:
In the project viewer pane
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
Name | Dates | |
---|---|---|
IBM Cognos Training | Dec 24 to Jan 08 | View Details |
IBM Cognos Training | Dec 28 to Jan 12 | View Details |
IBM Cognos Training | Dec 31 to Jan 15 | View Details |
IBM Cognos Training | Jan 04 to Jan 19 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.