YTD Based on Current System Date (Now() Function), based on same date pulling value for Last Year too.

  In this example we are trying to pull ytd based on current date using Now Function.   with member [Date].[Calendar].[currentyear] as aggregate(ytd((strtomember("[Date].[Calendar].[Date].&["+format(now(),"yyyyMMdd")+"]")))) member [Date].[Calendar].[prevyear] as aggregate(ytd(parallelperiod([Date].[Calendar].[Calendar Year] ,1,(strtomember("[Date].[Calendar].[Date].&["+format(now(),"yyyyMMdd")+"]"))))) Get Complete Example on http://blogs.msdn.com/b/karang/archive/2010/10/25/ytd-based-on-current-system-date-now-function-based-on-same-date-pulling-value-for-last-year-too.aspx

0

Dealing with Slowly Changing Dimension using SSIS

Surrogate Keys Also known as meaningless keys, substitute keys, non-natural keys, or artificial keys. A surrogate key is a unique value, usually an integer, assigned to each row in the dimension. This surrogate key becomes the primary key of the dimension table and is used to join the dimension to the associated foreign key field…

0

During ETL detecting dirty records from Fact

  Attribute Key Not found Error occurs in SSAS due to the following reasons : Dimensions processed after measure groups (This one is simple, just process Dimension before processing a Cube) Presence of Orphan Records in Fact Table  (This one is tuff to handle from SSAS Perspective) These errors can be dealt easily at ETL…

0