Scenario to Understand Dataset Functionality

Consider the scenario, where you want to analyze the Customer Relationship Management through various profiles of a customer against the various transactions and the channels of transaction through which the actual transactions have happened.

This information is maintained in relational tables. In a typical Star Schema implementation of the relations, Customer profiles like Age, Gender, Sex, Residence, and Region are maintained in Individual Dimension tables. Similarly, the Transaction Types and Channels would be maintained in a separate Dimension tables. The actual transaction performed by the Customers will be stored in a Fact table.

A Dataset allows you to collate all the tables with a valid join condition. The tables defined in the Dataset would form the FROM clause while aggregating for the Cube.