Error 14081 - Conditional aggregates
604145Oct 19 2007 — edited Oct 19 2007Hi !
I'd like to create conditional aggregates in OBIEE.
This is my problem : I have a fact table, with an 'amount' column and a 'probability' column. I have to create measures that aggregate (sum) amounts only for a certain range of probability ('Other Opportunities : probability between 1 and 59, 'Strong Opportunities' : probability between 60 and 80, ...).
So, I made indicators with the expression builder, with this kind of expression, using case when :
CASE WHEN
SugarCRM."Affaires Faits".Probabilite > 0
AND SugarCRM."Affaires Faits".Probabilite < 60
THEN SUM(SugarCRM."Affaires Faits".Montant) END
Even though this expression raises no syntax error, this is the description error OBIEE gives me while checking consistency :
BUSINESS MODEL SugarCRM:
[14041] Error in measure definition for column Autres. Nested aggregate measure definitions are currently not supported.
Has someone created conditional aggregates ? Is there another way to make it ?
Thanks.
Cyril