Validate Partitions

When you create an Essbase partition, validate it to ensure its accuracy before you use it.

Database Manager permissions or higher are required. After you validate, save the partition definition. If necessary, you can edit an existing partition.

When Essbase validates a partition definition, it checks the Essbase Server for the source and the target to ensure that:

  • The area definition is valid (contains no syntax errors).

  • The specified source data members are valid and map to valid members in the target.

  • All connection information is correct; that is, the Essbase Server information, database names, application names, user names, and password information.

  • For replicated and transparent partitions, a replication target does not overlap with a replication target; a replication target does not overlap with a transparent target; and a transparent target does not overlap with a transparent target.

  • For replicated and transparent partitions, the cell count for the partition is the same on the source and the target.

  • For replicated and transparent partitions, the area dimensionality matches the source and the target.

  • You must validate a transparent partition that is based on attribute values to ensure that the results are complete. Essbase does not display an error message when results are incomplete.