12. File or cube output selection.

In this section, you will select the cube that will be created, Press the Choose button, to select an output cube.

 

This advanced options let you:

 

Ceate several cubes depending on the value of a database field. For example, if you wish to give a cube to each country manager with information pertaining his country, then you can choose a database field which brings the countries and create a cube for each country. To use this option use the following options:

  • Do you wish to have a field, in which a cube is created for one of its values?: Choose this options if you wish to create seveal mini cubes.
  • Field: This is the database field whose values are used as cube names. If some of the values contain characters that cannot be used as file names, they will be converted to the '_' character.
  • CHoose: Press this button to choose the database field.
  • I wish to use a different directory for each cube created: Choose ths option if you want a diectory to be created for each cube. If the field values are North, South, East and West and the cube is chosen to be crated at c:\cubes\file.cub, then the following files are created:
    • c:\cubes\North\file.cub
    • c:\cubes\South\file.cub
    • c:\cubes\East\file.cub
    • c:\cubes\West\file.cub
  • I wish to create cubes with different names in the same directory: Each cube will be created with a different file name, on for each database value. In the sample above, the following would be created:
    • c:\cubes\North.cub
    • c:\cubes\South.cub
    • c:\cubes\East.cub
    • c:\cubes\West.cub

Other advanced options are:

  • No data is added to the cube, creating a ROLAP cube: Use this option if you don't wish data to be aggregated to cube and will be read ditectly from the original database. This option is turned off by default.
  • Tries not to populate the cube with data (depends): If it's possible, it doesn't add data to the cube, but if it is neccesary, then data is added. This options is turned off by default.
  • Tries to interpret the SELECT instruction: If this option is turned off, the SELECT instruction generated by MDX is not checked. This could create errors when generating the cube. If you create database formulas and receive a passthrough error, you have to create a database view and use this view to create the cube without this option.
  • Doesn't interpret the SELECT instruction: As it names sayes, it passes uninterpreted the SELECT instruction to the create cube command.

If you want to create a ROLAP cube where the cube data is read directly from your source database and is not kept in the .cub file create a view or query in your source database so you only have to choose one table in order to create the cube and leave No data is added to the cube, creating a ROLAP cube option checked and the rest of the options unchecked, in this way the cube will be automatically update with new cube information. Leave the options as default if you want to create a MOLAP cube or a .cub file with data, this way the queries are fasted but you need to recreate the cube once in a while.

If you have chosen the cube output, press the Next button to proceed to section 13. Cube creation.

The Back button will take you to section 11. Virtual formulas creation.