I'm trying to use XMLA connect and Excel 2016 CUBE-Functions to get data from a Pentaho BI-Server 5.2 / Mondrian 3 cube. Everything works fine. When I save the file and open it again Excel shows a warning that the file is corrupted. If I choose to repair it, it says (translated from German):
Removed Feature: PivotTable /xl/pivotCache/pivotCacheDefinition2.xml-Part (PivotTable-Cache)
Removed Records: Properties of the workbook /xl/workbook.xml-Part (Workbook)
If I only use pivot tables the file does not get corrupted.
-Caspar
Last edit: Caspar 2015-10-10
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I'm trying to use XMLA connect and Excel 2016 CUBE-Functions to get data from a Pentaho BI-Server 5.2 / Mondrian 3 cube. Everything works fine. When I save the file and open it again Excel shows a warning that the file is corrupted. If I choose to repair it, it says (translated from German):
Removed Feature: PivotTable /xl/pivotCache/pivotCacheDefinition2.xml-Part (PivotTable-Cache)
Removed Records: Properties of the workbook /xl/workbook.xml-Part (Workbook)
If I only use pivot tables the file does not get corrupted.
-Caspar
Last edit: Caspar 2015-10-10
Hi,
I've opened a ticked for this. You cand find it here https://sourceforge.net/p/xmlaconnect/tickets/22/ . As soon as we have something for your problem you will see it in the ticket.
Alexandra
Last edit: Alexandra Davidoiu (Iancu) 2015-10-28
Thanks! I'll monitor the ticket. Let me know if I can help you any further with this problem.
-Caspar