Showing posts with label caculate. Show all posts
Showing posts with label caculate. Show all posts

Friday, February 24, 2012

How to caculate result throw time range using the cubes?

How can I calcualte the sales value from 1/15/2005 to 4/23/2005 Using Sales Cube?

Use calculated member with a sum function. The set in the sum function should be specified as time range between members of Time (or Date). You can easily do the range as "member1 : member2", like in this example:

select [Date].[Date].&[1] : [Date].[Date].&[271] on 0 from [Adventure Works]