This discussion is archived
0 Replies Latest reply: Jul 15, 2013 11:47 PM by user12116294 RSS

Need Help in Union of Columns in FX

user12116294 Journeyer
Currently Being Moderated

Hello Experts,

 

In database I have a table having two columns, Version From, Version To.

 

Column "Version Start" data is like

V0, V1, V2, V3, V4....upto V11 (fixed value)

 

Column "Version End" data is like

V1, V2, V3..... upto V11 (fixed value V0 is not present)

 

User requirement is like create two prompts on these columns and select the data

between these two fields and see the report. This is achieved by prompt and presentation variable.

 

But the problem is let say user select V1 from Version Start, then Version End prompt should show all values apart from V1.

If user select V2 then it should all value in Version End apart from V2.

 

I tried but it seems 'union' function does not work in rpd bmm, nor in fx in OBIEE 10g.

 

Can you all please help.

 

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points