Cognos Insight - Custom calculation
Posted: Mon Nov 02, 2015 10:11 pm
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
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