Pivoting on Formatted Worksheets
The pivot capability is intended to be used as a method of producing ad hoc reports. Pivot can operate on a formatted worksheet; however, a formatted worksheet can contain labels and formulas that cause ambiguous results. The pivot is designed to compress and retain only the database elements represented in the worksheet.
Notes:
Essbase prevents pivot operations on worksheets that contain formulas when Formula Preservation mode is active.
When you pivot a group of members, Essbase keeps only unique members from dimensions not involved in the pivot. A pivot action eliminates rows or columns in which all cells are empty.