suppose there are 15 countries like (US, UK,
ENGLAND,INDIA,JAPAN.......)i want a value prompt in the
report and this value prompt should contain groups like
group1(US,UK,ENG), group2(INDIA,US,UK), group3
(ENG,JAPAN,INDIA)and in the value prompt the values should
be group1,group2,group3 how can we do this?
- 4 Answers
- 8100 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhay puranik
Create a query,drag the Country column,Drag data item from
the tool,name this as Group,Now in the expression
corresponding to this data item,write if(geography contains
('','','') then 'Group1' elseif(Country contains('','',''))
then 'Group2'......And use this query for the query
property of value prompt and use Group as column diplayed
under value prompt.Now,in filter for the main page use if
(Group='Group1') then (Country in ('','','')) else
if.....save report and run.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / poorna chandra reddy
Create a data item and in that writ condition like below
if(country in (' US,UK,ENG' , ' INDIA,US,UK'))
then ('Group1')
else if (country in (‘INDIA’,’US’,’UK’)
then ('Group2')
else ('Group3')
Then create value prompt and assign this data item to the
value prompt.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / balanandam
Abhay ur concept is write, but there is other way to implement this ....
using static choice property in the properties pan u can put the values like Group1, Group2....
and modify the default sql as
if query.country in (?parameter?='Group1')then (Country in ('','','')) else
else if.....then...
else if....then...
else query.country='parameter';
i think this will clear more
save report and run.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / dhanu
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)
u can add more static values if u want.
in report query put filter
write a if statement or case
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)
case when ?country? =1
then query.country in (us,uk)
when ?country?=2
then query.country in(INDIA,srilanka)
end
| Is This Answer Correct ? | 0 Yes | 1 No |
What is Local Cache and how does it help in performance tuning
What is difference between drill through and drill down?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer
what is the difference between group and association?
What is model filter and query filter?
how to merge 2 crosstabs thans
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!
what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??
What is the use of Excel files in Cognos8?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Teradata 
