Answer Posted / aram dodakian
Parameter maps are used 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.
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
($).
Constraint
Parameter maps are recommended for smaller lookup tables.
Steps to Manually Create a Parameter Map
Click the Parameter Maps folder and, from the Actions menu,
click Create, Parameter Map.
In the Name box, type a name for the new parameter map.
Click Manually enter the parameter keys, and/or import them
from a file and click Next.
Do one of the following:
To manually enter values, click New Key, type a key, and
press Tab to enter a value for that key.
To import keys and values, click Import File and identify
the location of the appropriate .csv file. You can import
from a .txt file only if the values are separated by tabs
rather than commas.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Explain the different types of views used in cognos.
What is model?
What is the difference between Open Connection command ang Open Session Command?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What is meant by drill down?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What is the function of model design accelerator?
in u r data u having duplicates how to fetch the latest data in our report?
How security is concerned with Reportnet? Explain its implementing steps.
What are products of cognos?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
what is model and say about process how to create model and how to test model?
How create measures and dimensions?
