This content has been marked as final. Show 1 reply
Do you have a hierarchy for each dimension?1 person found this helpful
like a parent cluster node (with children c1, c2, c3, c4)
and a parent location node (with children L1, L2, L3)
and time with YR, QTR,MTH,DAY etc levels
You can then look at the call duration data (in AWM cube viewer or olap worksheet or cube_table view)
where cluster = 'the above parent node' and location = 'above parent node' and date = '2012'
If this is not what you are looking for, then paste your formulas here for:
period to date
that you tried to define.
Make sure that your cube was loaded (i.e., no rejected records) and that you can see the call duration data in AWM cube viewer (or olap worksheet or cube_table view) for the records that you mentioned.