stevefromOZ (6/18/2008)
Sorry upfront as this isn't a direct answer to the question posted. I would seriously consider changing the model yourself, creating new hierarchies within the one Period dimension.
Correct. I was thinking about it, but it would mean SSAS development, possibly ETL development and heaps of Alphablox (JAVA) development to cater for it.
We have more similar problems with other dimensions, Period is just an example.
So, does anyone know?
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM