Connecting to a Data Source
The first stage in building your CUBE-it ZERO cube is locating where the data is coming from, this simple dialog allows you to connect to your data
Selecting the Data
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.
Building a Data Source Query
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
Viewing Sample output from the Query
Not sure if you've included everything in your query? Or not even sure if the everything you have included is the right 'everything'? Click the "Output Sample" tab at the top of the Visual Query Builder screen, and CUBE-it ZERO will show you the first 1,000 records that you have selected using the defined. This avoids wasting time having to go backwards and forwards between screens.
Defining the Cube Structure
This sounds a lot more complicated than it really is. This is a simple case of identifying what fields contain stuff you want to count ("measures"), and which fields contain things that you would want to anylyse these measures by ("dimensions").
Building Dimension Hierarchies
Can some of the information be grouped? You need a hierarchy, this screen provides you with ability to define them.
Defining Measure Aggregation Functions
Having identified what we want to count, we can now decide how we want to count it. Total up the figures? Average them, get the minimum and maximum? You choose with a drop list.