Add Session Variables

Add custom session variables that you can include in the analyses. After merging this step to the Main branch and publishing it, the custom session variables are available in the custom security configuration user interface only.

The SQL query that you define is executed by user OAX$OAC. If you're using another schema in the query, then you must mention the schema name as prefix. You must ensure to grant user OAX$OAC access to all the database objects used in the query.

1. Sign in to your service.
2. In Oracle Fusion Data Intelligence Console, click Semantic Model Extensions under Application Administration.
3. On the Semantic Model Extensions page, click User Extensions.
   You see the main and existing customization branches.
4. In the User Extensions region, under Customization Branches, click a branch to open the Branch page.
5. On the Branch page, click Add Step.
6. In Add Step, select Add Session Variables.
   You see the wizard sequence to add the session variables and a list of existing session variables.
7. In step 1 of the wizard, check if any of the existing session variables serve your purpose.
   If yes, then you can exit the wizard and use the applicable existing session variables in your analyses. If no, then continue with the next steps to create the session variables that you require.
8. Enter a name for your customization step, for example, Add a Session variable using Invoice Received Date and add a brief description. Click Row-wise Initialization to configure cache settings.
9. Click Next.
10. In step 2 of the wizard, define the SQL query and create the initialization block using these instructions:
    1. Enter a name and description for the initialization block.
    2. Select a preceding initialization block.
    3. Enter the SQL query that would be executed in the autonomous data warehouse and return a value that you can use in the reports. For example, if you want to get the Exchange Rate Type that's defined in Oracle Fusion Data Intelligence into a session variable, then you can use the following SQL script:

       SELECT PARAMETER_VALUE FROM DW_CONTENT_PARAM_CONFIG WHERE
        PARAMETER_CODE='PARAM_GLOBAL_EXCHANGE_RATE_TYPE' 

11. Click Next.
12. In step 3 of the wizard, create the session variables using the output of the initialization block created in step 2 of the wizard.
13. Click Finish.
    You see a message that your step is being applied to the customization branch. After it's applied, you see the new customization step in the customization branch. You can now apply the customization branch to the main branch or edit it to add more steps.