TM1 Forum

Hi,

I have a cube with 3 columns, 2 of 3 are dates and the third one is the number of weekdays. How can I do this on TM1?

I have read some topics here at forum about this, but also using a calendar cube I didnot understand how to put this working.

On this calendar cube I have to put all days of the year and set 1 or 0 to indicate if it is a workday or not?

Please help me.

Thanks a lot,

JR

A good start is your Calendar cube. In its most simple form, you would have a time dimension and a measures dimension. The measures dimension usually has calendar days and business days. Ensure that you can derive Working days MTD and YTD. If you are going to span years, would suggest a single, continuous time dimension. You will then need to build the relevant hierarchies to sum the working days YTD so that you can calculate the difference. A bit more on what you are trying to achieve may get you more detailed answers though.