Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Use multiple prefix variables in a report
User_EQ8R5
Rank 3 - Community Apprentice
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?
0
Answers
-
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
1 -
Thanks! That worked.
0