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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.