Forum Discussion

Haaris_Uddin's avatar
Haaris_Uddin
New Contributor III
3 years ago

Consolidate

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

Cube View
  • NidhiMangtani's avatar
    NidhiMangtani
    3 years ago

    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.

  • NidhiMangtani's avatar
    NidhiMangtani
    Contributor III
    3 years ago

    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.