Value Prompt

[johny.cbi]

I've a District value prompt at the report level (source: OLAP)
when I was trying to select multiple districts, it is not allowing for multiple selection
(I was using these options: Multi-Select: Yes, Select UI: List Box

but when I worked with relational DB, it is working fine

is there any difference for Relational and cube data source for selecting multiple values?

[Desperado]

check the query filter for the prompt. if it is mentioned as = it will not work. it should be 'in'

[Suraj]

Also, if you are using prompt values in a calculated data item, it makes it single select.

[rhythmz]

Suraj,

I am facing same issue..So what is my workaround to enable the use of multi-select? I also have a calculated column based on prompt values that only allows me to single select.

I have people group by header by 2 different position (Management & Crew). Depending on the prompt selection, I would like to display total sales by a person under their respective position. This is because sales data is stored in different tables for each position (i.e. table1.tot_man_sale & table2.tot_crew_sale). I just want the values in one column to conditionally display according to prompt selection.

I created a if-then-else but am stuck at defining 'ALL' selection...then successfully displaying each person's monthly total.

Thanks so much!