Sorry in advance if I am not making sense...
I have two different date dimensions in an invoiced orders cube.
They are the following:
- Invoice Date
- Billing Period(months)
I have a requirement where they would also like to see another date dimension(or tree off Invoice Dates) where it *ONLY* displays what we call a work day. (M-F) no holidays..
I have a have a query for that which shows only work days only in a source report out of RS, but how do you constrict that dimension to only show business days when sometimes we'll have revenue squeeking through on the weekends? What happens now is I build the cube and this special dimension gets crammed with every date due to the other report data sources populating it since they share a common date key. Is there anything I can do?
Instead of another date dimension could you consider a "day type" dimension that might have members as Weekday, Weekend, Holiday. This could then be used in conjunction with your existing date dimension for filtering or nesting as needed.
That is a smart idea!!!!! I'll give it a shot. Thanks Lynn!