What is Parametermap?

Answers were Sorted based on User's Feedback



What is Parametermap?..

Answer / 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

What is Parametermap?..

Answer / shashi

parameter are key value pairs. parameter maps secure data within environment.
parameter has 2 columns. 1 key 2 value we manually enter keys and values we can import and export parameter maps

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..

0 Answers  


what type of charts we create mostly in realtime? plz help

4 Answers   IBM,


What is Outerjoin?

2 Answers  


How will u execute a stored procedute from a reportstudio

2 Answers   Cap Gemini,


I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  






Explain what is the main advantage of impromptu over cognos reportnet?

0 Answers  


How to select all in value prompt instead of cascade prompt?

3 Answers   IBM,


Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,


What is looping and how to avoid it in framework manager?

0 Answers  


What are cognos connection initial page components?

0 Answers  


how to Explain a complex report at the time of interview ? please post the answer very urgent?

3 Answers   HSBC, IBM, TCS,


What are the themes in a data warehouse?

0 Answers  


Categories