Verify Outlines
When you save an Essbase outline, the outline is automatically verified, using a checklist of validity requirements.
The following items are checked as part of outline verification:
-
All member and alias names must be valid. Members and aliases cannot have the same name as other members, aliases, generations, or levels, in non-duplicate member outlines.
-
Only one dimension can be tagged as accounts or time.
-
Only one dimension can be tagged as currency type or country.
-
Shared members must be valid.
-
Level 0 members cannot be tagged as label only or Dynamic Calc (unless the member has a formula).
-
Label-only members cannot be assigned formulas.
-
A descendant of a label only member cannot be tagged as Dynamic Calc.
See Label Only Members.
-
The currency category and currency name must be valid, in a currency outline.
-
Parent members with only one Dynamic Calc child, must themselves be Dynamic Calc.
-
Parent members with only one Dynamic Calc child, which is two-pass, must also be Dynamic Calc and two-pass.
-
The two names of members of Boolean attribute dimensions must be the same as the two Boolean attribute dimension member names defined for the outline.
-
The level 0 member name of a date attribute dimension must match the date format name setting defined for the outline (mm-dd-yyyy or dd-mm-yyyy).
-
The level 0 member name of a numeric attribute dimension must be a numeric value.
-
Attribute dimensions must be located at the end of the outline, following all standard dimensions.
-
Level 0 Dynamic Calc members of standard dimensions must have a formula.
-
Formulas for members must be valid.
Note:
An outline with Boolean, numeric or date type attribute dimensions that have no members (i.e., the attribute dimension is empty) is allowed, but should only be used in an interim outline. The results of queries, calculations, and grid operations on empty attribute dimensions can be unpredictable.
During outline verification, the following conversions to appropriate numeric attribute dimension member names are made in the outline:
-
Minus signs in member names move from the front to the end of the name; for example, –1 becomes 1–.
-
Leading or trailing zeroes in member names are stripped; for example, 1.0 becomes 1, and 00.1 becomes 0.1.
See Attribute Types.