Relative Content

Tag Archive for data-warehouse

Problem Configuring Multiple Date Relationships in SSAS Multidimensional

I’m currently working on a multidimensional cube in SQL Server Analysis Services (SSAS) with SQL Server Data Tools (SSDT). My data model includes a fact table called FACT_TICKET containing several date columns (DATE_CREATE_KEY, DATE_NEW_KEY, DATE_PLANNED_KEY, DATE_INCOURSE_KEY, DATE_RESOLVED_KEY) and a single date dimension (DIM_DATE). I configured each date column in the fact table as a separate dimension, which is not ideal and makes analysis more complex. My goal is to correctly configure the relationships between each date column of FACT_TICKET and DIM_DATE

Indexes on a SQL Server fact table

If I have a SQL Server fact table with four dimensions (OrderDate, Customer, Product, Region), my understanding is that it’s best to create a non-clustered index per foreign key (dim key column in the fact table).