Querying the source data to Get what's needed

Having connecting to your data source, if your source database already contains a query or view that has the data laid out exactly as you need it, simply drag the query into the visual query builder and select all fields to provide the data for the source of the CUBE.

If on the other hand no such query is available the next step is to identify the specific pieces of data that will provide the source for the CUBE. Here you simply create a query as you might do for a report. The comprehensive, yet simple to use Visual Query Builder provides an efficient and interactve way of querying data.