brice.montandon

Dear Gurus, I'm a really beginer in Jasper Report and we are using v6.0.1 We have a datawarehouse on which we have to do both Dashboards/Reports and Adhoc Views. Both of them have to integrate a row level security (the same one) based on several attributes of the user connected. I try to find how to achieve this row level security and it seems that I have to use 2 distinct ways depending if I produce a report or an adhoc view. For report I have to use some $P syntax in where clause of my query when for adhoc view I can use a security file using groovy syntax. Some of our query for report are quite complex and using subqueries, so they must be based on SQL queries as we didn't find a way to do them with domain designer. My question is, is there a way to share the same security to be more efficient for both reports and adhoc views ? A solution would be to create a domain based on a SQL query, is it possible ? Thank you for your inputs. Regards, Brice

Not sure it will help you but I found it interesting and it talks about role security : https://www.youtube.com/watch?v=5z0UmsWD0cI&list=PL5NudtWaQ9l7lRpVT0he0gj3mPJ83xM4r&index=20 I'm just a beginer user trying to find security answer on the forum so excuse me if the link doesn't help you Regards and good luck

exactly what I did. Change the PostgreSql-specific SQLGenerator. PostgreSql is the driver used for Redshift, and PostgreSql accepts both SUBSTR and SUBSTRING syntax. Thank you for your answer. Regards, Brice

Here is the solution. In file applicationContext-semanticLayer.xml located on the server, all functios are mapped. They can be generic or specific for a given technology. We added a specific translation for Mid for PostgreSql technology.

After some more investigations I've retrieved the full error message. Here is the interesting part : We are using Jasper in Amazon and our data source is stored in a Redshift DB. Recomendations for Redshift access is to use PostgreSql JDBC driver. In Jasper Mid function is mapped to SUBSTR PostgreSql function, when in Redshift SUBSTR doesn't exist and should be repaced by SUBSTRING, exactly what I got in error message. Now I will have to look for the function template file dedicated to Postgresql on Jasper Server and change function definition. I will try to comment this ticket if it works. Brice

Hi, I'm trying to create a calculated field in an Ad Hoc view. I'm using Jasper Report Sever 6.0.1. I'm not trying to create a calculated measure but a calculated field. So in my Ad Hoc view, I am selecting "Create calculated field". In Formula I'm tiping : Mid("Account Id",1,4) where "Account Id" return a string made of numbers. I click on validate button and reached a "Validation successful!" message. So I save it. Once I'm trying to use it in the Ad Hoc view it raises message : "An error occured while performing the previous request". I really don't know what happens. I've noticed that if I created by using feature "Create Calculated Measure" it works better. I can integrate it as a measure but it's not working as I want cause it is not a measure but a dimension. Any idea on how it should work ? Thanks in advance. Brice