Currently the pivot table supports to connect OLAP database from remote server alone with dpump *.dll. So, need to provide a provision to connect the OLAP database from SSAS directly.
It will be connected by providing following information.
- SQL server name
- Catalog name
- Locale identifier (if required)
- Authentication (if required)
To connect local database, need to create a API service where the above information should be provided. So, the above information won't be shown in browser. Also, the API service will be supported to connect OLAP database from remote server with the existing option(dpump *.dll) as well.
Additionally, need to provide support to access OLAP data base from Azure Analysis Service.