Oracle Fusion Data Intelligence

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

How to View a variable created in FDI Semantic Model Extension in OAC

Received Response
56
Views
1
Comments
Vaigu_27
Vaigu_27 Rank 4 - Community Specialist

Hello,

I have created a session variable in the FDI Semantic Model Extension, wanted to test the variable in OAC, couldn't see the variable created in Subject Area.

can someone advise on How to access the variable created in FDI Semantic Model Extension, test in OAC Reports.

Additionally please share any documents which explains existing session variables, Preceding Block concept in FDI.

Answers

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead

    @Vaigu_27 To test the session variable ,you can access any subject area in oac dv and create custom calculation and use this code VALUEOF(NQ_SESSION.ANALYTICS_CURRENCY_CODE). Analytics_currency_code is system provided variable. Please replace it with your variable name.

    To check further on existing session variables and init blocks ,under user extensions ,create a local branch and add step ADD SESSION VARIABLES.Please refer below screenshot