Hi!
I try to create OLAP-project using your driver and get some error.
I have successfully created data source to PG-server, it get schemas and tables from there.
When I try to add any table on DataSourceView I get error syntax error at or near "["
I see on other threads that you send some specific xsl file to the users in order to try to resolve this issue. Can I get the same file to test it?
Thanks.
Getting error when try to connect to SSAS
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Getting error when try to connect to SSAS
When you install dotConnect for PostgreSQL you need to restart the "SQL Server Analysis Services" service or your computer. After the restart it should work.
If the "syntax error at or near "["." exception still occurs after restarting, please make sure that the Devart.Data.PostgreSql.xsl file is present in the following locations:
Program Files\Microsoft SQL Server\%Your SQL Server Instance%\Tools\Binn\VSShell\Common7\IDE\DataWarehouseDesigner\UIRdmsCartridge
Program Files\Microsoft Visual Studio x\Common7\IDE\PrivateAssemblies\DataWarehouseDesigner\UIRdmsCartridge\
Program Files\Microsoft Visual Studio x\Common7\IDE\PrivateAssemblies\Business Intelligence Semantic Model\Cartridges
We will also send this file to you via email.
If the "syntax error at or near "["." exception still occurs after restarting, please make sure that the Devart.Data.PostgreSql.xsl file is present in the following locations:
Program Files\Microsoft SQL Server\%Your SQL Server Instance%\Tools\Binn\VSShell\Common7\IDE\DataWarehouseDesigner\UIRdmsCartridge
Program Files\Microsoft Visual Studio x\Common7\IDE\PrivateAssemblies\DataWarehouseDesigner\UIRdmsCartridge\
Program Files\Microsoft Visual Studio x\Common7\IDE\PrivateAssemblies\Business Intelligence Semantic Model\Cartridges
We will also send this file to you via email.