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: maximum period

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

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

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