milingo83

04-06-2008, 10:41 PM

Hello,

i'm trying to define a simple business column with a MQL constraint formula but something seems to go wrong. The formula is just a boolean check such as

[BT_TABLE.BC_COLUMN] > 10

As far as i know this should select only the values above 10. When using this column in Ad-hoc reporting i get null values ('-') and no error.

I use Metadata Editor 1.7.0.0306 and Pentaho BI Platform 1.8.0.1069. I don't know if i'm missing something or this is just not working right (formulas are a recent feature).

I'd also like to know if there is a way to do a mapping between values within a column and new defined ones. For example, turn numerical values (0,1,2..) into descriptive strings ("Sales Department"...). I tried with CASE formula but i got a similar error.

Thanks.

i'm trying to define a simple business column with a MQL constraint formula but something seems to go wrong. The formula is just a boolean check such as

[BT_TABLE.BC_COLUMN] > 10

As far as i know this should select only the values above 10. When using this column in Ad-hoc reporting i get null values ('-') and no error.

I use Metadata Editor 1.7.0.0306 and Pentaho BI Platform 1.8.0.1069. I don't know if i'm missing something or this is just not working right (formulas are a recent feature).

I'd also like to know if there is a way to do a mapping between values within a column and new defined ones. For example, turn numerical values (0,1,2..) into descriptive strings ("Sales Department"...). I tried with CASE formula but i got a similar error.

Thanks.