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]

No comments:

Post a Comment