Calculated Measures and Filtering Condition

[kri]

I am very new to OLAP and Analysis services. Trying to create a Cube for the following requirement...
I have a table which stores information about phone calls made by customers. Based on "Call Duration", I need to create details like
-- On any given day/month/quarter/year, how many calls were handled within 5 minutes ,within 10 minutes, within 15 minutes and so on.
I Created a cube with standard "Time" dimension and "Call Duration" as Measure. Also created a Calculated Member to count for calls within 5,10,&15 minutes
If my sample table contains three records for current date with CallDuration as 4,6,7, browsing the cube produce result for that day as

CallDuration as 17
Within5 as 0
Within10 as 0
Within15 as 0

Since the [Call Duration] has the value of 17 at the [Day] level of Time dimension, the condition to check whether CallDuration is less than certain minutes is always false.

I would really like to see
Value 1 being reported for Within5 and
Value 2 being reported for Within10



Any help would be appreciated .

Thanks

 

[pabloj]

There is an example around the web (Dynamic banding) for calculated dimension members, which divides the Foodmart stores in size ranges and consequently rearranges measures (i.e. sales related to store size) by building a fake dimension (Store size) and assigning calculated members to it. I think this can be your case (number of calls related to time ranges).


Stick to your guns

 

[kri]

pabloj,
Thanks for the information.I am yet to look into it. I hope it will give me much insight in this area. Mean while, i was able to do what i asked for by creating "derived measures". I changed the source column of derived measure to have condition
"case when (CallDuration<5) then 1 else 0 end".

Thanks for your time