Interested to Buy Any Domain ? << Click Here >> for more details...
i have 4 countries in my database as USA, UK, INDIA, CHANA.
In value prompt's prompt control list, i want
WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country
names.
When i click on WESTERN_COUNTRIES, it should retrieve USA,
UK records and when i click on ASIAN_COUNTRIES, it should
retrieve INDIA, CHINA records.
How is it possible?
- 4 Answers
- 9826 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / gajendra kumar
Just add static choices to value parameter as WESTERN_COUNTRIES, ASIAN_COUNTRIES. In report query add the filter (?parameter? = 'WESTERN_COUNTRIES' and [Dataitem] in ('USA', 'UK'))
or
(?parameter? = 'ASIAN_COUNTRIES' and [Dataitem] in ('INDIA', 'CHINA'))
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which studio is used to create reports?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What are products of cognos?
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 ?
What is the information present in the cognos configuration file?
what are the special features in cognos reportnet?
1. Explain your project.
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is set to be Cognos configuration?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
what is requery in cognos?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
hi friends pls forward impropmtu interview question
Can you explain cognos planning?
what is power prompt in cognos ep7series?what is the use of this?
