Using SSAS with a Vertica database

Rajesh_Ch

Hi All,

We have a requirement that needs to build SSAS Cube with back end Vertica Database. 

We have connected the Vertica Data Source using Vertica OLEDB provider and it was successfully working.

When We are started to Process the Cube, getting below Error 

 

 

This is because , in SSAS Every dimension and Fact (Partition ) Query are dynamically generated based on the its Query which will have "[" for each and every column. Vertica will not accept this character. Could anyone please let me know the suggestion on how to fix this issue.

avoronin

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. 

avoronin

 

You can try to fix this in catrige file 

 

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

Rajesh_Ch

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.

Rajesh_Ch

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

vavasjc

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>