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!

https://community.oracle.com/products/oracleanalytics/discussion/comment/54423#Comment_54423 Very helpful information. Thanks for sharing @MarkPescatrice!

https://community.oracle.com/products/oracleanalytics/discussion/20139/trim-trailing-not-working 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/58581#Comment_58581 Very helpful. Thank you very much @Prasad Deshpande!

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/64182#Comment_64182 Very helpful information. Thanks for sharing @Sumanth V -Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/comment/64477#Comment_64477 Very helpful information. Thanks for sharing @Marcelo G. Proaño!

https://community.oracle.com/products/oracleanalytics/discussion/comment/64387#Comment_64387 Thank you very much @Ivony Ann Paula Salango!

It'll be a very helpful feature to have. Upvoted.