3 ms·
I would love to see LibreOffice Calc work with XMLA OLAP servers, like Mondrian. This would be a major competitive advantage to Excel, which can only talk to S
by elchief 13y ago
I would love to see LibreOffice Calc work with XMLA OLAP servers, like Mondrian.
This would be a major competitive advantage to Excel, which can only talk to SQL Server, or to others via very expensive plugins.
- ygra 13y agoExcel can use any OLE DB driver or ODBC just fine to access other databases. It's not restricted to Access and SQL Server. From the dated look of the dialog windows involved I'd say it's been that way for a long time and isn't new in 2010.
- bkor 13y agoOLAP is not like SQL or ODBC. It shows things in a cube. OP is talking about OLAP, not just SQL/some database (which is of course works perfectly fine). Note: Aside from knowing that OLAP is different, not much practical knowledge.
- ygra 13y agoAh, then I got the wrong idea about them mentioning SQL Server.
- elchief 13y agoI should have said "Excel can only talk OLAP to SQL Server". It can talk ODBC/OLEDB to many databases.