Use multiple prefix variables in a report — Oracle Analytics

Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Use multiple prefix variables in a report

Received Response
95
Views
2
Comments
User_EQ8R5
User_EQ8R5 Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

Summary

Using multiple prefix variables on advanced tab of a report

Content

Is is possible to have more than one prefix variable in the "Prefix" section on the advanced tab of an OTBI report? If so, what syntax needs to be used to separate each prefix variable? 

Answers

  • User720640-Oracle
    User720640-Oracle Rank 5 - Community Champion

    Randall,

    In the Advanced tab, if you check Dimensionality checkbox, you'll see an example of multiple prefix variables used.  You separate the variable with a comma like this:

    SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1;

    Ling

  • User_EQ8R5
    User_EQ8R5 Rank 3 - Community Apprentice

    Thanks! That worked.