sqlchuck4 (3/29/2016)
After looking at your response, I figured out that the issue is that for character fields where a case statement in the source view is used to calculate the field value, GreenPlum is not passing a character field size (i.e. varchar(30) where the the "30" is missing). Is it possible to set these values in the SSAS data source view without creating a named query? (using a named query creates syntax that is not compatible with GreenPlum) Thanks.
Well I don't know your exact setup, but I do know that SSAS doesn't always play nice with PostGres syntax - for example SSAS tends to use a lot of square brackets in the SQL it generates, which mean something different in PostGres. Can you not create a linked server and then use OPENQUERY? If not I would suggest that you make sure you have the appropriate up to date driver for what you are doing.