Hello. I need to display pivot table from Microsoft Analysis Server cube. I coudn`t find any information about it. Is it possible in LibreOffice?
If you manage to pull the data into Calc you can create a pivot table of it. Calc doesn’t have the Excel CUBE*() functions (if that is what you were referring to).
1 Like
Microsoft has special providers for other sources. As example for Analysis Server this is MSOLAP.
ConnectionString>Provider=MSOLAP.8;Integrated Security=SSPI;Persist Security Info=True;Data Source=QQQQQQ;Update Isolation Level=2;Initial Catalog=EEEEEEEE
No data about providers for Olap from Libre ((
If you somehow can register a database using ODBC with embedded OLAP through a provided driver then maybe pivot table creation can use a “Data source registered in LibreOffice” Type Sql or Sql [Native] if connection string and query can be transparently executed. Maybe.
I don’t know if this PalOOCa OLAP Calc Extension is (still) any good but could be a chance if your OLAP server talks Palo or XMLA.
1 Like