We need your assistance, thanks in advance.
The scenario is need to build a cube using MICROSOFT Tabular model with data source as SAP HANA ,here we DON’T have any staging data base in SQL Server. So its kind of direct pull from SAP HANA Database(nothing but Tabular cube data source) to the cube and should be able to daily refresh of the data
In general Tabular cube retrieves the data using T-SQL if datasource is SQL SERVER.
So incase of tabular cube need to pull the data from SAP HANA,what would be the language.
My front end tools are excel pivot and Tabular cube.
To access the Tabular cube
- MS Excel uses MDX.
- POWER VIEW uses DAX.