Migrating Cognos is a highly involved process, especially when you’re moving across multiple versions. When one of our clients needed this kind of migration completed, our experts turned to Cognos SDK to streamline the process and adjust the system to meet the client’s needs exactly. Read more
To a TM1 developer, alternate hierarchies are sometimes synonymous with ragged hierarchies. When designing cubes for Cognos BI, it’s important to remember that they are structurally different concepts. How you model them in TM1 will affect your Cognos BI reports. Continuing where we left off last month, we will discuss some best practices for handling these hierarchy structures in a Cognos BI context.
Note: As of TM1 10.2, alternate hierarchies cannot be defined separately in the }HierarchyProperties cube. Read more
In 2014, cloud data warehousing services led the information management category in increased adoption rate, jumping from 24% to 34% according to surveys by Information Week . For organizations challenged by data urgency needs that can be difficult to meet with traditional data warehouse infrastructures, cloud services offer an alternative that can provide value at the pace of business, often supplementing existing, on-premise data warehouses. With new technologies and advancements in the cloud data warehousing space, 2015 should prove to be an exciting year for those looking to build out or implement new cloud based DW programs. Whether you are in the midst of a cloud DW initiative, looking to start one soon, or just getting to know the technology – the five trends that we will discuss below are items you will want to keep in mind for the coming year. Read more
In Cognos 10.2.1 and earlier versions, the phrase that most accurately described a multi-page report was “wrestling match.” Long list reports would flow on for page after page until somewhere along the way you ran into that chart you knew you added but were starting to forget about. Defining page breaks helped some, but following the flow of a multi-page report was often a tiresome process that left your mouse hand cramped from clicking Page Down. With the release of Cognos 10.2.2, IBM changed all that with tabbed reports. Read more
You might have missed it if you weren’t closely following the situation or already using the platform, but around the middle of last month IBM forever changed the concept of self-service analytics when they quietly moved Watson Analytics out of beta and into general availability. Watson Analytics is a new cloud-based application that enables an individual to work with their data at a level of ease and intuitiveness that we’ve not seen before. As a sibling of the IBM Watson family, it has inherited a powerful natural language processing capability and as such it enables an individual to query data not with a programming language like SQL, but in the form of a natural language dialogue. Read more
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 similar to TM1 in many aspects but there are some important structural differences that affect how users consume them in Cognos BI. This article will discuss in detail some of these differences and how to utilize some hidden features of TM1 to build a cube that will mimic the structural features available in Cognos Transformer and make your Cognos BI developer’s job easier. Read more
Synopsis:
Enable a user via a prompt to pre-select if a value will be filtered before or after aggregation.
Overview:
Normally, the report author hard codes filters placed on facts in the Properties pane as before or after aggregation. While this is adequate in most report scenarios, hard coding can be limiting if the executing end-user would like to dynamically choose which aggregation method to use on the fact value at run time. When creating typical reports, this option is not obvious or apparently possible. Read more
The report is in! See the list of topics that readers, like you, found most interesting and that made it into our top 5 of 2014.
Top Training Tip
Creating a Burst Table for a Cognos Report – Do you know how to create an external data file to use as a burst table for a Cognos report? If not, you can find step-by-step instructions in this guide. Learn how to create a Burst Table Read more
Nowadays, anyone from age two to ninety interacts with the internet in some form. Mobile devices have become an increasingly popular means of access. Technology innovations in the form of smartphones and tablets have dramatically changed the way we conduct our daily lives, both in business and personal settings. Because of this societal shift, tools like IBM Cognos Mobile, which delivers rich BI results in the office or on the go, are leading trends in IT. Research studies show that organizations that both prioritize mobile technology initiatives and implement a mobile strategy – not just for IT but across the entire company – are more likely to experience revenue growth and improve IT effectiveness . So with this in mind, what exactly is IBM Cognos Mobile, and what does it offer? Let’s take a quick look. Read more
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. Read more
Ironside helps companies translate business goals and challenges into technology solutions that enable insightful analysis, data-driven decision making and continued success. We help you structure, integrate and augment your data, while transforming your analytic environment and improving governance.