is true that the business model must be only in the shape of stars - can have the shape of flakes. The advantage of the model in the form of flakes is the automatic construction of hierarchies for dimensions including all levels and keys. The disadvantage is the complexity / complexity of the Business Model that contains multiple tables, columns, and links. How to do it 1 / structures will import data from database to the physical layer. Fill in the missing keys and links. Create a business model in which the physical layer-copy. 2 / When you mark a table that has a direct link with the facts from the table menu, select "Create Dimension ' 3 / result is an automatically generated hierarchy, including all levels of Erik Eckhardt.
Posts
