Forum Discussion

Sergey's avatar
Sergey
Contributor III
4 years ago

Behaviour between Top Level cube and Cube References

Dear community,

 

I have a very simple use case with my base entity set in "finance entities" top level cube, and the group entity set in the "finance group" cube.

 

Everything in the "finance entities" cube works fine and as expected. However, no data roll out to the top level cube, even though I have tries to consolidate, force consolidate ... 

The 'Cube Refence' has been set so that the dimension for local entities is coming from the "finance entities" cube.

 

When using a cube view on the Top level cube for base-level entity and group-level entity, I can only see that the cells related to group-level entity are all in red.

 

--> What am I missing so that data from base level entity can roll-out to parent entity in the top level cube ?

 

Top Level cube references :

Top level cube entity dimension :

Reference cube entity dimension :

Local Entity dimension:

Group entity dimension :

Many thanks,

Planning
  • tsandi's avatar
    tsandi
    Contributor
    4 years ago

    Can you share the screenshot of the cube view? You should put the top level cube in pov and the entire entity hierarchy in rows. It should be entirely green if the setup is correct. Also what is the default currency of your entities? Are they set to Is Consolidated = Ture? If they are in different currencies do you  have exchange rates loaded? Are your accounts set to Is Consolidated = True or Conditional (if they don't have a formula)?

  • tsandi's avatar
    tsandi
    Contributor
    4 years ago

    If the cell in invalid it means the cubes are not properly setup. You might have some of the dimensions not assigned properly or something else. Reach out internally, no point discussing basic cube setup here

  • Sergey's avatar
    Sergey
    Contributor III
    4 years ago

    Hi,

    So the issue was actually related to my UD3 dimension, which wasn't making a link between the group dimension, and the entity dimension. Adding a parent to my entity dimension and ensuring that this parent was reflected in the group dimension solved this issue.

    We were able to see this issue by using the drill down functionality on the parent cell where we were supposed to see data. Drilling down on UD3 resulted in 0 rows although we knew that there was base level input.

     

    Thank TSANDI for your help 🙂

     

    Regards,

  • Sergey's avatar
    Sergey
    Contributor III
    4 years ago

    Hi Tommy,

     

    Please find below the cube view :

    The setup that you were refering to is correct (Is consolidated = True for both entity & account), the default currency for base entity is PLN, while EUR for parent entity, and I ensured that rates are indeed loaded - but you can see that it converts since first parent entity is converted (it is in the base level cube).

     

    Regards,

  • tsandi's avatar
    tsandi
    Contributor
    4 years ago

    Is the cube view on the base level cube or the top one? You need to use the top level cube and consolidate from there

  • Sergey's avatar
    Sergey
    Contributor III
    4 years ago

    Hi,

     

    It is indeed the top level cube in this cube view. The Total goes green if I select base element from the dimensions of this top cube, but consolidation is doing nothing 😞

     

    Regards,

  • tsandi's avatar
    tsandi
    Contributor
    4 years ago

    Why is none in there? Are you on Top of the consolidation dimension as well? When you say "The Total goes green if I select base element from the dimensions of this top cube" which dimensions to you refer to? 

  • Sergey's avatar
    Sergey
    Contributor III
    4 years ago

    Ciao,

    I was in C#Local, but same with C#Top :

     

     

    Regards,