Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- 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