Get weeks Time dimension in Cudes?

[Marchel Komen]

Im trying to get a cube report running that has a Week demension in it. But not as is used in the standard Time demension because that one splits weeks in months (ie. twice week 14, one in march and one in april).

Using MS Project Server 2007 with MSSQL 2005.

Hope to get some help

Thanks
Marchel

EggHeadCafe - Software Developer Portal of Choice
Anthem.Net AutoSuggestTextBox Redux
http://www.eggheadcafe.com/tutorial...52-1cb775f37e83/anthemnet-autosuggesttex.aspx

 

[Marc Soester [MVP]]

Hi Marchel,

the only way to achieve this is to develop another time dimention. This is
not too difficult, check out the Project Server SDK. You will also need some
OLAP Cube dev skills.
Hope this helps