PDA

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



arunks
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
BT_DW_FACT_ADU_PO_PROFILE_2

Physical table id is
PT_DW_FACT_ADU_PO_PROFILE_2


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....




[PT_DW_FACT_ADU_PO_PROFILE_2.OFFICER_USER_ID]=121







[BC_DW_FACT_ADU_PO_PROFILE_OFFICER_USER_ID_2]=121






[PT_DW_FACT_ADU_PO_PROFILE_2.BC_DW_FACT_ADU_PO_PROFILE_OFFICER_USER_ID_2]=121





[BT_DW_FACT_ADU_PO_PROFILE_2.BC_DW_FACT_ADU_PO_PROFILE_OFFICER_USER_ID_2]=121






[DW_FACT_ADU_PO_PROFILE.OFFICER_USER_ID]=121






[OFFICER_USER_ID]=121






OFFICER_USER_ID=121






DW_FACT_ADU_PO_PROFILE.OFFICER_USER_ID=121







"DW_FACT_ADU_PO_PROFILE.OFFICER_USER_ID"=121



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

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