If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Date Dimension with just "Business Days"?

Started by aerick911, 27 Jan 2015 11:42:38 AM

Previous topic - Next topic

aerick911

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? 

Lynn

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.

aerick911

That is a smart idea!!!!!  I'll give it a shot.  Thanks Lynn!