YTD Based on Current System Date

  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”)+”]”))))) select { [Date].[Calendar].[currentyear] ,[Date].[Calendar].[prevyear] }on 0, [Measures].[Internet Sales Amount] on 1 from [Adventure Works] Well, my customer wanted to pass fix start date member and get the result so changed query as per Customer’s requirement. From your application you can pass value but…

3

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