I have the following problem. I have a delivery which is linked to a shiftdate. This delivery is done at a site which has certain delivery hours. Now I want to show in a straight table which was the deliverywindow for that site on that shiftdate. Right now my set analysis looks as follows:
DeliveryWeekDay and DeliveryStartTime are specified in the deliveryhours table
WeekDayNum is the weekdaynumber of the master calendar
The problem with his equation is that it will evaluate WeekDayNum as a variable instead of using the ShiftDate Dimension to evaluate it. Is there a way so that it will take the DeliveryWeekDay of the ShiftDate specified as a dimension? Thanks!
The set analysis still evauluates all the DeliveryWeekDay instead of 1 since it somehow doesn't uses the ShiftDate from the dimension but all available shiftdates. If I select a single shiftdate it works correct.
If it's detached, then it's unlikely to work. You may use the P() function to get all possible values, but that will return all values as well. Without knowing your model, I've run out of suggestions except for: