Skip to main content
H
Haaris_Uddin
Newcomer
June 23, 2022
Solved

Consolidate

  • June 23, 2022
  • 1 reply
  • 0 views

Hi,

Is being able to Right click and choose Consolidate in a cube view an admin only function? We have a report where "Can Consolidate" is set to True but users are not able to consolidate from the cube view...they can from a data mgt job.

Thanks,

Haaris

Best answer by NidhiMangtani

Please check if user belongs to security group "Calculate From Grids Group" on the scenario member. 

Found below from the OneStream Reference Guide:

Can Calculate / Translate / Consolidate
When this is set to True, the user can right click on a cell and calculate, translate or consolidate data in
OnePlace, if it is set to False no calculations can be made. The Default is False.
Note: These properties coincide with the Can Calculate from Grids Scenario security group. If the
property is set to True, but the user is not in the group for that given Scenario Member, he/she cannot
calculate from a Cube Viewgrid.

Hope this helps.

1 reply

N
NidhiMangtaniAnswer
Veteran
June 23, 2022

Please check if user belongs to security group "Calculate From Grids Group" on the scenario member. 

Found below from the OneStream Reference Guide:

Can Calculate / Translate / Consolidate
When this is set to True, the user can right click on a cell and calculate, translate or consolidate data in
OnePlace, if it is set to False no calculations can be made. The Default is False.
Note: These properties coincide with the Can Calculate from Grids Scenario security group. If the
property is set to True, but the user is not in the group for that given Scenario Member, he/she cannot
calculate from a Cube Viewgrid.

Hope this helps.

    H
    Haaris_UddinAuthor
    Newcomer
    June 23, 2022

    Thank you NidhiMangtani! That worked. 

    Terms & ConditionsAccessibility statement