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.