I am fairly new to Pentaho and wondering if there is a way to achieve my requirement.

I want to create a dynamic report using Pentaho Report Editor which can be accessed by users based on their column/variable specific access permission.

Consider there is a table with 5 columns - C1, C2, C3, C4, C5 and a single Pentaho report which displays all these columns in a tabular format.
I have three users U1, U2 and U3. I want user U1 to generate the report where he can see only columns C1, C2 and C3, the user U2 should see the columns C3, C4 and C5 and the user U3 should see all the columns.

I assume this can be done with the help of Pentaho Metadata Editor. Please confirm if it is possible and help me with the solution.

Appreciate your help.