Hi @Sean-B-01, Great question. I'll be closely following this thread to get some expert suggestions from the fellow community members. I came across some good blogs and thought of sharing which might be useful for initial understanding. Thank you.

Very helpful. Thank you very much @Mallikarjuna Kuppauru-Oracle!

Very helpful information. Thank you very much for sharing @Sumanth V -Oracle, @RanaAshutosh-Oracle & @Rosie Harvey-Oracle!

Hi @Uyen Pham, Welcome to the Oracle Analytics Community. Please take a look into the following Oracle Doc which might be useful. Hope this help. Thank you.

PFB the screenshot.

If you look at the Prompt I used the following: Values: SELECT "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Display Name" s_1 FROM "Workforce Management - Worker Assignment Real Time" WHERE ("Worker"."User Name" = VALUEOF(NQ_SESSION."USER")) Default: SELECT "Workforce Management - Worker…

Yes, you are correct @Sean-B-01. Thank you.

Hi @Sean-B-01, Is the prompt working for you? You can print the Session Variable in a report to see how it is coming. Thank you.

Hi @Sean-B-01, Yes, you are correct. Ideally it needs to be equated with username most of the cases it is Email Address. Thank You!

Hi @Sean-B-01, What value "Projects - Cross Subject Area Analysis - Real Time"."Project"."Current Project Manager" returns? Is it Display Name or Email Address? Thank you.

Hi @MarkS, It seems ORC don't capture the intermediate states before the actual submission as a result it might not be possible to capture those data for which submission has not done or Transaction has not been created. Please take a look into the following Post which might be useful. Generate candidate list for…

Hi @Sean-B-01, Can you please try the attached Prompt to see if it is near to your requirement? Hope this help. Thank you.

Hi @Yagna, Welcome to the Oracle Analytics Community. Can you please provide some more information like below so that fellow community members are in a better position to offer help. What product set you are using here? How are you executing the report? like via jobs or directly running the report etc. Was it working…

Very helpful. Thanks for sharing @Frank.Steinjan!

Very helpful. Thank you very much @JohnW-Oracle!

Hi @Sean-B-01, Glad it worked for you. Thank you.

Hi @Shelly Feyerherm, Welcome to the Oracle Analytics Community. it seems there is no OTBI SA for Total Compensation Statement yet. Please find below an Idea which is in the state of 'Under Oracle Review'. Please upvote and comment so that Oracle might consider for future release. Configuration Report for Total…

Hi @Bhanu Priya, Welcome to the Oracle Analytics Community. Please take a look into the following Oracle note which might be useful. Also please note it depends on data volume or total size of the file also so sometimes even if we are less than the limit of columns it might throw error due to the size of file exceeding the…

Hi @Frank.Steinjan, Welcome to the Oracle Analytics Community. Can you please take a look into the following Oracle Note in case if it is useful. Hope this help. Thank you.

Hi @User_BFQGY, Welcome to the Oracle Analytics Community. Please note there's no specific way or automated way to convert a BI Publisher Report into an OTBI Report. Please find below a work around: You have to map back all the columns that have been used in BIP Report into OTBI Subject Areas. Once you do this mapping and…