Skip to content

zahid's BI blog

a showcase of my experience in technologies like SQL, SSAS, ETLs, Azure, Power BI, DAX etc..

  • Home
  • About..
  • Data Visualization Screenshots

Tag: type-2

Slowly Changing Dimension in SSAS Cube

November 28, 2014

  This is a simple example of SCD (Type-2) in OLAP cube.  We have a Dimension table for Employee and their Departments. This dimension is an SCD. One employee worked in different department over the course of time. EmpID is business key and SID is surrogate key. DimEmpolyee table We have another dimension called DimTime. … More Slowly Changing Dimension in SSAS Cube

Leave a comment Slowly Changing Dimension in SSAS Cube

Blog Stats

  • 194,781 hits

Recent Posts

  • Finding common maximum in Power BI
  • Links in Power BI
  • Non-additive measures with different granularity in Power BI
  • Restore SQL Server database using SAS from Azure Blob Storage
  • Device specific logic in Microstrategy

Top Posts & Pages

  • MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
  • Dynamic Column Mapping in SSIS : Part 1
  • Dynamic Column Mapping in SSIS : Part 2 (using dts variable)
  • Non-additive measures with different granularity in Power BI
  • Slowly Changing Dimension in SSAS Cube

Categories

  • Azure
  • Data Quality Service (DQS)
  • MDS (SQL Server Master Data Service)
  • MDX, SSAS (Analysis Service), Cube
  • Microstrategy, MSTR
  • MS Visual Studio, C#.NET
  • Power BI, DAX
  • Spark, Python
  • SQA, Testing
  • SQL, Database
  • SSIS (SQL Server Integration Service)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 22 other followers

Create a free website or blog at WordPress.com.
Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy