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?
check the query filter for the prompt. if it is mentioned as = it will not work. it should be 'in'
Also, if you are using prompt values in a calculated data item, it makes it single select.
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!