Hi,
well my questions is very basic , i would like to know what is the whole idea of providing the description AGGR=? for the metric description.
cause some of my metric refreshes when i provide aggr=sum but for some of it doesnt work so i changed back the AGGR=NONE then the metric refreshed , i dont understand when to use NONE or SUM . all i know is that we provide this description only to make sure what the user selects the right aggregate function while creating metric .
i would like to know indepth logic behind this.
thanks
kol
Is is still AGGR=SUM even if the pre-aggregation isn’t a SUM? I have a measure which is a rating - one measure divided by another expressed as a percentage. So it isn’t a SUM. Is there as AGGR=DIV or doesn’t it matter? Is AGGR=SUM just a flag that the system looks for so it knows whether or not to aggregate when the metric is created?
You can define indicators to create metrics by 2 ways:
1- if you want to choose the aggregation at metric creation level, then in the indicator select statment, don’t set an aggregate function (just set the DB column name). In this case, the description field MUST BE blank.
2- if you want to force the metric aggregation method, then in the indicator select statment, use an aggregation function. In this case, type AGGR=your_aggregate_function in the description field.
So, the first solution allows you to create a sum metric, a max metric and a min metric (for instance) based upon one indicator. The second solution will need to define 1 indicator by metric.
And, in addition to Ghislain’s information: Debbie, you’re right.
You may enter AGGR=SUM any old time, because all it does is, it tells EPM that the measure is already aggregated (no matter how), so you won’t be presented with a choice of aggregation options when creating the metric.
(BOB member since 2005-03-01)
(BOB member since 2005-10-25)