A Different Approach to Implementing Time Calculations in SSAS

portfolio1 portfolio2 portfolio3 portfolio4

Business Intelligence Consulting

OLAP Business Solutions offers fully customized consulting services for your business intellgience needs.

Customer Testimonials

Look at what our customers say about us...

Mentoring

OLAP Business Solutions prides iteself on knowledge transfer and mentoring during the consulting process.

Customer Testimonials

Look at what our customers say about us...

small portfolio1 small portfolio2 small portfolio3 small portfolio4
Business Intelligence Consulting
get in touch

Analysis Services Date Calculations Paper

Time Calculations Paper

Sample Database with Project Files

NOTE: Excel 2007 has a bug which does not allow users to select calculations from a dimension that is not the measures dimension. If you are using Excel 2007 then you will need to alter this solution.

Comment out the CREATE MEMBER statements.

Physically add the calulated members to the DSV as part of the dimension table.

This works with Excel 2007 because the members are no longer technically "calculations", but rather real members loaded from the dimension. The Scope statments then populate those members.

 

The tips provided here have no implied warranty. 
They are provided as a free service and are informational in nature.

 

slide up button