Очень интересная штука:

OLAP API Supports Calculated (Virtual) Dimension Members

Within the OLAP API model, application developers can define calculated (virtual) dimension members. For example, a calculated dimension member such as 'New England' in a geography dimension could be created as the sum of stored dimension members 'ME + VT + NH + MA + RI + CT'.

Calculated member support in the OLAP API allows application developers using the OLAP API to create calculated (virtual) dimension members within an OLAP API query. This extends the analytic capabilities of applications that use the OLAP API.

Дока


"The CBO without stats is like a morning without coffee." T.Kyte