TM1 Forum

Hi all,

I have an attribute in my periods dimension to show the working days in a month.

I load it with DBSA using Excel through NETWORKDAYS (Analysis Toolpak addin)

For December 08 for example (23 working days) I would use: =NETWORKDAYS(DATE(YEAR("Dec-08"),MONTH("Dec-08"),1),EOMONTH("Dec-08",0))

I would like to get this by rules, does any of you have worked with something similar and care sharing his / her thoughts?

Thanks in advance

Mauricio Saucedo
TM1 9.1 SP3
Win2000 box
Excel 2003

I'd have thought that playing around with the techniques in this link would help, however, sadly, the NUMBERTOSTRINGEX which allows you to get at weekdays etc is a TI-only command, so a pure rules approach is probably not on.
(Waits patiently for 'Oh yes it is' from the stalls )
http://forums.olapforums.com/viewtopic.php?f=3&t=480

Mauricio

Unfortunately, you can't get this by rules as far as I know. The attribute approach you are already using is probably the one that I would recommend. Do you need to take account of Bank Holidays, etc, or is it just Monday to Friday?

You could set up a day level dimension, with a consolidation to month level, and then enter a 1 in those days that are working days (possibly populating it from Excel). The 1's would then consolidate to give you the number of working days in each month.

However, I think that what you are already doing is fine. I would have thought that once you have populated it, it doesn't need any maintenance.

Regards

Paul Simon