Create and Validate Member Formulas in Cube Designer
In the Cube Designer Formula Editor, you can write formulas for specific outline members in block storage cubes. You can construct member formulas from operators, functions, dimension names, member names, substitution variables, and numeric constants, and you can validate them to check for correct syntax.
- The Cube Designer Formula Editor applies only to block storage cubes.
- Validation works against existing cubes in the cloud service. It does not detect application workbook changes that have not been applied to the cube.
- Member selection works with existing cubes only.
Formula Editor provides a formula editing pane in which you can enter a formula. You can use the Tab and arrow keys to move focus within Formula Editor. You can also use a point-and-click approach to select and insert formula components into the formula editing pane. A member selection tree helps you place the correct member names into the formula.
See these topics in Designing and Maintaining Essbase Cubes: