I am investigating PAW and data input in a cube that contains a continuous time dimension.
This investigation is actually broader in that it will pertain to any data input in a cube where we cross 2 hierarchies of the same dimension.
The case is as follows: the dimension month contains 36 level 0 elements (2018-2019-2020 and each time their 12 children).
There is a hierarchy for the years (2018 is the sum of 2018_01, 2018_02, 2018_03, ..., 2018_12, and so on).
There is a hierarchy for the months (01 for January is the sum of 2018_01, 2018_02, 2018_03, and so on).
If we cross both hierarchies, input can be done in a grid, even though we only have 1 dimension:
This works fine. Every cell in the grid (36 cells) is each time the result of only 1 valid underlying cell, even though 36 cells are underneath it: 1 combination is valid.
But by choosing this approach, C-level rules are out of the question. We get into a conflict between data input and a rules-calculation:
This means that the user is restricted to a view at level 0, 36 periods in the rows, or in the columns, but not 3*12 or 12*3.
Likewise, prohibiting data spreading is not possible anymore. Once we do that (it's a server-wide setting, the user cannot do data input any more !
I haven't looked at security yet.
Input in a cube with continuous time dimension
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Input in a cube with continuous time dimension
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Input in a cube with continuous time dimension
I also find it confusing to see that invalid cells are in fact C-level cells:
The cell in green is a valid cell, open for data entry.
The cells in red are invalid, as the N-level elements they reference, are not equal.
But why would they become consolidated and receive a value of 100 ?
The cell in green is a valid cell, open for data entry.
The cells in red are invalid, as the N-level elements they reference, are not equal.
But why would they become consolidated and receive a value of 100 ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- Elessar
- Community Contributor
- Posts: 331
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Input in a cube with continuous time dimension
Hi Wim,
Did you mean "is the sum of 2018_01, 2019_01, 2020_01, and so on"?
There is a hierarchy for the months (01 for January is the sum of 2018_01, 2018_02, 2018_03, and so on).
Did you mean "is the sum of 2018_01, 2019_01, 2020_01, and so on"?
Interesting bug, I've managed to reproduce it. BUT: if you split the N: and C: rules, it works fineI also find it confusing to see that invalid cells are in fact C-level cells:
Code: Select all
[] = N: STET;
[] = C: 100;
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Input in a cube with continuous time dimension
Yes. To simulate input at 1 month but then through consolidations.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly