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
Working days on TM1
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Working days on TM1
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.