Exclude holidays or non-working days in a new Time dimension member

Questions & Answers
1

Hi all,

Is it possible to exclude holidays or non-working days in a new Time dimension member ?

We have implemented a new member something similar to show Friday data if the day before the current day is Sunday (excluding Sunday):

IIF(
    [Time].[Day].CurrentDateMember.PrevMember.get("Week day name") = "Sunday",
    [Time].[Day].CurrentDateMember.PrevMember.PrevMember.PrevMember,
    [Time].[Day].CurrentDateMember.PrevMember
)

We need to check if the previous day is a holiday and display the data from the day before that and also check if the day before the holiday is a Sunday to also apply the previous MDX.

Thank you.

Regards,
Diego.

2

Hi @DiegoG

Could you please share a bit more detail about the use case?
Do I understand correctly that you have Day level members in Rows and for example, for each Day member you would like to show the value of the previous day, however, if the previous day is a non-working day, then show the value from the last working day?

What should this show for Saturday? Should it still show the value of Friday? What if there is a value on Sunday, it will be essentially lost if it is always overwritten by the value of Friday, right?

​Best regards,
​Nauris

3

Hi Nauris,

We’ve solved with this MDX provided by Ilze Krauze (EazyBI support by email):

Aggregate({
  [Time].[Day].DateMember(DateAddWorkdays([Time].[Day].CurrentDateMember.StartDate,-1))
  })

It works properly :slight_smile:

1 Like