financial date dimension - additional audit periods


  • I have financial data, which have financial period data. I'd like to implement this period as date dimension, because I would like to use ytd, yoy kpis and others.

    The problem is that I have records with "additional" period - 13th, 14th, 15th (i.e.: 2012013, 2012014). These records are a special operations, which shouldn't be in one bucket with other records (rather I don't want to change it to 2012-12-31).

    How I can accomplished it? Is there any method by which I could have time operations and more than 12 months?

    Monday, October 07, 2013 1:28 PM

All replies

  • You can create Date table with additional columns and set type as "Time" in designer.
    Tuesday, October 08, 2013 9:07 PM
  • so, should i do a date table, in which there will be i.e. a few records with date 2012-12-31, with additional column "date_from_financial" with varchar's "2012-13-01", "2012-14-01"?

    Am i good understand it?

    Wednesday, October 09, 2013 9:55 AM