ProClarity Tips

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

ProClarity Tips

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

 

ProClarity Professional allows users to create subtotals for rows and columns on the fly.  But sometimes it appears as though the subtotals aren't "calculating properly".  Below is an example:

The calculated member called "Store GM %" is not calculating properly. This is because the ProClarity subtotal formula is calculating AFTER the database provides the result. (As you can see, the subtotal is summing the percents.) To prevent this from happening, all calculated members should have a solve order of 1001 or greater. In Analysis Services there is a "solve order" property. If this is set to 1001 or above, then the database will calculate the percent AFTER ProClarity. 

Once the solve order is set, the proper value is displayed.

 

slide up button