sorry that was for Gianni. I completely agree with your point. The fix which I am providing to the business, is for some time so that they have access to their critical reports in the way they want. We have already raised the request to our ETL and RPD team for the permanent solutions which will take some time just because…

Thank you Gianni. Yes I am working to find an alternate, even I do not want to use Evaluate .

Thanks Thomas. Yes I am working to find an alternate, even I do not want to use Evaluate .

your arrogance in comments clearly shows your level of understanding others. "Knowledge without humility is vanity" Get well soon

Thanks Martin. Below formula worked for me CONCAT(CONCAT(CONCAT('Week', CAST("TABLE Date"."DIM Week " AS CHAR(2))), ' w/e '), LEFT(CAST(TIMESTAMPADD(SQL_TSI_DAY, 6, EVALUATE('TRUNC(%1, %2)' AS DATE, "DIM Date"." Col Date", 'IW')) AS CHAR(10)), 6))

I agree with you completely and well aware about the right things and performance issues which we can have after applying the formula at answers level. But there are some limitations and privilege issues which restrict me to answers level. Anyways I found the solutions. Thanks 

Thank you very much Thomas. But we can apply below formula when something is needed in urgency . I know it'll hit the performance but there are cases when you need to listen to business and get things done quickly CONCAT(CONCAT(CONCAT('Week', CAST("TABLE Date"."DIM Week " AS CHAR(2))), ' w/e '),…

Dear Christian You should know the actual situation before judging anyone. I am part of a team in which we do not have access to repository or ETL, what we can do is make changes on answers and that is the reason I have mentioned those conditions. As it's a team which follow lots of processes to get things done i.e,…

Something which is already available in OBIEE 12c package .. I guess Oracle map viewer .. that should be oracle spatial I would like to know which is the best fit as I need to migrate reports from Tableau to OBIEE and Tableau has wonderful maps

I missed that tab..Thanks Gianni