Add Week Time Dimension to PS2003 olap

[TroyS]

Any suggestions on how to automate adding Weekly periods to the olap cube.?
I already have the MSPOLAPBREAKOUT.dll implemented for something else and
i'm looking for dso code for mspolapbreakout.dll to insert a new level
called Weeks in the time dimension ; I'm not readily finding an example via
the MSDN site.

any suggestions on where to look (books or sites) or an example would be
great!

thx in advance.

 

[Marcel Romahn]

Create a new dimension with reference to the time data. The week information
is included by default but not accessible. You can not add this to the
default dimension - after updating the cube it will be erased. By the way:
this is only possible for the american style of week calculation. For ISO
weeks you have to calculte it by yourself. Hope this will help.

Marcel

 

[Vadim Bogdanov]

Hi,


you may find an example in my signature.
This is a piece of software you can customize using config.xml file.
You may try 1 month trial.

 

[TroyS]

thx. i will give this a try.
I was going down the path of trying to utilize the existing Cube_TimeByDay
since week # was already there.....this will save me wasted effort in trying
to make this work.

 

[ahmed]

You can add a weeks level in the Time dimension.