https://community.oracle.com/products/oracleanalytics/discussion/24809/how-to-create-chart-of-account-value-sets-in-otbi-report Hi @Uyen Pham, Welcome to the Oracle Analytics Community. Please take a look into the following Oracle Doc which might be useful.…

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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/64662#Comment_64662 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!

https://community.oracle.com/products/oracleanalytics/discussion/comment/64657#Comment_64657 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.

https://community.oracle.com/products/oracleanalytics/discussion/comment/64645#Comment_64645 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…

https://community.oracle.com/products/oracleanalytics/discussion/24808/otbi-session-variable Hi @Sean-B-01, Can you please try the attached Prompt to see if it is near to your requirement? https://us.v-cdn.net/6037859/uploads/E04R01PK55QA/pmt-sv.catalog Hope this help. Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/24802/2-reports-in-this-ship-confirm-documents-bip-job-set-are-facing-issues-to-fetch-data 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/64618#Comment_64618 Very helpful. Thanks for sharing @Frank.Steinjan!

https://community.oracle.com/products/oracleanalytics/discussion/comment/55937#Comment_55937 Very helpful. Thank you very much @JohnW-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/comment/64517#Comment_64517 Hi @Sean-B-01, Glad it worked for you. Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/24788/otbi-subject-area-for-total-compensation-statement 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…

https://community.oracle.com/products/oracleanalytics/discussion/24784/what-is-maximum-number-of-columns-text-format-can-accommodate 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…

https://community.oracle.com/products/oracleanalytics/discussion/24783/preview-of-bi-publisher-rtf-template-with-local-subtemplate-not-working-and-giving-error 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://community.oracle.com/products/oracleanalytics/discussion/24781/we-have-an-existing-bip-report-we-need-to-fit-this-in-otbi-analysis 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…

https://community.oracle.com/products/oracleanalytics/discussion/24771/can-count-of-aligned-goals-be-altered-to-only-bring-in-aligned-goals-for-a-specific-goal-plan-name 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…

https://community.oracle.com/products/oracleanalytics/discussion/24772/can-count-of-aligned-goals-be-altered-to-only-bring-in-aligned-goals-for-a-specific-goal-plan-name 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…

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. https://us.v-cdn.net/6037859/uploads/BCGBUT28B2FM/xml-emp-mgr.txt Hope this help. Thank You!