The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Using SSAS with a Vertica database

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

  • 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>

     

     

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.