If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to add calcultion in framework manager on aggr level

Started by dblinde, 22 Aug 2012 04:14:40 AM

Previous topic - Next topic

dblinde

Hella all,

i have two measures in my framework:
A- number of patients (count distinct patient)
B- total hours spent on a hospital bed

now i'd like to add a third measure with the following calculation : B/A (average hours spent on a bed p.patient)

How can i do this avoiding the problem that using this measure in query studio it does not add up the averages but keep using the calculation on each aggregation level i use on the grid?




blom0344

averages are by nature not additive. Why are you looking for a way to add them up?

tjohnson3050

Setting aggregation property to 'Calculated' will reapply the data item calculation at the aggregate level.