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: OLAP cube

Common Latest Period in SSAS Cube

January 27, 2015

Recently I came across a situation where data was being delivered at different times for different countries and client wanted to see data for latest common month in Region/Continent level reports. Data arrive on monthly basis, but it arrives at different dates for different countries. So, at one point in our data warehouse, we have Dec-2014  … More Common Latest Period in SSAS Cube

Leave a comment Common Latest Period in SSAS Cube

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,998 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
  • Non-additive measures with different granularity in Power BI
  • Update another table using Data Macro in MS Access 2010
  • Cursor Using Foreach Ado Enumerator in SSIS
  • Dynamic Column Mapping in SSIS : Part 1

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

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