i am working on a BI project and I have decided to use Pentaho Platform and Calpont InfoniDB as Datawarehouse.

I have the following problem: I have the following problem: I have to analyze sensitive data, that will be stored encrypted into InfiniDB

When I create a new report, through the user console, however, the data must be accessible.

I created into the business model of Metadata-Editor a Formula, but this does not work.

How can I fix, then read the encrypted data from Pentaho? how to decrypt them in queries?

Thank in advance