I'm receiving SQL from analysis services. The query is below. The problem is that Postgres does not handle "Select CHAR(32)". Its trying to format some date data. Is there a change in the cartridge I could make soi that AS doesnt use this SQL? Thanks.
SELECT "dbo_tblDimCalendar"."dbo_tblDimCalendarddtDateTime0_0" AS "dbo_tblDimCalendarddtDateTime0_0","dbo_tblDimCalendar"."dbo_tblDimCalendardtxDoWDate0_1" AS "dbo_tblDimCalendardtxDoWDate0_1","dbo_tblDimCalendar"."dbo_tblDimCalendardtxSpDoWDate0_2" AS "dbo_tblDimCalendardtxSpDoWDate0_2","dbo_tblDimCalendar"."dbo_tblDimCalendardtxGerDoWDate0_3" AS "dbo_tblDimCalendardtxGerDoWDate0_3"
FROM
(
SELECT "ddtDateTime" AS "dbo_tblDimCalendarddtDateTime0_0",CONVERT(VARCHAR,"dbo"."tblDimCalendar"."cpdDayOfWeekName") + CHAR(32) + CHAR(45) + CHAR(32) + CONVERT(VARCHAR,"dbo"."tblDimCalendar"."ddtDateTime",101) AS "dbo_tblDimCalendardtxDoWDate0_1",CONVERT(VARCHAR,"dbo"."tblDimCalendar"."cpdSpanishDayOfWeekName") + CHAR(32) + CHAR(45) + CHAR(32) + CONVERT(VARCHAR,"dbo"."tblDimCalendar"."ddtDateTime",101) AS "dbo_tblDimCalendardtxSpDoWDate0_2",CONVERT(VARCHAR,"dbo"."tblDimCalendar"."cpdGermanDayOfWeekName") + CHAR(32) + CHAR(45) + CHAR(32) + CONVERT(VARCHAR,"dbo"."tblDimCalendar"."ddtDateTime",101) AS "dbo_tblDimCalendardtxGerDoWDate0_3","CALENDAR_KEY" AS "dbo_tblDimCalendarCALENDAR_KEY0_4"
FROM "dbo"."tblDimCalendar"
)
AS "dbo_tblDimCalendar"
WHERE
(
(
"dbo_tblDimCalendar"."dbo_tblDimCalendardtxDoWDate0_1" =
@Param1
)
)
Analysis Service is sending invalid SQL
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Please send me a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.
Could you please comment the following code, what do you expect from it?
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.
Could you please comment the following code, what do you expect from it?
Code: Select all
...
...CONVERT(VARCHAR,"dbo"."tblDimCalendar"."cpdDayOfWeekName") + CHAR(32) + CHAR(45) + CHAR(32) +...
...
-
- Posts: 4
- Joined: Thu 27 Sep 2007 00:47