Tag Archives: IBM Cognos Express

How to Import the New Visualisation Charts into IBM Cognos BI

The new visualisation engine from IBM (RAVE) looks amazing and within this article we will show you how to access the charts and use them within report studio. Note that they can be used in traditional reporting and active reports. First step is to go to Analytics Zone. This is an IBM site where you can download all the new visualisation charts, plus Cognos Insight, demos and much more.

This entry was posted in Cognos BI, Cognos Express and tagged Active Report, Bubble Chart, IBM Cognos BI, IBM Cognos Express, RAVE, RAVE Charts, Report Studio, Tag Cloud, Visualisation Chart, Waterfall Chart. Bookmark the permalink. | Tagged Active Report, Bubble Chart, IBM Cognos BI, IBM Cognos Express, RAVE, RAVE Charts, Report Studio, Tag Cloud, Visualisation Chart, Waterfall Chart | Leave a comment

IBM Cognos Express 10.2.1 What's new

IBM Cognos Express 10.2.1 is out. Here is a list of what is new: 1. The first notable change is that Cognos Express is on the same version with Cognos Enterprise. This means that integrated under the hood you will find: Cognos BI version 10.2.1.1, TM1 version 10.2 and Cognos insight 10.2.1. This also means all the bug fixes and improvements and new features introduced in the enterprise platforms are … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, TM1 10.2 and tagged IBM Cognos, IBM Cognos Express, IBM Cognos Express 10.2.1, IBM Cognos TM1. Bookmark the permalink. | Tagged IBM Cognos, IBM Cognos Express, IBM Cognos Express 10.2.1, IBM Cognos TM1 | 1 Comment

Generating a Time Dimension in Performance Modeller

Almost all TM1/Cognos Express applications will require a time dimension, and creating a time dimension has never been easier, with Time Dimension Tool provided in performance modeller. Here are a few simple steps:

This entry was posted in Cognos Express, IBM Cognos TM1, Performance Modeler, TM1 10.1, Training Material and tagged Dimension, Dimension Editor, Hierarchies, IBM Cognos Express, IBM Cognos TM1, Performance Modeler. Bookmark the permalink. | Tagged Dimension, Dimension Editor, Hierarchies, IBM Cognos Express, IBM Cognos TM1, Performance Modeler | 1 Comment

Linking Cubes with Performance Modeler

Performance modeller makes moving/linking data between cubes (and within cube) with ease, and it also makes it easier to track and update as each link is saved separately. For those who have experience with Cognos Enterprise Planning, this will make you feel right at home. Here is a simple example on how to create a link: Start up performance modeller, log onto IBM TM1/CX Planner Applications (http://<server host>:9300/pmpsvc) and click … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, Performance Modeler, TM1 10.1, Training Material and tagged D-Link, IBM Cognos Express, IBM Cognos TM1, Performance Modeler. Bookmark the permalink. | Tagged D-Link, IBM Cognos Express, IBM Cognos TM1, Performance Modeler | Leave a comment

Adding a dimension to an existing cube

Business requirements for reporting and planning are likely to change over time, and in some cases, changes can happen quite regularly and rapidly.  So, the cube structures that was implemented initially will likely need changing, such as adding a new dimension to existing cubes for enhanced analysis and/or planning. In the past, adding a dimension to an existing cube directly would not be possible.  Unless creating a new cube with … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, Performance Modeler, Training Material and tagged Adding Dimensions to an existing cube, IBM Cognos Express, IBM Cognos TM1, Modelling, Performance Modeler. Bookmark the permalink. | Tagged Adding Dimensions to an existing cube, IBM Cognos Express, IBM Cognos TM1, Modelling, Performance Modeler | Leave a comment

Control Cubes – Part 1

While TM1 is a great tool, it is not the easiest to move from development to test or production environment. This process usually involves a tedious manual work in which the developer are required to identify every files that make up a complete dimension or cube to be migrated and to moved only these files. Typically, for dimensions, you should move your “.dim” files and the Element control cubes (which … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, Training Material and tagged Change Control, Control Cubes, Files, IBM Cognos Express, IBM Cognos TM1, Xcelerator. Bookmark the permalink. | Tagged Change Control, Control Cubes, Files, IBM Cognos Express, IBM Cognos TM1, Xcelerator | Leave a comment

CX/TM1 Monitoring on the App Store – Spark Mobile

Spark Mobile is now on the iTunes App Store. Thanks to all the beta testers. You can access and download the free iPhone / iPad App here. This brings the insights the Spark Cloud has to offer, direct to your mobile device! Notifications about significant events can now be pushed directly to your mobile device and at a touch you can now see Server Configuration, Logs and TM1Top Activity. We hope you … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, InfoCube Spark, TM1 10.1 and tagged Cloud, Congos TM1, IBM Cognos Express, IBM Cognos TM1, InfoCube Spark, Monitor. Bookmark the permalink. | Tagged Cloud, Congos TM1, IBM Cognos Express, IBM Cognos TM1, InfoCube Spark, Monitor | 2 Comments

Neglected Functionality – Custom Rollups & Subset Consolidations

In this blog segment, we’ll look at value add features of the IBM Business Analytics software which are often overlooked and underused. In this article I’m going to explain Custom Rollups and Subset Consolidations within IBM Cognos TM1. Custom rollups are used to create a temporary user-defined consolidation element. It is a very useful, but somewhat underused functionality. With custom rollups, you won’t be able to save the subset but … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training. Bookmark the permalink. | Tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training | 3 Comments

Testing Turbo Integrator Code

Calculated Variable Formula Window

In the last post we talked about how we can output String and Numeric values in a Fixed Width Field Format. I realised just after writing the article that I used a not-well-known trick in order to perfect the snippets I posted. This is: Using Calculated Variables to Test Field Calculations. I’m going to use the example of the numeric field from the last post to present how to better … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, Training Material and tagged IBM Cognos Express, IBM Cognos TM1, Scripting, Turbo Integrator. Bookmark the permalink. | Tagged IBM Cognos Express, IBM Cognos TM1, Scripting, Turbo Integrator | Leave a comment

TM1 at month-end

IBM Cognos TM1 is … what it has been developed to do within your environment. Unfortunately that means most companies aren’t getting the most out of their investment as it has been sold to them as a single point solution, solving a single point problem – So I thought that over the next for months I would post a couple of applications of TM1 in areas where its not always … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged CoGS, ERP, Gross Margin, Gross Revenue, IBM Cognos Express, IBM Cognos TM1, Journal, Monthend, PeopleSoft, Pronto, SAP. Bookmark the permalink. | Tagged CoGS, ERP, Gross Margin, Gross Revenue, IBM Cognos Express, IBM Cognos TM1, Journal, Monthend, PeopleSoft, Pronto, SAP | 1 Comment