Hi all,
We are using the Sybase IQ 12.5 on an Unix server and everytime we create a new Query Subject, the only sql type we could use is pass-through. Any other type causes an error. This sql type works fine, but when we create a join between two query subjects, this join is locally processed by the Cognos server (8.3 and 8.4 have the same behaviour).
My problem is that we have more than 4 million rows on the fact table and the performance is awful so far.
Can anyone, please, help me on that?
Thanks in advance.
Felipe David Rosochansky
So, when you import a table from the database, into FM, are you able to test and get back data as is? and what does the SQL statement look like
just select * from datasource.table ??
When the table is imported, the SQL is just like select * from [datasource].table. If I try to test this, I got the following error: "This Query contains an error and can not be executed. RQP-DEV-0060 The source of the query subject aBmtQuerySubject is invalid."
In order to make this work, I have to change the SQL Type to pass-through. After doing this, the SQL works properly.
do any of these help, or you tried them and no luck???
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bSybase+%2bIQ+%2b12.5&uid=swg21342456&loc=en_US&cs=utf-8&cc=us&lang=all
http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bSybase+%2bIQ+%2b12.5&uid=swg21339339&loc=en_US&cs=utf-8&cc=us&lang=all