Use multiple prefix variables in a report

User_EQ8R5

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? 

User720640-Oracle

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

Thanks! That worked.