CellSpace/Manual (draft)
by CellWorks
Home
  
Table of Contents
  
Glossary
General Formulas
General Formulas
are
property
of a
Item
and apply to all the cells in that
Item
.
  • For example in a
    Cube
    the Sales
    Item
    is defined as follows: 
  • 	= units * price
  • This calculation applies to all the
    Cells
    in that
    Item
    .
  • General Formulas
    can be employed in both
    Cubes
    and
    Sheets
    .
  • This powerful feature improves the maintainability of a model by reducing fill operations.
General Formulas
overlap in
Cells
at the intersection of
Items
when they are defined on different
Dimensions
.
  • The formula that is calculated is determined by the
    Priority
    of the formula.
  • The default ordering for the
    Item
    can be changed via the tab
  • The specific ordering for a
    Cell
    can be set via the tab as well as with the inline
    Cell
    editor with a formula selector drop down control. See
    Edit
    Cell
    .
See
Specific Formulas
.