Constraint formula error

[milingo83]

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.

[MattCasters]

Buenos dÃ*as milingo83,

I don't know how your model looks, but this should work just fine. Perhaps you just forgot the operator (AND/OR)?
Try it in the Query editor in the metadata editor first. Error handling and feedback in the Ad-hoc tool (WAQR) isn't really eh top-notch ;-)

Matt

[milingo83]

Thanks for the feedback Matt! I finally solved the problem.

Apparently boolean expressions must also follow the syntax FUNCTION_NAME ( PARAM ; PARAM ), not the infix version. i'm not sure about this, since there is an infix example in the wiki but that's how i got it right.

I'm also trying to use the NOW function both as an MQL constraint and as a calculated formula for a new defined column. Always get a syntax or parse error...
My final goal is to add a constraint over dates to accept only "today" values. I'm using the syntax "NOW()".

Regards

[MattCasters]

I tried the now() issue: just create a new physical column:

Name: Now
Formula: NOW()
Is exact? : true
Aggregation: none
Data type: Date

Now you can use that in expression.

Let me know if you meant something else.

Matt