ElastiCube for Advanced Business Scenarios

This section provides examples of more advanced scenarios, and the recommended methods for implementing the required business logic.

The examples are categorized into the following data manipulation methods: Integrating, Reformatting and Enhancing.

Integrating Data

Integrate and merge data from different sources into a single ElastiCube structure by identifying common keys between the different tables. Proper planning is important for merging the data. It’s important to avoid creating unnecessary relationships, but at the same time, make sure you don’t have any many-to-many relationships. Examples include:

Reformatting Data

Reformat field data to free space, and make fields more readable and usable. For example, convert a date field to numeric, or reduce the precision of real numbers. You can reformat fields within the ElastiCube using a custom SQL expression.

Enhancing Data

Enhancing Data by adding attributes/records that did not exist in the original data source.