Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between a cascading report and drill through report?
how you provide security to reports? How you provide security to packages ?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What are shortcuts? Where it can be used? What are the advantages?
What is the model filter?
what is degenerate key in oracle ?whare do we use it?
how you create security to reports?
-----------Diff b/w OLAP and RDBMS?
What is the difference between group and associare?
What is difference between data mart and data warehouse?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
Can you explain new content durability?
what are slowly changing dimensions? Why we are used scd?
Define the slice and dice?
What are the services provided in cognos 8?
