Categories
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