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.

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.

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.

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

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,

---

What is Report item

1 Answers   TCS,

---

which difficult you faced in your project?

1 Answers   IBM,

---

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

---

1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?

0 Answers   Wipro,

---

What is called materialized view?

0 Answers  

---

What is the difference between the standard and metrics folder?

0 Answers  

---

Why is auto-regression used in forecasting used on cognos platform?

0 Answers  

---

What is the function of cognos dispatcher?

0 Answers  

---

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---

where do we see the run time of the report ?

2 Answers  

---

write a query to display the departments with no employee?

0 Answers   HCL,

---