Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 231 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Dynamic Alias Names
User_FR446
Rank 1 - Community Starter
Ability to code the name of an alias of an attribute or metric using global variables or embedded sql.
Use case- Ability to dynamically change the name of metrics that are typically CY (Current Year) Revenue, or PY (Prior Year) Revenue to 2024 Revenue, 2023 Revenue.
Use Case 2- We could also use similar functionality to make chart labels dynamic- instead of saying "Current Month Performance" it would say "June-2024 Performance".
ex.
Using variable—— ¤tyear + "Revenue" would show 2024 Revenue.
using SQL ———— 'select year( max(currentyear)) from variables' &" Revenue" would show 2024 Revenue
0
Comments
-
Hi @User_FR446, have you checked out the Parameter functionality?
I think this addresses what you're looking for.0
