I’m going to quibble with your facts. SQL Server Analysis Services has always had a “ROLAP mode”, where it gets its results using SQL. Microsoft doesn’t go out of its way to tell people, but it works fine against non-Microsoft databases. For example, you can get it working on Oracle[1]. So, in principle at least, it could speak to Kylin as a SQL data source.
Now, whether Kylin wants to go out of its way to support the SQL that SSAS generates… that’s not a technical question, it’s more of a question of business priorities. Julian [1] https://msdn.microsoft.com/en-us/library/aa548609(v=ax.10).aspx <https://msdn.microsoft.com/en-us/library/aa548609(v=ax.10).aspx> > On Jun 9, 2017, at 9:55 PM, ShaoFeng Shi <shaofeng...@apache.org> wrote: > > Hi Barry, > > From this article > <https://www.mssqltips.com/sqlservertutorial/2000/sql-server-analysis-services-ssas-tutorial/>, > SSAS is an OLAP engine that runs over SQL server, which is similar as Kylin > runs over Hive/Hadoop. Both SSAS and Kylin support using PowerBI/Excel as > the visualization tool. So there should be no chance to "use SSAS to call > Kylin cube". If you want to use PowerBI/Excel, you can directly call Kylin > cube with Kylin's ODBC driver. > > Hope it helps. > > 2017-06-01 16:33 GMT+08:00 Barry Han <huany...@gmail.com>: > >> Hi Kylin Team, >> I would like to use SSAS to call Kylin cube. >> >> *Is it possible?* >> <http://apache-kylin.74782.x6.nabble.com/file/n8148/a.png> >> >> >> Thanks >> Barry Han >> >> -- >> View this message in context: http://apache-kylin.74782.x6. >> nabble.com/Is-it-possible-to-integrate-Kylin-and-MS-SSAS-tp8148.html >> Sent from the Apache Kylin mailing list archive at Nabble.com. >> > > > > -- > Best regards, > > Shaofeng Shi 史少锋
