IBM
Linking a website URL to my Cognos Analytics 11.0.4+ Welcome Page
Wow, now I can add a URL link to my Cognos Analytics (CA) Welcome Page! Business Case: In an earlier QueBIT Knowledge Base article, “Setting a Default Welcome Page in Cognos Analytics 11.0.4+”, you learned how to set up a custom welcome page in CA. In this article, we are going to add a URL…
Read MoreCreating a Simple Dashboard in Cognos Analytics 11.0.0+
Let’s get started with Dashboard basics… It’s easy! Business Case: The City of Boston currently utilizes a “311 System”, which enables city residents or city workers to easily report non-emergency issues. Items such as broken streetlights or graffiti can be reported to the proper city services department via mobile phone applications, online, social media or…
Read MoreHow do I Set Planning Analytics for Excel (PAx) Options?
There are various options that apply to Planning Analytics for Excel that are recommended to be reviewed and set. These include the following: Startup Options You can choose your “startup application”. This is nice if your routinely connect to a multiple Planning Analytics environments, but prefer one as your “default”. To do this, click on the…
Read MoreHow to Publish & Share Planning Analytics for Excel (PAx) Reports
Publishing reports from PAx (Planning Analytics for Excel) is accomplished in exactly the same way as when using Perspectives/TM1Web and only TM1 Admin level users can publish reports. To share your PAx report, you click on the PAx Publish icon: This opens the Publish dialog (shown below). Here you can…
Read MoreInteractive Dashboards in Cognos Analytics 11.0.0+
Let’s add additional visualizations and create an interactive workspace. In my last knowledge base article, “Creating a Simple Dashboard in Cognos Analytics 11.0.0+”, I covered how to easily create a single visualization depicting a key performance indicator (KPI). Taking this a step further, this article will show you how to add multiple visualizations to create…
Read MorePlanning Analytics for Excel (PAx) Application and Exploration Settings
To set these options, click on the Planning Analytics for Excel menu item and then click on Options. The Options dialog box will appear (shown below). Next click on IBM Planning Analytics (in the upper left). Here is where you can set the expand option to…
Read MoreHow can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet?
Clicking the Action Button icon adds a Planning Analytics for Excel Action button to the worksheet (assuming trust is enabled). Once a PAx action button is added to your worksheet you can set its properties to recalculate the worksheet or workbook, link to another location or run a TurboIntegrator process. How do…
Read MoreDrill Through from a Dashboard! Cognos Analytics 11.0.10+
You’re kidding, I can now drill through to a report from a dashboard! One of the most popular Cognos Analytics (CA) enhancement requests across all of IBM has been the ability to drill from a Dashboard to a Report. Well, it can now be done. It is an easy task to author a drill-through that…
Read MoreWhat is the Planning Analytics for Excel (PAx) Task Pane?
The PAx task pane opens when you start IBM Planning Analytics for Microsoft Excel. You can click the Task Pane icon to show and hide the task pane. You can move and resize the pane. The task pane consists of two tabs. The first tab contains the source tree and…
Read MoreHow do I create a List in Planning Analytics for Excel (PAx)?
When you create a list in PAx (Planning Analytics for Excel), you begin with a blank list and then drag items from the Task Pane onto the list. To create a list: 1. On the IBM Planning Analytics tab, click List. This will add the list object to your active worksheet. …
Read More