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
- 8824 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / itesh
simple man ,
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)
in report query put filter
write a if statement
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)
cheers
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / 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 |
Answer / beckham
Use a customized data item in a query.this query is the
source query for the region prompt.Make sure the customized
data item is used in main query and filterd accordingly.
| Is This Answer Correct ? | 4 Yes | 5 No |
Define cognos report net?
what is fact less fact give me proper example?
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
what are the tabs in cognos ?
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
what is a Galaxy Schema?
Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
How can create users and permissions in cognos?
What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?
Teradata 
