Troubleshooting
Problem
Calculation that uses nvl([Data_Item],0) results in error with a DQM connection: XQE-PLN-0265 The function 'nvl' requires 1 argument(s) in data item 'Data Item1' of query 'Query1'.
Cause
Netezza Function set not included in Framework Manager package
Resolving The Problem
Add the Netezza Function Set to the published package.
1. Open Model in Framework Manager.
2. Select Package.
3. From the Menu, select Action > Package > Specify Package Function List
4. Select Netezza and select Add selected function sets.
5. Update published package.
[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Dashboards v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.8;11.0.7","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22011009