How can I connect to SQL Server 2008 R2 Analysis Service without using Mondrian schema using Driver org.olap4j.driver.xmla.XmlaOlap4jDriver
?
I can connect with SSAS and getting data using preview option at Spoon >> Transformation I am following this article.
Successfully done these two steps
- Set up MS OLAP XMLA Server as SOAP Web Service
- Connecting Microsoft OLAP to Pentaho Data Integration (KETTLE)
Now trying third step
- Using Pentaho Report Designer (PRD) to report from Microsoft OLAP
But I can't see column names under Data Sets > Pentaho Data Integration > MS OLAP