Options
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
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.
0
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>