could anyone provide the full list of session variables and repository variables available in OTBI
See Session Variables: https://docs.oracle.com/middleware/bi12214/biee/BIEMG/GUID-F1204007-2846-425D-8BF1-A05CF153CA7B.htm#hpp_a_session_variable
General BI Repository information: https://docs.oracle.com/middleware/bi12214/biee/BIEMG/GUID-F1204007-2846-425D-8BF1-A05CF153CA7B.htm#BIEMG3104
thanks for your prompt reply. I've read that documentation but, as an Oracle HCM Cloud customer, we don't have access to repository. So we would need a full list of the available variables.
For example we know that we can use CURRENT_YEAR and CURRENT_DAY repository variables, but we don't have a full list.
Thanks for clarifying.
I couldn't find in HCM book, but I have this CX Sales https://docs.oracle.com/en/cloud/saas/sales/21a/facaa/create-and-edit-analytics.html#FACAA3482381 that documents the available variables for Saas.
Hope it helps.
Are these valid for OTBI or only for CX analytics. I believe CX analytics is different than OTBI isn't it?
This should be available for all FA (SCM, HCM, CX...) https://docs.oracle.com/en/cloud/saas/sales/21a/facaa/create-and-edit-analytics.html#FACAA3482381
The first response with OBIEE documentation, some may not be available on cloud.
Just found the documentation that provides the HCM variables which can be found here . Not different than from what provided by Priscilla except the one PERSON_ID_HCM. The only thing to note that the documentation suggests CURRENT_DAY is session variable which it it not. All time variable are repository variable. See attached file an archive of OTBI analysis containing all variables.
I hope this helps.