What is Parametermap?
Answers were Sorted based on User's Feedback
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 |
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 |
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..
what type of charts we create mostly in realtime? plz help
What is Outerjoin?
How will u execute a stored procedute from a reportstudio
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 ?
Explain what is the main advantage of impromptu over cognos reportnet?
How to select all in value prompt instead of cascade prompt?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
What is looping and how to avoid it in framework manager?
What are cognos connection initial page components?
how to Explain a complex report at the time of interview ? please post the answer very urgent?
What are the themes in a data warehouse?