You do not have to import scalar functions metadata from a database before you can reference them in an expression.
Importing procedures via the driver is in our backlog, per prior comment, that would require Redshift users to be on versions >= when they fixed their issues.
Unfortunately, they like a few other cloud databases announced support for procedures and UDF, but had defects in their drivers, which we noted to them etc.
Note also that a reference to an in database function can be annotated, if necessary to identify if it should be treated as an aggregate etc.
This is covered in the following docs https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=rules-using-scalar-aggregate-functions
------------------------------
NIGEL CAMPBELL
------------------------------
Original Message:
Sent: Fri August 27, 2021 06:50 AM
From: Charles Dennis
Subject: Amazon Redshift data source connection does not show procedures, functions in FM
Thank you for your reply. Do no driver versions pick up these objects? Would the ODBC driver work? Is there no way to create FM packages based on procedures, functions in this case? Thanks again.
------------------------------
Charles Dennis
Original Message:
Sent: Thu August 26, 2021 10:52 AM
From: NIGEL CAMPBELL
Subject: Amazon Redshift data source connection does not show procedures, functions in FM
There were quality issues associated to versions of the Amazon Redshift driver and their implementation of the DatabaseMetadata interface interface methods that describe those objects. In some cases resulting in errors not just incorrect information etc. Hence, older CA releases would not return metadata for those objects even if you were to use newer Amazon drivers.
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Tue August 24, 2021 08:16 PM
From: Charles Dennis
Subject: Amazon Redshift data source connection does not show procedures, functions in FM
Cognos Analytics 11.1.7FP1
We created JDBC data source connection to Amazon Redshift database using Redshift JDBC driver redshift-jdbc42-2.0.0.7.jar.
We are creating the Framework Manager project to create the model and need to work with Redshift procedures and functions.
They do not show up in the schema objects list when running Metadata Wizard. Tables show as expected, but no procedures and functions. When connecting to the database using other tools, procedures and functions show.
Is it possible to work with Redshift procedures and functions in FM? Is there a trick to getting them to show?
Thanks for any help.
Charles
------------------------------
Charles Dennis
------------------------------
#CognosAnalyticswithWatson