John Johnson

In JS 5.6.1 I want to restrict the range of dates that can be chosen so I modified controls.components.js. This works for the maxDate - I can prevent dates being selected in the future by putting maxDate: +0 I want tro set minDate to some date in the past say 1st Jan 2013', but every format I have tried does not work. Has anyone done this successfully? (I am aware that I need to test this using the &_opt=false setting and then I need to run the optimisation process) (I am also aware that I could limit the range on the input control - but this still lets a user enter an invalid date - it just flags it as invalid afterwards)

I have a report that may be called from another report as a drill down, or may be called directly. I would like to have different default values in each case. What would be the best method to identify whether the report was called from another report or as a standalone - and to set the default values accordingly?

I would like to limit the number of pages that can be exported to Excel. Is there any parameter that can be set to do this? (I could make use of the REPORT_MAX_COUNT parameter at the jrxml level but I would like to do this at the server level, globally). Does anyone know how this might be achieved?

In the domain editer, normally multiple pre-filters are chained using AND (filter1 AND filter2 AND ...) Is there a way to alter this behaviour so the pre-filters are chained using OR (filter1 OR filter2 OR ...)? Regards John Johnson

I have a valid Mondrian xml schema, created in the OLAP Mondrian workbench. I create a DataAdapter in Jaspersoft Studio using the Mondrian xml schema as the Catalog URI and the JDBC connection details for the underlying MySQL database. "Test Connection" returns "Successful". When I create a report using this data adapter the report wizard displays "Getting metadata for 'my schema' Please wait..." Nothing further happens. Is this a bug - or have I missed a step?

Where can I download the Mondrian Workbench? Is it available in the Community version?