Using SSAS with a Vertica database

Hi, I am using SSAS with Vertica database. Just curious what company are you from? 

We had this issue and it was fixed by installing proper driver. And deploying proper catridge file. 

In a Nutshell, there is a so-called catridge file under 

C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\Cartridges

or whatever your installation path is.

You need to deploy proper cartrige file vertica.xsl in connetion with vetica driver that uses " instead of [] around indentifiers. 

You can try to fix this in catrige file 

<xsl:param name="in_IdentStartQuotingCharacter">"</xsl:param>
<xsl:param name="in_IdentEndQuotingCharacter">"</xsl:param>

HI avoronin,

Thanks for your suggestion. I am working in HP.

I checked the catdridge file (vertica.xsl) and it is having like below 

<xsl:param name="in_IdentStartQuotingCharacter">"</xsl:param>
<xsl:param name="in_IdentEndQuotingCharacter">"</xsl:param>

But still i am getting same error.

Thanks . Now It is working fine . I had done above change and I have restarted the SSAS Service.

I didn't understand. What did you change?

My file vertica.xsl in C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\Cartridges is like this:

<!-- Area of STANDARD parametrizations: these are externally passed -->
<xsl:param name="in_CanUseParams">yes</xsl:param>
<xsl:param name="in_IdentStartQuotingCharacter">"</xsl:param>
<xsl:param name="in_IdentEndQuotingCharacter">"</xsl:param>

<xsl:param name="in_StringStartQuotingCharacter">N'</xsl:param>
<xsl:param name="in_StringEndQuotingCharacter">'</xsl:param>