Hitachi Content Platform​

 View Only

 How to pass user security to the reports embedded in the application?

  • Object Storage
  • Hitachi Content Platform HCP
Bhargavi Gali's profile image
Bhargavi Gali posted 05-13-2020 06:21

Hi Everyone,

 

We created Reports in Report Designer and published them to the server. Then we are integrating these reports in the application.

When a user Logins to the application the same user security has to be passed to the reports also so that the user can only see data assigned to him. 

Can someone help how to pass the user security assigned to the application to the report?

 

Regards,

Bhargavi

 


#HitachiContentPlatformHCP
Leonardo Trigoserrano's profile image
Leonardo Trigoserrano

 

Hello, you must create some steps in the database and others in the report:

 

1.- You must create a table that contains the user names and another table that will have the username associated with the fields you want to filter, for example region or country or something more specific.

 

In your report you must create a parameter, where you will use the default value formula = ENV ("username") and the result of that parameter is what you will put in your query in the where section, example where country.user = $ {username}