Optimization of joined queries in Cognos Analytics is a useful way to improve performance by reducing the data returned by the database. Joins with one-to-many or many-to-one cardinality use key values from the table on the one side of the join to filter rows in the table on the many sides of the join. Like a developer who uses IN, BETWEEN, or a subquery in their custom SQL query, so can the Cognos query engine.
Read MoreWhen Cognos 11.1 was released, it introduced enough new Data Modules features that a realistic case could be made to consider moving from Framework Manager packages to data modules for metadata modeling. One of the essential pieces that were missing from earlier releases was the ability to deal with multi-grain issues (as addressed by determinants in Framework Manager). To address this issue, Cognos has recently added something called column dependencies.
Read MoreOne of my favorite features of Data Modules since version 11.1 is the ability to easily do relative date analysis. What used to take a bunch of coding in Framework Manager or several queries within a report, you can now do by pointing your measure to a calendar in a Data Module and automatically have several relative time data items and filters available.
Read More