Weekwise and Monthwise data entry in same cube

Can we enable a cube to allow monthwise and weekwise data entry ?

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Accepted Answer

  • Employee, Community Captain
    Fifth Anniversary 50 Answers 500 Comments 250 Likes
    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,
    Helmut

Answers

  • Employee, Community Captain
    Fifth Anniversary 50 Answers 500 Comments 250 Likes

    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-calendar

    Best,
    Helmut

  • Customer
    Name Dropper Level 200: Building A Planning Solution in Board First Comment
    edited March 4

    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.

  • Employee, Community Captain
    Fifth Anniversary 50 Answers 500 Comments 250 Likes

    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,
    Helmut

  • Customer
    Name Dropper Level 200: Building A Planning Solution in Board First Comment

    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:

  • Customer
    Name Dropper Level 200: Building A Planning Solution in Board First Comment

    Thankyou @Helmut Heimann

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In