The function ADDDATES is used for local processing but is not used as built in function or one of its parameters is not supported

Hi

If you encounter this error.First take a fresh report and check if the function is supported by cognos .That is a blank report put this function in a new query and check.99% it will be supported by cognos and you will get no errors .

So why this error in your report when you try to use this function.The reason is cognos is trying to use this query as local processing and you are using a database function and it cannot replace it with similar local function .Like in case of cast it will easily replace with a local cast function.

So you can try to remove any other local function that are being used in the report so that cognos can make most use of database functions .There is not gurantee that this function will still work after you remove all the local function and replace with cognos function.

Consider below case

If you are having this query in which you are using ADDDATE function (Mysql) and this is used as a reference query then in main query you might be using some cognos local function which are not possible to replace with cognos function like extract(month,'2011-01-01') .

So its difficult to remove this local processing error.Try to use different functions in most cases.it will solve your issue.