Have question for you, I’m trying to build a cube from existing one that works perfectly fine, but now I need to use FY instead of calendar, which starts always April 1st. So, I put together a new Time dimension base on date_sk field which is ‘YYYYMMDD’ format. Built my cube, but now all my years shifted one year ahead: beginning of time is January 1st 2006 and my hierarchy looks like this: 2006 has Jan, Feb and Mar. 2007 starts as expected from April 2006, but come on, why 2007… it should be 2006 for my business scenario. How can I make 2006 starts at April 2006 and so on… I already try to change Preferences for “Enable lunar fiscar labeling”, but it didn’t help at all.
Can someone let me know if I missed something here?