SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

published 414 days, 2 hours, 32 minutes ago posted by

sa 423 days, 3 hours, 17 minutes ago

SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

Dimension design is an important aspect to build the Business Intelligence around the data within the data platform. Just on bascis, on OLAP world the database dimension is treated as colleciton of related objects (referred as attributes) that can provide required information about factual data in cubes. By default these objects are bound to one or more columns in one or more tables in a data source view. The attributes can be arranged as hierarchies that will help to navigate the user path when...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: attributes, benchmarking, Best Practices, cpu, Cube, DBA, diagnose, Dimension, Memory, Performance, SQL Server, wizard

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up