Post reply

Yesteday Data in cube

  • December 30, 2015 at 1:51 pm

    #307414

    I have a requirement in my project that is

    I need the data for yesterday.

    I have DimDate dimension table and have Hierarchy In cube as

    Year

    Month

    Quarter

    Day

    But my client needs additional dimension like Yesterday.

    If they drag yesterday dimension on rows and all measures on columns.

    They want to see the data for only yesterday.

    Is there any possible way to achieve this.

    Thanks

  • December 30, 2015 at 2:26 pm

    #1848844

    Yes, it is possible. Have look at the following to get started:

    http://prologika.com/CS/blogs/blog/archive/2009/08/19/yet-another-relative-dates-implementation.aspx

    http://blog.crossjoin.co.uk/2006/04/19/handling-relative-time-periods/

  • December 30, 2015 at 3:00 pm

    #1848855

    Thanks Martin Schoombee,

    I am new to SSAS , it seems complicate to me , I am not able to understand how to implement it.

    Is there any way that you can help me in this.

    Srinivas

  • December 31, 2015 at 8:08 am

    #1848941

    srinivas.sqlbidev (12/30/2015)

    Thanks Martin Schoombee,

    I am new to SSAS , it seems complicate to me , I am not able to understand how to implement it.

    Is there any way that you can help me in this.

    Srinivas

    It may be a little complex, but provides an excellent opportunity to learn. There are many people on this forum that can help, but you have to make an attempt yourself too.

    Read through the articles and post your thoughts about the approach you want to take, and give it a shot. Post any questions as you make progress or struggle and we will help.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply