Validating the Essbase Outline
Validate the Oracle Essbase outline to ensure that your application is compatible with the Hybrid Essbase version. See these information sources:
- Financial Consolidation and Close: Validating the Essbase Outline in Administering Financial Consolidation and Close
- FreeForm: Validating the Essbase Outline in Administering FreeForm
- Planning: Validating the Essbase Outline in Administering Planning
- Tax Reporting: Validating the Essbase Outline in Administering Tax Reporting
Addressing Validation Errors
Validating the outline may reveal errors like those listed below. Address these issues using the provided recommendations and re-run the validation process until all errors are resolved.
| Error Category | Recommendations |
|---|---|
| ELSE or ENDIF without IF | The member formula utilizes if, elseif, else, and endif constructs, but there are more endif tokens than if tokens, or the else and if tokens are mismatched. The number of if tokens should correspond with the number of endif or else tokens, ensuring proper grouping. Correct the formula by addressing the syntax issues. |
| Invalid Data Type or expected type NUMBER found STRING | The member formula refers to a non-existing member. Review the formula and remove the non-existing member from it. |
| Invalid Expression Return Type | The member formula refers to a non-existing member. Review the formula and remove the non-existing member from it. |
| No Matching Quote Found | The formula contains mismatched quotation marks. Ensure that the number of opening and closing quotation marks are equal and properly grouped. Correct the formula by resolving syntax errors. |
| Nothing to do | The member formula for the member is commented out using /* and */. Since the member is dynamic, it must have a valid formula. Put a valid member formula for the member or change the member property. |
| Parenthesis Error | The formula has mismatched parentheses. Ensure that the number of opening and closing parentheses are balanced and correctly grouped. Correct the formula by resolving syntax errors. |
| Substitution Variable doesn't exist | The member formula references a non-existent Substitution Variable. Create the Substitution Variable with an appropriate value to ensure successful formula validation. |
| Syntax Error in MDX Query | To fix your syntax error, see MDX Syntax and Grammar Rules. |
| Missing Semicolon
or Unexpected End of Expression |
The member formula does not end with a semicolon.
The formula may return a value, however the absence of a terminating semicolon is a syntax error. Review and correct the formula. |
| Unknown Member Name used in function | The member formula references a non-existent member. Review and update the formula to remove any references to members that do not exist. |
| Environment Variable doesn't exist | The formula refers to an environment variable. You can't create an environment variable in the Oracle Enterprise Performance Management Cloud applications. Create a substitution variable instead with the same name and value of the environment variable, and use that in the formula instead. |
| Formula Parsing Error | The member formula references a member name that is not quoted,
or the formula does not end with a semicolon. Additionally, the
member name imay nclude keywords or function names such as
for, year, and sum which
are not permitted in the formula.
Ensure that the member name is properly quoted and that the formula ends with a semicolon. Also, verify that a member with that name exists in the system. |
| Unknown Member Used in Query | For an ASO cube, the member formula refers to a non-existent member in the MDX query. Additionally, ensure that the names of dimensions, members, and attribute dimensions do not contain the / (backslash) character. |
| Duplicate Member Name | The member formula refers to a non-existing member. Review the formula and remove the non-existing members from it. |
| Invalid Assignment | Invalid assignment: The value on the left side of the equal sign
must be a member or variable.
In the member formula, the left side of the assignment operation using equal to sign (=) should be the name of an existing member. Ensure that the left-hand side of the assignment is a valid member name. |
| Operator Error | The member formula contains improperly nested if, elseif, or endif constructs, resulting in incorrect and unbalanced nesting. Review and correct the formula to address these syntax issues. |
| Function Error | The member formula uses functions, but extra parameters have been passed. If the function involves Planning's substitution variables, ensure these variables are available and have values, which should not start with ampersand character (&). Additionally, review the formula to remove any extra & symbols before substitution variables. Ensure that each substitution variable in the formula has a single & before its name for proper resolution. |
| Missing Expression | Review and fix the formula to remove the expressions related syntax errors. |
Sample Validation Errors
In these samples, [MEMBER_NAME] indicates the name of the member that failed the validation.
Formula verification error samples: member name, unknown member, missing semi-colon, end of expression, etc.:
- Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 3): unknown member name ["[MEMBER_NAME]"] in function [operator @X]
- Formula verification failed for member [MEMBER_NAME]. Error parsing member name in formula
- Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 1): semicolon missing
- Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 19): unexpected end of expression: [...IF(...)]
- Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 1): unexpected end of expression: [@ADD]
Formula verification errors sample: substitution variables sample:
Formula verification failed for member [MEMBER_NAME]. Substitution variable [[MEMBER_NAME]] doesn't exist
Formula verification error sample: parenthesis:Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 1): [)] without [(]
Formula verification error sample: invalid data type, return type, and assignment:
- Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 1): expected type [NUMBER] found [STRING] ([MEMBER_NAME]) in function [@SUB]
- Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 12): invalid expression return type
- Formula verification failed for member [MEMBER_NAME]. Error compiling formula for [] (line 4): invalid assignment
Note:
Additional validation errors might occur after you migrate to a newer version of Essbase.