outer join and filtering

[cvdtg]

Hi,

We have some problems with outer joining in Impromptu

Apparently the two table left outer join is split in two
queries that are fired against a mainframe db2 database.

One is an inventory table with as column the product code
the other table is the parts table with product code as key

the join happens on product code as you can imagine,

there also has been a filter set on the product key

Now when executing the report the query that is fired for the first table contains the filter on product number but the second query does a full tablespace scan because the where clause filter was not progagated to it.

The database only processing option in Impromptu is not allowed we get a strange message saying that the
"Processing requirements exceeds the current client/server limits"
Ever heard about this one ?


any ideas ?

 

[CognosProfessional]

I looked up the error, and found these 2:

IMP 4: To resolve the error, log on as a Creator in the Administrator version and change the Query Processing in the Catalog > User profiles > Client/Server tab to Flexible Processing.

IMP 6: After upgrading a report from Imp 5 to Imp 6, it is not possible to change the query processing option from Local Limited Processing to Database Processing or Flexible Processing. Attempting to do so will result in the following error message:

Error:
Cannot execute query. Processing requirements exceed the current client server limits.
Solution:
1) Open the original report in Imp 5
2) Change the processing option on Report | Query | Client/Server tab from Limited Local Processing to the desired processing option.
3) Open the report in Imp 6 and upgrade it.
-----------------------------------------------
hope this helps you out,
CP




CP