Hi,
could anyone provide the full list of session variables and repository variables available in OTBI
Regards,
Alberto
Hi Alberto,
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
Priscila
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?
@Munish,
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.
UKOUG Conference Discover 2026 Three days of Apps & Tech sessions. Two days of exhibition & keynotes. One Oracle community. Join Oracle professionals, customers, partners, developers, architects and business leaders for keynotes, customer stories, technical sessions, networking and exhibition access at UKOUG Conference…
Join us this November for Oracle Analytics Cloud (OAC) Office Hours! We’ll explore recently released Data Visualization (DV), AI features and take a closer look at the Deep Insights Agent—all in one webinar, offered at two convenient times. Through demonstrations and practical examples, we’ll highlight the latest…