Email this to someoneShare on Google+Share on LinkedInTweet about this on Twitter

The new BI Modeler release implements analytical base table design for Advanced Analytics applications

Advanced Analytics applications often require data models based on analytical base tables: tables that include either measures and dimensional attributes at the same time. This kind of tables contain all the quantitative and categorical features needed by machine learning algorithms to fit predictive and analytical models.

Analytical base tables are fact tables that embed the columns of the related dimensional tables instead of referencing them.

The new BI Modeler release (b115) implements a new Hierarchy Implementation Strategy to generate, starting from a standard Fact Schema, this kind of fact tables with embedded dimensional attributes.

Applying this implementation strategy, called Embedded Dimension, a Hierarchy of a Fact Schema will be implemented adding all the columns derived from its attributes to the corresponding fact table, side by side with the measures of the Fact Schema. The grain of the fact table is always defined by the set of dimensions of every Hierarchy.


By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.