Measure Functions Available for Data Cube

rtruban

Hello,

I am working on metric report that shows average durations across a couple of dimensions. There are only a couple of available functions in a data cube measure (max, min, sum, first, last, count, distinct count). Is there a way to get the functions which are available to use in an aggregate available for a data cube measure?

I did create a count and sum measure in the cube and then created a derived measure in the cross tab that was sum/count, but that seems a little clumsy.

Thanks!

Rob

kclark

You could create a computer coulmn and access these in your data cube.