Dynamic Alias Names

User_FR446

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

Jamie Anderson-Oracle

Hi @User_FR446, have you checked out the Parameter functionality?
I think this addresses what you're looking for.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/what-are-parameters.html#GUID-755B3041-677E-40B0-9EB8-4DCC1EC4C2DE