dyrex Posted March 6, 2014 Share Posted March 6, 2014 Hi,Is there any possibility to create automatic export (e.x once a week) MDX in Excel format? I can login every week to JasperServer and open OLAP View and after click export to Excel and after send fili using ma email client but I'm looking for a option to this task automaticly. For normal Jasper Studio reports we can create schedula but for OLAP View there is no such option.I've found that I can insert MDX query in JasperStudio but it will look different than I can see when I press export to Excel in OLAP View :(MIchal Szymanski http://blog.szymanskich.net Link to comment Share on other sites More sharing options...
elizam Posted March 6, 2014 Share Posted March 6, 2014 Is this your situation:Created AD Hoc View with OLAP source, using the Export icon at the top of the Ad Hoc Editor, and exporting to Excel?If this is the case, you can save the view as a report. Just use the Save icon and select "Save Ad Hoc View and Create Report". Then you can schedule the report like any other report. Link to comment Share on other sites More sharing options...
dyrex Posted March 7, 2014 Author Share Posted March 7, 2014 Well, there is one problem we use community edition and your solution works probably only in paid version :( Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now