Program use

This application is a sophisticated tool that will assist you in creating multidimensional cubes, which can be later used by other tools like Microsoft Excel and other tools that have access to multidimensional cubes that are located in Microsoft Analysis Services or in local files.

It's designed for users of any technical level that have need to analyze their companies information, but even that they have access to source database information, they don't have the tools to analyze it in multidimensional format. It allows you to gather this source information and convert it to multidimensional format.

It's use is divided in two:

1. Definition of a database query thet will bring the data used to create the cube.

2. Definition of the cube that will be created and cube creation.

This program works like an assistant for cube creation. You only have to fill the corresponding formas according their appeareance. When you fill the forms, a cube definition file, that when it executes, the cube is created.

You can use  menu options to open and save your cube definition files.

Choose a link below to see more information on each of the assistant sections::

1. Connection to source database.
2. Source database table or file selection.
3. Select fields from database.
4. Identify relations between tables in the query.
5. User's prompt creation.
6. Search criteria creation.
7. Field selection to sort the query.
8. Optional modification of generated SQL.
9. Creation of the cube measures dimension.
10. Dimension and level cube definition.
11. Virtual formulas creation.
12. File or cube output selection.
13. Cube creation.

Once your cube is defined and saved in a file you can create it directly for the command line. See the  command line section for more information.