hello,
I try to evaluate the revenue of a project based on its age, during few years ahead.
I’ll try to make it clear with an example :
I have a Project dimension, with an attribute "first year"
I need to evaluate the revenue 5 years ahead (with a formula using the calculation "project_age") meaning that I need to be able the create the "project_age" that way:
Project X “first year” = 2010
project X age, current year =2020-2010=10
project X age, next year =2021-2010=11
project X age, 2 years ahead =2022-2010=12
...
project X age, 5 years ahead =2025-2010=15
In this case not only I need to transform the text “first year” as transactional data (using ATTRIBUTE in data action), but I also need the use the date dimension as transactional data.
I also must work on the year level – and I don’t know how to do it (it always requires a leaf level)
Moreover, I need a dynamic “current_year” / “next_year” etc, that will update the project’s age every year automatically, and that will act as transactional data.
How would you suggest doing it?