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

SQL Server Performance Forum – Threads Archive

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…(<a href="http://sqlserver-qa.net/blogs/bi/archive/2011/03/25/sql-server-analysis-services-multi-level-hierarchy-dimension-design-gotchas.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=10054" width="1" height="1">
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |