Increases a numeric value by a value.
CellIncrementN increases a numeric value by a value.
TurboIntegrator
CellIncrementN(Value, Cube, e1, e2 [,…en]);
Value = a numeric value by which the existing cell value to be increased.
Value can be any number by itself or a number derived via a formula or a number retrieved from another cube such as assumptions cube etc
Cube = Cube Name to update the data
e1,e2….en = Dimension element names determining the data point within the cube to be retrieved. The sequence of the element arguments should match to the order of the dimension in the cube.
Note:
– Principle element name or Alias can be used as the argument to the function
– If using hierarchies, dimension name should be mentioned along with the element name like HierarchyName:ElementName
From the Product Scorecard cube using the view, Accessories, increment the value by 500. Product Scorecard dimension order:
1. Version
2. Year
3. Quarter
4. Product Type
5. Product Scorecard
6. Product Scorecard Measure
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book