Analytics Software

Hi Experts,

I'm Using Obiee10g.

I have a requirement where i need to create a prompt (based on 2 column values)

Example: Name of Prompt (Search Agency) it has following values

Agency Type1
Agency Type2
Agency Subtype1
Agency Subtype2


Agency Type1, Agency Type2 are Major Types - Which comes from Column: Agency Type
Agency Subtype1, Agency Subtype2 are subtypes - Which comes from Column: Agency Subtype

I took a dummy column from subject area. Converted the Prompt to Sql Results and wrote the following condition.

Select Agency_type from Agency where Agency Type in (Agency Type1, Agency Type2)
union
Select Agency_subtype from Agency Where Agency subtype in (Agency Subtype1, Agency Subtype2)

Now, My Prompt is showing correct values.

And, My Report has following columns: Agency Id, Agency Name, Agency Type, Agency Subtype (Agency Type is prompted or Agency Subtype is prompted)

Now, My Prompt and Report not reflects properly as i need to use multi select for prompts

If, i'm using drop down and storing the values in presentation variable and saying that

Agency Type = pv1 (Presen. variable1) default a
or
Agency Subtype = pv1 (presen. variable1) default a

Then, it works.

But, I need Multi select prompt. And, i cannot use p.v for multi select.

How to acheive the above functionality.

Experts, Please guide me.....