Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7761 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can you define report item?
What is the difference between static and dynamic conditions?
Give me any example of semi and non additive measures?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Can you define slice?
What are the types of security?
faq's on cognos
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
Why is auto-regression used in forecasting used on cognos platform?
----------------------What are the User Securities?
What are the advantages of using cognos sql?
How to join multiple db in catalog?
