Whether you’re considering moving to IBM Cognos Analytics on the Cloud, wanting to use JDBC drivers instead of a native database client, or just wanting greater visibility into performance-related characteristics of queries, adopting Dynamic Query Mode is a great idea.
IBM Cognos and Motio Best Practices Blog
Tags: Cognos Analytics
Imagine your organization has decided to update their brand, and you’re tasked with updating the fonts on ALL company-wide reports that aren’t Arial or Helvetica with Arial. But how would you proceed to accomplish this herculean task? The average Cognos customer has between 10,00 and 15,000 reports in their production environment. So you would have to dive into tens of thousands of reports and manually edit each and every one! MotioPI Pro provides a more efficient method for mass updating all your Cognos BI content. Here is a look into how to update your fonts.
In this follow up to my first post about filters. I am going to briefly talk about number filters in MotioPI Professional. Without further ado, let’s dive into number property filters in MotioPI!
Number Property Filters
Number Property filters in MotioPI are just what they sound like, filters that act on any numerical property of your content. Examples include, but are not limited to: run duration of a report in seconds, the total number of recipients set on a schedule and the size of an output. I will talk briefly about how to set up a Number Property filter and then show them in action for the three examples I listed above.
How to Setup a Gateway for Cognos 11
A question that we very often get asked is this: “Does the Optional Gateway ever become a requirement?"
And the answer is, “Yes!"
One of the most common scenarios where having an Optional Gateway setup becomes mandatory is having single sign-on (SSO) setup. In this blog post I will cover how to setup an Optional Gateway in Cognos Analytics versions 11.0.2 and 11.0.3. Those who have followed IBM’s official document on setting up the Optional Gateway and are having connectivity issues might find this guide useful. IBM seems to have left out a couple of critical steps for setting up the Cognos ISAPI which I will cover towards the end. Let’s start with a background on the architecture.
**Please note, if you are on Cognos version 11.04 and up, the IIS configuration guideline can be found here. And to make this easier, IBM has a small tool you can download here to automate the process.
The launch of IBM Cognos Analytics marked the release of many new features along with phasing out many mainstays of previous Cognos versions. One of these new features is a type of report, called a “fully interactive” report. Fully interactive reports have additional capabilities when compared to reports that are not fully interactive reports (sometimes called “limited interactivity”).
So what is a fully interactive report? Fully interactive reports are a new way to author and view reports in Cognos Analytics. Fully interactive reports enable live analysis of the report. This live analysis comes in the form of toolbars that enable the user to filter and group information or even generate charts. All this without re-running your report!Image Source:IBM Analytics
It seems like there is a different tech conference every month these days, so sifting through the noise and determining which one is truly beneficial for you and your personal career growth (along with which events will benefit your organization) is a task not to be taken lightly.