nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

OTBI session and repository variables full list

Alberto Boccato

Content

Hi,

could anyone provide the full list of session variables and repository variables available in OTBI

Regards,

Alberto

Find more posts tagged with

Answers

OTBI

Analyses

Comments

Priscila Terazawa - Support-Oracle

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

Regards,

Priscila

Alberto Boccato

Hi,

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.

Regards,

Alberto

Priscila Terazawa - Support-Oracle

Hi Alberto,

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.

Priscila

mgoswami

Are these valid for OTBI or only for CX analytics. I believe CX analytics is different than OTBI isn't it?

Priscila Terazawa - Support-Oracle

@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.

Priscila

mgoswami

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.

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…