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?
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 |
Name the types of gateway?
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
drillthrough vs master detaild report,which one is the best by performance?
please tell me architecture of the cognos8?
1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question
what are the joins present in reportnet?which is most widely used?
How to create Events?
Hi,please suggest me how to creat username while creating a report.
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
what is the security module used in cognos?
How do we create Links & Segments in Cognos Framework Manager?