Creating an InfoCube

To create an InfoCube, open the cube transaction, click on the actions icon and select New Cube

• then type the name of the InfoCube and select the data type,

• Click the Structure button and select the InfoCube’s dimensions. The structure selection window shows all stand-alone entities and entities at the base of hierarchies.
• Define one (or more) InfoCube physical versions. Usually the most detailed version of the InfoCube is defined in the first column. The most detailed version of the InfoCube is also called the primary version. To add entities to a version click the version-entity intersection cell. For example to define a version by Month-Customer-Product, click as illustrated.

• Define the sparse structure as appropriate. Refer to the Sparse Structure paragraph for guidelines. To define a sparse structure, click twice  on the cells of the entities you want include in the sparse structure. The second click converts the v into an S, while a third click clears the cell.
•  For MXC InfoCubes, you must declare the entity being counted by clicking on the entity name; the symbol <> appears next to the entity’s name. If the entity you want to count is not explicitly declared, Board counts the entity with the greatest MaxItemNumber.

Automatic cube versioning

Starting from 7.4 Board Client release it’s possible to let board set up automatically cube versions by selecting one of the four following options:

• None: default option that does not create any other version
• Few: creates the least number of versions
• Normal: creates the correct number of versions
• Many: creates all the possible versions

There are two conditions that must be matched in order to use this feature:

• The new engine must be used
• The cube must contain a single version, otherwise the drop down will be disabled

Important note:

InfoCubes of type MXC, date and text can only have one version.

It is possible to define an InfoCube which is only structured by a time entity (single dimension InfoCube), for example Month or Year, however all time functions (Previous Period, Yearly Cumulated Value etc.), including the Data Reader’s Replace function are ignored on these InfoCubes. For this reason, it is recommended that InfoCubes with the time dimension have at least another dimension.

When an InfoCube is structured by a given time entity, using the same time entity for any additional version defined is recommended. For example, consider an InfoCube which is structured by Day (and some other entities). If multiple versions need to be created, then they must all be structured by Day (not Month or Year); all versions use a single entity as time dimension.

Tip:

Hidden InfoCubes: is is possible to define an InfoCube as "hidden" by clicking the Hidden checkbox in the InfoCube definition window. Users can’t view hidden cubes when configuring a report, a chart or other data presentation objects, the Cube remains accessible visible in the procedures environment, this is typical of cubes that are created for the purpose of supporting an intermediate calculation in a process model.