OLAP Services

 

The OLAP Services tab in the formula editor applies to linked cubes to Analysis Services. The use of the OLAP Services MDX function can significantly improve the performance when accessing Analysis Services data through PowerOLAP using formulas. When creating a linked cube to Analysis services PowerOLAP® automatically writes a basic formula which uses MDX to pre-query values from Analysis Services and returns them to PowerOLAP in large data sets rather than point-by-point. Additional OLAP Services MDX statements can be written to optimize individual PowerOLAP® calculations based on multiple Analysis Services data points.