Our reporting database uses date type columns in a partitioning scheme to improve query performance across tables with years of data retention.
When importing the table into a data model, cognos converts these date columns (partitioned index columns) from date to to_timestamp in the resulting report query.
Some 3rd party data warehouse tables also use an integer field for date/time behavior and partitioning.
Is there any way to prevent this behavior? As a result of this conversion, the report query does not use the oracle optimizer when executing the query, greatly reducing performance.
Thanks
------------------------------
Dax Lawless
------------------------------
#CognosAnalyticswithWatson