user initial prompt OR date range
995746Mar 14 2013 — edited Mar 19 2013Hello everyone,
does any of you BIEE GURUS know how to set up an initial PROMPT,
I mean prompts for users when they run this analysis,
PART1:
in a way that the user can select different values for the same parameter attached by an OR clause?
For example, I want to see all invoices done in 2012 OR 2013.
PART2 :
Shouldn't be hard so far, but here's the tricky part:
how do I select two time ranges?
I know how to select all invoices whose date is between 01jan2012 to 01 feb2012,
but how do I select all invoices whose date is in range 01jan2012 to 01feb2012 OR in range 01Jan2013 to 01FEB2013
PART3:
is there a way to see the values in different columns?
I mean, the data of one range per column
PART4:
THANKS :)
All feedback is appreciated.