Hi experts, Please suggest me the possible solution for this one. Regards, Chandra kanth.

HI, Please let me know how to keep other values along with default value which will be set using session variable based on role. EG: for the user: Master Scheduler the default value is: MPS-Current. Along with MPS-Current i should have remaining values. How to achieve this. Similarly for other users also. Regards, Shubham…

Hi, Please let me know the approach how to do this one. regards, Chandra kanth.

Hi Christian, This is client requirement which they asked us to check the possibility to incorporate. Regards, Chandra kanth.

Hi, Please let me know how to write a query to get two values. regards, CK

Hi All, Please answer my query. Regards, Chandra kanth.

Hi, Thank you so much for the response. I understand that we don't write SQL queries in OBIEE. I am trying to build sql query in sql developer. Is it possible to build a query to get the above result, without using UNION. Request you please suggest/guide me. Regards, Chandra kanth.