network days through rules

[mauriciosaucedo]

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

[David Usherwood]

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

[paulsimon]

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