Do you have a brand-new install of Cognos? What is the first thing you do after your install is done and you have configured Cognos? Start creating reports? Start building dashboards? No! You need to make sure you have security properly configured. Security is one of those things that often gets pushed off until the end of a project but it should be the first thing we do.
Read MoreOptimization 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 MoreThe Data and AI Forum was packed full of keynotes, hands-on labs, product roadmaps, and much more. Some of our consultants attended the conference have collaborated with each other to share the topics that caught their attention with you. Enjoy.
Read More
