I have a field interest rate that is defined as 'unsupported' in the framework because it should not be summed.
The field is used to multiply with ledger balance. In cognos, when I create this calculation as :
([NOTE_CUR_INT_RTE]*[Note Average Bank Share Balance Mtd])
it comes across in the sql as:
MIN("DIM_C2_NOTE_SCD"."NOTE_CUR_INT_RTE") * SUM("FACT_NOTE_ACCT_M0"."AVG_BNK_SHR_MTD_BAL") AS "Data_Item1
when in fact is should be:
sum("DIM_C2_NOTE_SCD"."NOTE_CUR_INT_RTE" * "FACT_NOTE_ACCT_M0"."AVG_BNK_SHR_MTD_BAL") AS "Data_Item1
HOW DO I FIX THIS?