Multiselect

[robin2008]

i write the exprerssion fpr my prompt

case ?Parameter1?
when 'name' the [COMPANY_NAME]
when 'amount' then [TOTAL_REV]
end

it works.....BUt, BUt....after making multi select in properties ...i was trying to select Both Company Name and Revenue at a same time ,.........Then ITs NOT WORKING.......

SO PLz help me hot to SELECT BOTH the VALUSE at a SAME TIME...........

[blom0344]

i write the exprerssion fpr my prompt

case ?Parameter1?
when 'name' the [COMPANY_NAME]
when 'amount' then [TOTAL_REV]
end

it works.....BUt, BUt....after making multi select in properties ...i was trying to select Both Company Name and Revenue at a same time ,.........Then ITs NOT WORKING.......

SO PLz help me hot to SELECT BOTH the VALUSE at a SAME TIME...........

Question is whether the prompt will be able to store multiple datatypes (I assume Total_Rev is numeric and Company_name is a string)
Normally the prompt query should fetch a set of values that relates to one (=1) data-item. Then in the main query you use an IN on the parameter clause to be able to multi-select

[robin2008]

hello Blom

here COMPANY_NAME is VARCHAR
and REVENUE IS no

so give me some help to select both item at same time...please

[blom0344]

The idea of a prompt is , that it will function as an interactive filter. The value(s) chosen are assigned to a parameter that is reused in the main query. Underneath it will be transferred to the where clause of the SQL generated. In the SQL expression you can use 1 datatype for each evaluation.
I cannot understand why you want select both company name and revenue in one prompt. If the datatype is not uniform the generated SQL will never work.

[Suraj]

Robin,
You really need to go through the documentation and do some research on how to write sql queries. Cognos is just a tool and it really needs some dw background to keep up.

We are here to give you hints and tips but from those hints/tips, it is up to you to make it work with your data as none of us here can access your dw.

Also, give more details in your post, attach screenshots as well so that it's easier to see what's going on.