Example OLAP:

        Online analytical processing (OLAP) is an increasingly popular technology that can dramatically improve business analysis. OleDBPro provides two wraps, CODateset and CFRowset<T> to handle OLAP.

        Before you experiment this example, you are recommended to read through the sub-section OLE DB for OLAP of Platform SDK in MSDN, and enable SQL Server OLAP Services, and install its OLAP OLEDB Provider.

         After experimenting this example, you are expected to answer the following questions.

1. How to connect to OLAP data source.

2. How to open an OLAP flattened rowset using CFRowset<T>.
3. How to open an OLAP TDataset object using CODataset.
4. How to open an axis rowset.
5. How to open a range of cells.
6. How to navigate cells using either cell ordinals or an array of tuple ordinals.
7. How to open various schema rowsets of an OLAP TDataset.

Goto the list of examples