Weekwise and Monthwise data entry in same cube
Accepted Answer
-
Hi @Shailesh ,
whenever you want to use Split&Splat to distribute data from a higher level down to the leaf level of the hierarchy you need a template the system can use to get the according percentiles.
Currently, I'd assume that the cube does not contain any values on the week level, thus, you can't input data on the parent level.
Best,
Helmut0
Answers
-
Hi @Shailesh ,
your cube needs to be dimensioned on the leaf-level of the data which in this case would be "day" since the time range of the database will connect week to month through day.
The relationship between month and week is an indirect one.
Now, to use split&splat to distribute the monthly values down to week, you'll need a template dimensioned by day as well (e.g. PY data on the same dimensions).
That sounds simple but in fact, it is not. For example, Jan 1st will not always be in the same week over the years. And you will not really be able to compare data week-wise.
You will encounter so many difficulties that I wouldn't recommend this approach with standard time dimensions.
Maybe you'd like to consider a 4-4-5 calendar
https://community.board.com/discussion/16845/how-to-set-up-a-4-4-5-calendarBest,
Helmut0 -
Dear @Helmut Heimann,
Thank you for your prompt response.
Background: The requirement for having a single cube that allows both weekly and monthly entries is essential to accommodate both the Budget (Monthly) and the Forecast (Weekly). The use of a single cube for both plans (Budget and Forecast) is necessary to minimize the number of objects for maintenance.
I have configured the standard week entity and its parent, the custom Calendar 4-4-5 entity, and have mapped the relationships accordingly. The data view layout includes the week as a column dimension.
However, I am unable to enter data within the data view. Could you please assist with resolving this issue or provide an alternative.
0 -
Dear @Shailesh ,
what are the dimensions of the cube you want to use for data entry and what do your custom time relationships look like—could you provide screenshots of those, too?
Best,
Helmut0 -
Budget needs to be on month level & Forecast week level.
Below sample cube is used:
Custom time relationship:
While using Week in column: Data entry is enabled,
However, while using Calendar 4-4-5 parent member in column - Data entry not allowed:0 -
Thankyou @Helmut Heimann
1