Using SSAS with a Vertica database
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.