cognos BI

5 Jan 2017

3 Reasons to Start Your Upgrade from Cognos BI to Cognos Analytics Right Now

By | January 5th, 2017|Categories: Advisory, Business Intelligence, IBM, IT|Tags: , , , , , , , , |

As we’ve mentioned before, as of April 2018 there will be limited extended support for Cognos 10.x. Sure, that sounds like a long time from now, but if there’s anything I’ve learned from my time in enterprise IT, it’s that making a change is like turning a battleship. You need to start actively planning for [...]

11 Jan 2016

Our Top 5 Articles of 2015: Data, Analytics, Advisory

By | January 11th, 2016|Categories: Business Intelligence, Data Science, Information Management|Tags: , , , , , , , , |

Even though we're already blazing full speed ahead into 2016, it's always important to take a minute to look back at the past year and recognize the high points that made it special. In addition to being named a Boston Business Journal Pacesetter for the second time, making the Inc. 5000 list of fastest-growing companies [...]

5 Aug 2015

Integrating Information with a Cloud-Based Data Warehouse: Public Data Powered Part 2

By | August 5th, 2015|Categories: Advisory, Information Management, Strategy & Innovation|Tags: , , , , |

This article is the second in our Ironside Public Data Powered series, which outlines how we can leverage public data to help us gain insights that drive stronger, faster business decisions. It will take a look at adding public data into a cloud-based data warehouse. This time, we’ll return the scenario outlined in our inaugural article, where we take on the role of a product manager working at a fictional wholesale sporting goods company. Previously, we leveraged a combination of internal data and publically available weather data to gain insights using IBM Watson Analytics. In this article, we’ll explore what it takes to stand up a cloud-based data warehouse, perform transformations against that cloud-based data, and leverage our in-house implementation of Cognos BI 10.2.2 to analyze it. We’ll be using IBM’s newly introduced dashDB offering, part of the larger BlueMix Platform as a Service (PaaS) digital innovation platform. […]

17 Apr 2015

Ironside Webinar Series: What to Expect for Your Cognos Environment

By | April 17th, 2015|Categories: Business Intelligence, Managed Services, Webinars|Tags: , , , |

On April 14th, Ironside hosted a What to Expect for Your Cognos Environment webinar, where Ironside's Technical Services Manager presented on how your Cognos environment should behave along with tips and tricks for making any necessary improvements. Topics covered  included: What to Expect From Your Analytics Environment Common Issues and Suggestions to Resolve Ironside Managed [...]

27 Feb 2015

Ironside Webinar Series: Select the Right Cognos 10.2.2 Tool for the Job

By | February 27th, 2015|Categories: Business Intelligence, Proven Practices, Webinars|Tags: , , , |

On February 24th,  Ironside hosted Select the Right Cognos 10.2.2 Tool for the Job: Real-Life Selection Process Leveraging Your use Case webinar, where Ironside's Senior Consulant De Hsieh,  presented an in-depth look into which of the many Cognos tools available are right for which jobs. During this webinar we reviewed some of the issues your organization are [...]

5 Jan 2015

Building Best Practice TM1 Cubes for Cognos BI Reporting

By | January 5th, 2015|Categories: Advisory, Business Intelligence, Financial Performance Management|Tags: , , |

TM1 cubes have now become the OLAP solution of choice for many Cognos BI environments. Because of this emerging trend, there are some techniques and tips that TM1 developers should be familiar with when building a cube for Cognos BI reports. Initially, the Cognos BI platform was built around Transformer OLAP cubes. Transformer cubes are [...]

1 Dec 2014

Ironside Tech Tip: Using the Page Structure View to Build/Edit Advanced Reports

By | December 1st, 2014|Categories: Business Intelligence, Report Studio Cookbook, Tech Tip|Tags: , , , , , , |

Difficulty: Easy Required Ingredients: Report Studio report Scenario: You have a highly formatted report in Report Studio and you need a better understanding of how the report is structured. Some of the items in the report maybe hidden and you can’t easily see how things are nested. Luckily, Page Structure view can help with that. […]

30 Jun 2014

Ironside Tech Tip: Leveraging Time and Aggregate Functions in Dimensional Reporting to Create Low Maintenance Cognos Reports

By | June 30th, 2014|Categories: Business Intelligence, Reporting, Tech Tip|Tags: , , , , , |

Over the years I have successfully used the ancestor(), parallelPeriods(), periodToDate(), aggregate(), and set() dimensional functions to develop robust and durable dimensional reporting solutions in IBM Cognos BI. I had the opportunity to go to lunch the other day with one of my clients from a few years ago and they told me that the [...]

5 May 2014

Heat Map Formatting using HTML

By | May 5th, 2014|Categories: Business Intelligence, Proven Practices, Strategy & Innovation|Tags: , , , , , , |

Even if you don't have access to the RAVE visualizations available in Cognos 10.2.1, there are still some options to produce non-standard charts and simulate things such as heat maps using older Cognos versions. With some creative HTML use, you can set up a heat map that responds to various conditions in your reports. This [...]

9 Oct 2012

Understanding Cognos Audit Reports and Tables

By | October 9th, 2012|Categories: Newsletter, Reporting|Tags: , , , , |

The IBM Cognos platform provides complete auditing capabilities that enable auditing and managing system usage. By default, system messages, errors, and other product details are logged to flat files that reside in the log directory. IBM Cognos BI provides an additional option to output audit usage information to a relational database. With the usage audit data stored in a relational data source, reporting becomes possible. IBM provides a sample audit model that includes several sample reports to assist in providing immediate benefit from the audit data. In this article, we’re going to discuss specific audit tables and activities to tailor your auditing needs. […]

Load More Posts