Cognos 11.1.5 (& newer) allows developers to incorporate custom schematics via scaled vector graphics, which are based on xml. This means that you can modify the xml of the graphic to create reference objects that you can use in order to align your data with parts of the graphic. Let’s step through some of the work that has to be done to make custom schematics work.
Read MoreOftentimes Cognos report output is needed to be consumed by many users in your organization. You could have them log into the portal and access the output directly but maybe you don’t have the time or expertise to be setting up users to access Cognos directly and then maintain all of those users. You could have the output emailed to them but you don’t want to clog up your mail server with hundreds of attachments. A good option could be to save the report outputs to your internal network or the cloud and have your users access them from there.
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 More…As I stood there, rubbing my bruised noggin and craving Dutch apple pie, I reflected on the changes currently underway in the world of BI. The technology oracles have been saying it for some time now, but never had it been more apparent to me than at IBM Data & AI Forum last October that social forces, business practices, and new technologies are changing the way we think about enterprise data.
Read MorePlanning a migration, upgrade or new implementation of Cognos Analytics? One common question is Cognos server sizing--in other words, how many servers will you need and how "large" should they be (CPU, RAM, etc.)? While this is a somewhat complex question, we provide you a chart with a high-level estimate to use in the early stages of your planning.
Read MoreAt PMsquare, we believe in the power of effective data visualization. In this article, we look at how data visualization has evolved to effectively communicate important ideas in life-and-death situations such as the COVID-19 pandemic. Specifically, we examine the viral “flatten the curve” visual, as well as other visualizations that track the spread of the disease and the potential impact on our world.
Read MoreOur goal is for our customers to adopt our latest and greatest capability and to do that we need to make it as easy as possible. So, we are making a change to our licensing and CA Exploration functionality. It will now part of the Analytics User license.
Read MoreThe ability to add your own custom visualizations came with Cognos 11.1.4 and has only improved in the 11.1.5 release. Being able to create or adapt an existing chart created with any JavaScript library means we're no longer tied to what IBM provides. If you see a chart in another tool that you like, then I'm sure there's a way to create it in Cognos.
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 MoreAt the recent 2019 IBM Data & AI Forum in Miami, IBM Offering Managers did a great job walking through recent product enhancements and future focus. There are so many appealing, new tidbits!
Read MoreCognos now offers the ability to import custom visualizations including D3, Google Charts, and a number of other JavaScript-based visualization engines. That means that if Cognos does not have a particular chart available, it can be added, including any number of properties to customize it as needed.
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 MoreThere are times when a custom folder is needed to be added to the NavBar (left vertical bar) in Cognos Analytics. Maybe a commonly accessed folder is buried in the folder hierarchy structure and needs to be referenced more easily. The following steps will show how to add a folder to make access easier.
Read MoreLearn how to infuse modern geospatial mapping capabilities into your Cognos analytics solution in this technical blog post.
Read MoreWe are excited and proud to announce that two of our very own: Ryan Dolley and Paul Mendelson have been selected as IBM Champions for the 2019 IBM Champion Program.
Read MoreHave you ever wished you make an old Cognos visualization look good on any screen? Or wished you could have a chart take up 100% of the space it has, dynamically resizing as the user resizes their window? Well here’s a simple to use custom control that can do exactly that!
This technical blog shares tips and recommendations for getting the most from IBM Cognos Analytics. Token Prompts allow authors to create extremely efficient code that would otherwise be difficult or impossible to make.
Read More
