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. https://support.oracle.com/knowledge/Oracle%20E-Business%20Suite/2142450_1.html 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…

Hi @User_PBMY6, Welcome to the Oracle Analytics Community. Quick Check: It seems this question has been raised twice. Can you please suggest if it is same as the below mentioned link? Can Count of Aligned Goals be altered to only bring in aligned goals for a specific Goal Plan Name? — Oracle Analytics Once you confirm,…

Hi @User_PBMY6, Welcome to the Oracle Analytics Community. Can you please add the following column to your report to see if it brings any values so that it can be filtered accordingly. "- Goal Alignment Details"."Actual Completion Date" Hope this help. Thank You!

Hi @Dave Whitson, Please find below the xml which will give Employee & Manager and their Employee Numbers using the 'Workforce Management - Worker Assignment Real Time' SA. Hope this help. Thank You!

Very helpful information. Thanks for sharing @MarkPescatrice!

Hi @Tonya H, Welcome to the Oracle Analytics Community. Please find below the definition of TrimTrailing function and a working example, it might help to understand the working methodology. TrimTrailing‎ function Strips specified trailing characters from a character string. Example: Used the following to Trim Trailing 6.…

Very helpful. Thank you very much @Prasad Deshpande!

Great Idea and it is much needed for good user experience. Upvoted.