Saiku: How to use boolean fields from the database?

Hi. In Calc, I got (computed) boolean variable to Saiku, works quite similarly with boolean fields:

1) create category:
0='no', 1='yes'

2) R script: tree$tree_is_alive <- ifelse( tree$tree_health ==5, 0, 1 )

Regards, Lauri

Hi Lutz,

Thanks Lauri for your answer and for posting some sample code!

Boolean fields are not supported by Calc, you should instead use a category with two possible values (Yes/No) when you collect your data, or as Lauri suggested, you can create a new calculation step type category in Calc.

Please let us know if you need more info.

Regards,

Mino