Passing a concatenated prompt value to filter a report
CArnoldFeb 18 2010 — edited Feb 18 2010Hello, I am relatively new to OBIEE and still learning the very basics.
I have a dashboard multiselect prompt where the users desire to see 2 columns concatenated:
Dept Num ||' - '|| Dept Name
I'm having a hard time figuring out how to filter my report based on that concatenated value. I really only need to filter on Dept Num, however filtering on the concatenated value would be fine also.
In other words, if someone selects *555 - Billing* then I'd be ok just passing *555* to the report. However, if it is easier to force the report to accept the full string, then I'd be ok with that too. I just need to be able to either filter the report on Dept Num ||' - '|| Dept Name or Dept Num based on the concatenated value that the user would select from the prompt.
Any help/advice would be greatly appreciated.