I am trying to run SSAS cubes. While running getting error like
OLE DB error: OLE DB or ODBC error: Undefined column name sh.SiteHours_Id.
The source tables are present in redshift database. I checked the column is already there in the redshift database.
I checked the relation between the fact and dimension tables as well manually. I did not find any issues there as well. Not able to resolve this issue. Can anyone please guide me how can i resolve this issue.
I am trying to run SSAS cubes. While running getting error like
OLE DB error: OLE DB or ODBC error: Undefined column name sh.SiteHours_Id.
The source tables are present in redshift database. I checked the column is already there in the redshift database.
I checked the relation between the fact and dimension tables as well manually. I did not find any issues there as well. Not able to resolve this issue. Can anyone please guide me how can i resolve this issue.
Share Improve this question asked Feb 3 at 20:46 insanityinsanity 1,1786 gold badges16 silver badges30 bronze badges1 Answer
Reset to default 0Little to go on here but I'll take a stab.
You error message has mixed case letters for the column name and usually this won't be an issue but Redshift connections can be configured to enable case sensitivity. Check the setting of this configuration value. If "true" it would explain why the column wasn't found.
See: https://docs.aws.amazon/redshift/latest/dg/r_enable_case_sensitive_identifier.html