Working days on TM1

Post Reply
Jorge Rachid
Posts: 89
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Working days on TM1

Post by Jorge Rachid » Wed Apr 11, 2018 7:07 pm

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

User avatar
gtonkin
MVP
Posts: 640
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Working days on TM1

Post by gtonkin » Thu Apr 12, 2018 6:17 am

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.

Post Reply