With the query designer, you can build a dataset by dragging-and-dropping metadata from your cube to the designer. There is no easier way to build a dataset based on a cube than by the drag-and-drop method.
It helps to know the basic data warehouse concepts: schemas, dimensions, facts, and measures.
In a basic cube model, you have facts and dimensions which are attributes that correspond to a particular business process or transaction.
Let's take sales as a business process. The facts in sales are prices and quantities. Facts are usually numeric. On the other hand, dimensions are the context in which the sales transaction happened. In this case, the dimensions are date when the actual sales took place, ...