This is where you design a query that CUBE-it Zero will use as the source query to build your cube. Ideally your query should:
- Be based on a dataset that is a flattened denormalised version of your data
- Include all of the dimensions and measures you wish to use in your cube
The Data Source Query screen is as follows:
The GUI interface allows you to build your query in a similar way as you would in SQL Server or Access. You can:
Drag and drop tables into the query diagram pane
Drag columns between tables to establish joins between tables
Check the columns you wish to use in your query
Specify aliases, sort orders and where clauses in the criteria pane
Type directly into the SQL pane
To check your query produces the desired results at any time, click the Output Sample tab to see the query results.
When you have successfully written your query click the OK button to return to the main screen.