Using SSAS with a Vertica database

Rajesh_ChRajesh_Ch Employee, Registered User

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 

Capture.PNG

 

 

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.

Comments

  • avoroninavoronin Registered User

    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. 

  • avoroninavoronin Registered User

     

    You can try to fix this in catrige file 

     

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

  • Rajesh_ChRajesh_Ch Employee, Registered User

    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_ChRajesh_Ch Employee, Registered User

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

  • vavasjcvavasjc Registered User

    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>

     

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file