Programmer’s Reference - PivotTable Service

This programmer’s reference contains detailed descriptions of the data definition language (DDL) statements supported by PivotTable® Service. These statements are used to create local cubes, refresh local cubes, and maintain session-scoped calculated members, user-defined sets, and cache.

This programmer’s reference also describes the following:

• The INSERT INTO statement, which is used after a CREATE CUBE statement to populate a local cube
• Transaction management
• Schema rowsets: enhancements beyond the provisions of OLE DB for OLAP
• Sample Web programs that enable users to query cubes and view returned datasets with Web browsers