Issue with export to excel

We have a user specific issue with a view application in a wizard. We’ve confirmed most users (admin and non-admin) can export the view to Excel without issue. This user only has read access to the data in the report, but sees all data as expected. When he tries either Export > Excel with Filter Values or Export > Excel (Load Format), then screen just doesn’t do anything. Exporting to PDF works fine.

I thought it might be cache or some setting on the browser (Chrome), so had him switch to Edge but had the same issue.

Then I (an admin) signed on in his Edge browser and the export worked. This leads me to believe that it’s a permissions issue, but I don’t know where or why export permissions would be restricted.

I’m not aware of anything which would prevent export to Excel as long as the user had read permissions to all the cubes used in the widget.

Have you been able to replicate this for any other user or on the standard demo model?

Hi OP,

Was there ever a reason found for this. We have something similar, instead the export works for a period off time, then stops working. If I toggle the export flag in the settings, it seems to work again, however days go by, then stops working again.

Anyone ever resolve this one?

I’ve never paid much attention to this option but I have a ticket in today from a user saying the button never works.

I go to the report and see I have the Export to Excel options are there (“Excel With Filter Values” / “Excel (Load Format)” / “PDF” / “Custom” / “Print” ).

Clicking on either of the Excel options does absolutely nothing. Clicking on the PDF or Custom or Print options all do work in that they let me create a PDF. But the user does not need a PDF. They need an Excel version.

Going to Cubewise youtube help it just shows “here is the button… click on the button here is the report in Excel”.

Are there any firewall rules I need to unblock? Settings I need to configure? Things I need to install? I’m full admin and I have Excel on my PC, so not sure what could be blocking it. I’ll keep trying to find out though. This topic was just the first thing a Google search revealed.

Note: This is what I get in Chrome debugger when I click the button. Nothing happens in the report at all, but this generates in the debugger:

I get no such errors when I do a PDF export. (In fact the console in the debugger generates absolutely nothing when I print in PDF mode).

EDIT: Made a new simple view and tested the export to Excel functionality and it works without issue there. So the structure works no issue on a simple view. But a more complicated crossjoined view unfortunately silently fails.

Anyone at Cubewise have any ideas? At Cubewise’s request we made a push to our CFO about the power of Apliqo to export to Excel. However the first report his team has shown interest in exporting… the export doesn’t work. Which makes it hard to convince him that this is a good feature and selling point of Apliqo.

I’m guessing the export functionality has some limitations and doesn’t like custom row or some other feature in this report? But it’s hard to tell without seeing the internals of what is erroring and having direct control over it.

There have been some issues with export to Excel not working for widgets containing inserted rows and columns with custom formulas. I believe that this should be resolved in the latest 2024.09 fix pack. If you are on the current version then please submit a bug report.

Thanks. We are about a year behind, so definitely overdue for an upgrade.