Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

141

142

143

144

145

146

147

148

149

150

Chapter 10 Creating Rules, Formulas, and User Functions

Syntax Error

When you receiv

e a syntax error, the current rule does not follow the basic guidelines for a rule. This is often

the result of a

typographical error. Possible violations of the rule guidelines include:

• An arithmetic operator does not have a value on both sides.

For example, the expression A+B+ generates a syntax error because the second plus operator does not have

a value on both sides.

• Two values exist without an operator between the values.

For e xample, the expression Profit 0.50 generates a syntax error because there is no operator between

the data cube reference and the number.

• The rule contains a symbol that the analytic calculation engine does not recognize.

For example, a dollar sign ($) generates a syntax error.

• Either a function does not contain the correct number of arguments, or it contains an argument of the

wrong type.

If the syntax error occurs within a function, you may need to check the entry for that function in the built-in

function reference.

See C

hapter 11, “Using Built-in Functions in Analytic Models,” Built-in Fun ction Reference, page 139.

• The rule contains too many closing parentheses.

For example, the expression A*(B+C))generates a syntax error because there is an extra closing

parenthesis.

Note. If there are too few closing parenthese s, you receive the error Unbalanced parentheses.

Defining and Editing Data Cube Formulas

To define or ed

itadatacubeformula:

1. Select the data cube whose formula you want to define or edit.

2. Click inside the rule bar.

3. Enter a new rule or edit the existing rule.

See C

hapter 10, “Creating Rules, Formulas , and User Functions,” Working with the Elem ents of

Rules, page 120.

4. Perform one of these actions:

• Click the Accept Changes button to accept the changes.

• Click the Exit Formula Mode button to keep the changes without validating the formula.

• Click the Cancel Changes button to cancel the changes.

Defining and Editing User Functions

To define or edit a user function: