Hi Vij
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.
Also Please refer to
http://public.dhe.ibm.com/software/dw/dm/cognos/modeling/design/modeling_with_prompts_and_parameter_maps.pdfThe link give a good example of using parameter maps
Also while defining security at User level you can use them as a lookup table
Hope this helps
Regards,
Arpit Agrawal
