Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dynamic Alias Names

Delivered
14
Views
1
Comments
User_FR446
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—— &currentyear + "Revenue" would show 2024 Revenue.

using SQL ———— 'select year( max(currentyear)) from variables' &" Revenue" would show 2024 Revenue

0
0 votes

Delivered · Last Updated

Comments