Using the RSM, DB2 OLAP Server stores data in a relational database using a star-schema data structure. You can access your data using DB2 OLAP Server clients, and you can access the multidimensional data stored in the star schema using standard SQL statements.
The RSM automatically creates and manages the necessary relational tables, views, and indexes within the star schema, and the star schema can be populated with calculated data to improve the performance of queries.
For detailed information about how to access your multidimensional data using SQL statements, see Chapter 10, Creating SQL Applications.