Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

List of Available Server Variables in the RPD

Submitted
91
Views
4
Comments
Kamran Butt-161785
Kamran Butt-161785 Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

City of Hollywood FL

Description

Could we please have a list of server variables available for use in the RPD? For example, I know that CURRENT_YEAR is an available variable but CURRENT_PERIOD is not. These variables help when building Analyses, Dashabords, and Dashboard Prompts. 

Any help and documentation would be appreciated.

Use Case and Business Need

Our business user would like to see the current period as the default value in a dashboard prompt. Since this variable is not available, we would need a work around. It would be beneficial to know which variables we have available for report building.

More details

Comprehensive list of all OTBI server variables does not exist.

Original Idea Number: 2fe5952aae

Tagged:
1
Up
1 votes

Submitted · Last Updated

Comments

  • Justin Scherrer
    Justin Scherrer Rank 3 - Community Apprentice

    Hi Kamran, 

    MOS Doc ID 1900513.1 has a link to download a PDF with BI session and repository variables. Is this what you were looking for?

    Also, as an FYI, Doc ID 1624768.1 has links to several other BI resources. 

  • Kamran Butt-161785
    Kamran Butt-161785 Rank 3 - Community Apprentice

    Yes, something like this is excellent. Is there one specifically made for the ERP Fusion modules? 

  • Kamran Butt-161785
    Kamran Butt-161785 Rank 3 - Community Apprentice

    Yes, something like this is excellent. Is there one specifically made for the ERP Fusion modules? 

  • Justin Scherrer
    Justin Scherrer Rank 3 - Community Apprentice

    I'm not sure which application you are needing info on, but for Sales you can also find the variables in Help Center documentation. 

    https://docs.oracle.com/en/cloud/saas/index.html

    Help Center > Sales > Analyze and Report > Create Analytics > Create and Edit Analytics > Engagement Repository and Session Variables for Business Intelligence. 

    Maybe the specific applications you are working on have specific variables called out in their respective analytics documentation in Help Center?