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?
viewzeroout
-
- Posts: 19
- Joined: Mon May 16, 2011 12:15 pm
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2010
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: viewzeroout
Sounds reasonable.guntupalli wrote:ViewZeroOut( 'plan_BudgetPlan', 'Budget Input Detailed' ); it sets all data points in the 'Budget Input Detailed' view to zero
Doesn't sound reasonable, unless the Budget Input Detailed view covers all element combinations in the cube. Which, from the view name, seems unlikely.guntupalli wrote:and as well plan_BudgetPlan cube also.
The help is quite clear about this:
(My emphasis.) It does not zero out the whole cube unless that view represents all of the data in the cube.This function sets all data points in a view to zero.
Same answer. It clears a view, not a cube. If you want to clear all entered values, use CubeClearData instead.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?
(Though even that won't work if some of the values are rules-based, and pulled from another cube.)
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Martin Ryan
- Site Admin
- Posts: 1988
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: viewzeroout
It also won't clear out rule calculated values (unless the cells that the calculations rely on have been cleared out).
Martin
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: viewzeroout
Hence me mentioning that in the last paragraph...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
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Martin Ryan
- Site Admin
- Posts: 1988
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: viewzeroout
Ah, was skim reading and skipped the parentheses.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer