Page 1 of 1

Cognos Insight - Custom calculation

Posted: Mon Nov 02, 2015 10:11 pm
by gujsa01
Hi,

My first attempt to use Insight here.

Got through loading fact and building dimensions using fact SQL successfully.

Trying to add Custom calculation by right clicking on a column->Calculate->Custom to add the following:
IF (DB(..) > 2, 'HIGH', 'LOW');

Errors out.

Is this possible using Custom Calculation or have to define rule using Architect?

Appreciate any help.

Thanks,

Sameer Gujar

Re: Cognos Insight - Custom calculation

Posted: Tue Nov 03, 2015 8:18 pm
by gujsa01
Resolved.

Just insert the right hand side of the rule and exclude area definition.