SQL BI

My Experience - Troubleshooting SQL BI Stack

October, 2010

Blog - About

About Karan's WebLog

Hello, This is Karan Gulati working with Microsoft SQL BI Team. We work with the BI Developers across the globe and deliver results that no one can deliver around the GLOBE!!!!

Posts
  • SQL BI

    YTD Based on Current System Date

    • 3 Comments
    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...
  • SQL BI

    During ETL detecting dirty records from Fact

    • 0 Comments
    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...
Page 1 of 1 (2 items)