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.