Troubleshooting
Problem
Existing Package does not allow Query Studio users to Filter Date fields with the 'Range' and 'Last number of days' operations options on any of the Date Fields. Other Packages and new Framework Manager models and packages tested using the same database tables and columns doe provide the user with these options.
Diagnosing The Problem
Compared Framework Manger model properties for the affected Date fields an all properties are exactly the same. Only when viewing the model.xml is a difference seen in the SQL definition of the <modelQuery> tag for the affected Query Subjects is a difference seen.
The non working Model\Package has the date fields defined with cast(column as date) whereas the working models do not use a Cast() function.
Further investigation on the Framework managers data source entry identified a missing value in the Interface property. The non-working model is missing the OR value indicating and Oracle interface.
Resolving The Problem
Update the affected database Query Subjects in Framework manger model with current database metadata.
Steps:
1. Open the model with Framework Manager
2. Go to Data Sources. Select the affected data source
3. Expand Type section
4. Add OR to Interface property (refer to same property in working model)
5. Go to and select the affected Database Query Subject
6. From the menu select Tools > Update Object
7. Publish the updated package to Cognos
8. Test filtering on the Data Field in Query Studio to confirm the expected Filter options are now available.
2. Go to Data Sources. Select the affected data source
3. Expand Type section
4. Add OR to Interface property (refer to same property in working model)
5. Go to and select the affected Database Query Subject
6. From the menu select Tools > Update Object
7. Publish the updated package to Cognos
8. Test filtering on the Data Field in Query Studio to confirm the expected Filter options are now available.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
07 January 2019
UID
ibm10794163