Using rule to navigate a dimension
Posted: Sun Oct 06, 2019 9:24 pm
Hello,
I have a rule like this:
[‘2020’,’number of customers at start of period’]=[‘2019-12’,’number of customers at end of period’];
And so on and so forth for all years
Where the time dimension is like this:
2019-01
2019-02
2019-03
.
.
.
2019-12
2019 (consolidated element)
2020-01
2020-02
.
.
.
2020-12
2020(consolidated)
Is there a generic function I can use so that I don’t need to hard code 2020 and 2019-12? I know I could add an attribute to consolidated years with that month and use attrs to pull it, is there a better way of doing this such that all C level cells in time dimension would be equal to the last child of the previous C level element?
Thanks
I have a rule like this:
[‘2020’,’number of customers at start of period’]=[‘2019-12’,’number of customers at end of period’];
And so on and so forth for all years
Where the time dimension is like this:
2019-01
2019-02
2019-03
.
.
.
2019-12
2019 (consolidated element)
2020-01
2020-02
.
.
.
2020-12
2020(consolidated)
Is there a generic function I can use so that I don’t need to hard code 2020 and 2019-12? I know I could add an attribute to consolidated years with that month and use attrs to pull it, is there a better way of doing this such that all C level cells in time dimension would be equal to the last child of the previous C level element?
Thanks