TM1 Forum

hi ,

ViewZeroOut( 'plan_BudgetPlan', 'Budget Input Detailed' ); it sets all data points in the 'Budget Input Detailed' view to zero and as well plan_BudgetPlan cube also. if it is correct , default view of 'plan_BudgetPlan' Cube and 'Budget Input Detailed' view to zero .
but some of views under 'plan_BudgetPlan' cube are having data.
and the second question is : same ViewZeroOut function is used for the view of another cube. prossesed succusfully, but the view of the cube is having the data.

can any one clarify with possible reasons?

guntupalli wrote:ViewZeroOut( 'plan_BudgetPlan', 'Budget Input Detailed' ); it sets all data points in the 'Budget Input Detailed' view to zero

Sounds reasonable.

guntupalli wrote:and as well plan_BudgetPlan cube also.

Doesn't sound reasonable, unless the Budget Input Detailed view covers all element combinations in the cube. Which, from the view name, seems unlikely.

The help is quite clear about this:

This function sets all data points in a view to zero.

(My emphasis.) It does not zero out the whole cube unless that view represents all of the data in the cube.

guntupalli wrote:if it is correct , default view of 'plan_BudgetPlan' Cube and 'Budget Input Detailed' view to zero .
but some of views under 'plan_BudgetPlan' cube are having data.
and the second question is : same ViewZeroOut function is used for the view of another cube. prossesed succusfully, but the view of the cube is having the data.

can any one clarify with possible reasons?

Same answer. It clears a view, not a cube. If you want to clear all entered values, use CubeClearData instead.

(Though even that won't work if some of the values are rules-based, and pulled from another cube.)

It also won't clear out rule calculated values (unless the cells that the calculations rely on have been cleared out).

Martin

Martin Ryan wrote:It also won't clear out rule calculated values (unless the cells that the calculations rely on have been cleared out).

Martin

Hence me mentioning that in the last paragraph...

Ah, was skim reading and skipped the parentheses.