O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a dataset using the query designer

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.

Note

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required