Everyone working with Business Intelligence must have heard of Mr Kimball. While reading newsletters from various BI sites I came across a interesting article from Kimball University. The article discuss how to handle an employee dimension so that hierarchies can be easily traversed when doing reporting and ad-hoc queries, while keeping query performance and enabling type 2 slowly chanching dimensions.

Since employee dimensions can be rather large it’s also important that the amount of rows is kept to a minium.

Take a look at the article to get some inspiration on how to design the warehouse to efficiently handle complex hierarchies.

http://www.intelligententerprise.com/channels/information_management/showArticle.jhtml;jsessionid=ZUPYEMPNT1G1DQE1GHPCKHWATMY32JVN?articleID=219400252&pgno=1

KONTAKTA OSS

Vänligen skicka ett mail så återkommer vi så fort vi kan. Du kan även nå den person du vill ha tag på via förnamn.efternamn@attollo.se

Skickar

©2017 Attollo AB - Kungsgatan 50 - 111 35 Stockholm

Log in with your credentials

Forgot your details?