Subscribe to this blog
Sherry Li's BI Corner
Archives: November 2012
MDX #21 – Days in a month
ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods
ParallelPeriod() function is often used when we need to present data side-by-side for two parallel periods, such as in the example below where daily data needs to be presented side-by-side for each day in… Read more
0 comments, 73 reads
Posted in Sherry Li's BI Corner on 22 November 2012
MDX #20 – Last Data Date
Need to check the last time when our ETL processes ran successfully
Data warehouse developers routinely query the last data date (the last date when we have fact data) to check the last time when our ETL processes ran successfully.
It’s not hard to do it in TSQL. It just… Read more
1 comments, 74 reads
Posted in Sherry Li's BI Corner on 22 November 2012
SSIS C Sharp #115 – C# Script to detect delta
A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways can you do INSERT-UPDATE?.
This code snippet tried to determine if the original value of MyFirstColumn is different or not compared to the incoming data in the pipeline.… Read more
1 comments, 89 reads
Posted in Sherry Li's BI Corner on 3 November 2012