View Full Version : Problem in applying formula in business view column

11-14-2008, 08:10 AM
Original database table name is DW_FACT_ADU_PO_PROFILE and in that one column is OFFICER_USER_ID

Business table id is

Physical table id is

The column id on which i m applying formula is BC_DW_FACT_ADU_PO_PROFILE_OFFICER_USER_ID_2

modified name property of table gives Table name as ADU SPO PROFILE

and column name is ADU OFFICER USER ID

I have tried so many combinations of formulaes as described on pentaho wiki and forum....










but nothing works...

Plz help me in implementing the formula so that i can display officer user ids only with value 121.

Plz reply as soon as possible

it gives me error with sqlcode -206,-104 maximum times

plz help

11-14-2008, 02:04 PM
At the moment you can't put predefined conditions in the metadata model.