Framework Manager

[vij]

Hi all,
want an example how to use parameter map in Framework Manager
except an example given in Help Documents.


thanx in advance.......

vij

[Arpitagrawal9]

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.pdf
The 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