SSAS Problem with square brackets
Posted: Fri 21 Feb 2014 15:37
While processing dimensions in SSAS via dotConnect Postgres professional driver i got querries like:
And errors:
Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: syntax error at or near "[".
I think this problem is much like another thread, but with another db: http://forums.devart.com/viewtopic.php? ... 907fa90057
It was working before with express trial version of driver after some manipulations with files, but i can repeat that now purchased licence.
Code: Select all
SELECT
DISTINCT
[dbo_Sites].[id] AS [dbo_Sitesid0_0],[dbo_Sites].[title] AS [dbo_Sitestitle0_1]
FROM [public].[sites] AS [dbo_Sites]Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: syntax error at or near "[".
I think this problem is much like another thread, but with another db: http://forums.devart.com/viewtopic.php? ... 907fa90057
It was working before with express trial version of driver after some manipulations with files, but i can repeat that now purchased licence.