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 |
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333
what is the use of layout calculation?
how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What is a Cube?
How create measures and dimensions?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
In framework Manager, what is a stitch query and is it good or bad?
Explain the different stages in creating a report in cognos report net?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
How many number of cubes can we create on a single model? How can we navigate between those cubes?
what are the joins present in reportnet?which is most widely used?