nicholas

Thank you for this information, it will be useful to us. Nick

Hi, We'd like to allow some of our JasperServer 2.1.0 users the ability to create new report definitions (uploading new jrxml files, etc.) You need to use the 'manage' repository page do to this. It appears that this page is only accessible by users with the ROLE_ADMINISTRATOR role. Is there a mechanism to allow limited amounts of administration? To manage (areas of ?) the repository, but not to create/remote users, for example. Much thanks, Nick

Sometimes when changing the MDX query (either through the JPivot OLAP explorer or the MDX 'text editor') JPivot stops showing the results. Code: Mondrian still asks MySQL for some data: Code: and this returns data: Code: but the table shown by JPivot has no values in the cells. size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/jpivot_blank.png How do I discover what is wrong? Much thanks, Nick Post edited by: nicholas, at: 2008/01/28 14:16

Dear Forum, With respect to charts in the analysis view, is it possible to either: - Create a new default chart style (vertical line, particular font sizes, chart width etc.) or - Save with an Analysis View the state of the chart, so that the next time it is opened (by the same or different user) the chart has the selected settings? Also, is it possible to set the analysis view so that the chart always appears by default? Much thanks, Nick

Ok, thank you.

Thanks for the confirmation.

Thank you for this detailed answer.

Thank you for your response.

Thanks for trying this out and confirming the problem.

Thanks, that (commas, even with spaces after the comma) works. I didn't notice because of another usability problem - if the scheduled report isn't able to save the report output (set not to overwrite files, yet the file already exists) it appears not simply not save at all, nor send email. I'll create another forum post to discuss this. Thanks, Nick (EDIT: This does cause a message to appear in the 'Messages' list though, but these currently don't get emailed to me.) Post edited by: nicholas, at: 2007/12/31 10:14

Thanks for this confirmation. Do you know where I could find more information? I'd like to know how to monitor this cache, how long items last for, how large it could get, how to flush it early, etc. Much thanks, Nick

I was unsure if this was best posted here, or over at a JPivot forum. I selected here to start with, as if I can achieve this with editing some code maybe it is JasperServer specific help that I might need. I have this MDX query shown in the chart: Code:select {[Measures].[unit Sales]} ON COLUMNS, {[Time].[2006].[Q1].[1]} ON ROWS from [sales] I've done this to see what happens to the chart when it has only a single data point to show, and Vertical Line is set as the Chart Type. We're testing to see if single points are still shown at all, or they get hidden. It looks like nothing is drawn at all, because the line needs at least two points. My client says that Excel (their current application) would draw a small cross if a line wasn't possible. Could JPivot/JasperServer Pro 2.1 do this? If not, what might I need to do to make this happen? Much thanks, Nick

I'm sure this must come up regularly, but I've searched the forum and JS-Ultimate-Guide.2.0.0.pdf with nothing found. Please do just direct me at the last time someone asked if I just missed it! Are database results cached? There is no mention in the JasperServer Pro 2.1 interface, as far as I can tell. The question specifically relates to when this happens: View a report 'Export' the report as a PDF or CSV, etc.[/ol] During that export, is the SQL query run again? What if the query takes a long time to run? I've tried to find out myself with wireshark, watching the SQL traffic, but I don't see clear results. Thanks! Nick

Is there a roadmap item for allowing someone to right click on a field in the Ad Hoc editor and specify a criteria for filtering on the data in that field? This would then go into the SQL query as a 'where' clause. An example would be to right click on "date of birth" and let someone then specify a filter that selects only dates after 1970-1-1. I've tried to separate my questions into different posts so that they are a better resource for Google in the future, but this next one is related so I'll keep it here: Is there a plan for allowing 'SQL level' group-by in the Ad Hoc editor? At the moment, the grouping is done at the presentation layer, so that if we wanted to group the results by country, then show the average shipping cost per country, we apparently must be shown every individual item that is shipped. If the group-by clause went into the SQL query as well as the average() aggregation function, then the report would be able to show only the summary data. More importantly, the database would do the aggregation - we have millons of rows of data so this is important. Is there a better way for me to go about getting that information? My client needs to be able to ask questions such as "what is the maximum shipping cost for each country", etc. without having to create a report with iReport for every type of question they want to ask.

With JasperServer Pro 2.1, it appears that you can only write a single email address into the 'scheduling/output' page until "Email Notification". I've tried comma and semi-colon separated addresses in case this works. Is there a roadmap item or already a feature request to allow several addresses to be entered? (Or better, for a searchable checklist created from an LDAP query or similar...) Regards, Nick