Pentaho

Wouldn't it be easier to use a view as a data source and use the internal variable ${env::username} in the query?

Hi Andrew,

Thank you for the reply. We are creating reports in Pentaho Report Designer using PostgreSQL as data source and then publishing them to the server. When a user logs into the server he should see only his region data.

As I am new to this tool I didn't understand your answer. Can you please explain in detail on how to achieve this.

Hi Bhargavi

The datasource for the PRPT will be an SQL query . You can use the ${env.username} variable to get the logged in user Perhaps like this...

select

si.sensitive_name,

si.sensitive_date

from

sensitive_information as si

where

si.allowed_user = '${env::username}'

The value of ${env::username} will be replaced with the logged in user.

Here's a tip on how to set it when you're developing a PRPT on your desktop

https://www.bizcubed.com.au/set-envusername-for-testing-prpt-in-pentaho-report-designer-prd/

Hi Andew,

Thank you very much for the answer. This worked for us in the report designer.

We are embedding this reports to the web application. Will this query(env) automatically take the username from the application login or is there any other variable should be used.

It would be of great help if you help us with this.

If you are using the Pentaho BA server to present the report (I assume you are) then it will pick up the login

Does anyone know how to do the same, but with roles or users that come from an LDAP Security? In the method used, a table must still be created that identifies the user and is associated with the information that he can or cannot see.