RFE Roundup – January 2019

As part of my monthly Request For Enhancement Roundup list, I present January 2019. This is the third month, please look at December’s list for more.

1. Cascade Prompts on filters on Dashboards like reports
Uncommitted Candidate with 24 votes.

A straightforward mechanism to creating cascading prompts would improve the usability of dashboards substantially. I feel like the prompting side needs an overhaul.

2. Share pins : to be able to create a pin library for certain target groups
Uncommitted Candidate with 9 votes.

My biggest concern with adhoc reports has always been the same, most users simply want to be given the data they need. This RFE would make a nice stopgap, it would allow a user to create a generic library of pins for the end users, thus giving the end users the data they need in an adhoc environment, without them having to work hard for it.

3. List and Crosstab Visualization Lagging Behind Power BI and Tableau
Submitted with 19 votes

This really speaks for itself. There are a lot of things Cognos struggles with in terms of lists and crosstabs. Embedding a microchart is possible, but it’s clunky and slow. Something built-in would be wonderful. It is possible to make a widget that pulls the data in and builds a modern datatable on the fly, but that wouldn’t work when exporting to PDF.

4. Adding images to reports and dashboards
Submitted with 10 votes

A simple uploader for images! Why can’t we do this? And while we’re at it, let’s do the same thing for JavaScript controls.

5. Make map visualization viewable in PDF format
Submitted with 11 votes

PDF support is pretty limited, but having a report ready visualization that doesn’t export cleanly is a big problem.

6. Allow user to add extra properties in vizualisation (Dashboard)
Submitted with 10 votes

I’ve been struggling a lot of with the dashboard visualizations. A colleague said something along the lines of “Dashboards are great if you’re willing to give up control”. I want to make my bed and eat it too!

An update about Think 2019. I will not be attending this year unfortunately, but my company is planning a major presence at Analytics University. The trend at Think has been to reduce focus on the business analytics sides of things drastically, so it’s just not as important to us as it once was.

Panic! Framework Manager crashed and I lost all my work!

Has this ever happened to you?
BmtActionsHelper on delete

It’s happened to me several times. There was also that one time I worked on a model for hours, and left it for the night. Can you guess which operating system decided to update and restart overnight without warning? It was like a punch to the gut when I realized I lost all that work.

Fortunately, there’s a really easy way to retrieve all that work.

First, don’t panic. In the model folder there are two vitally important files.
framework folder contents

The file session-log.xml is a record of every action you’ve taken while framework is open. Every object you move, every expression you write, every property you change, session-log is watching.

The next time you open Framework Manager, session-log.xml will be renamed session-log-backup.xml, overwriting the old one, and a new blank session-log.xml will be created. Copy that file! If it disappears because FM screws up renaming it, or if you have a brain fart and open the model twice, you’re stuck.

Now that we have a backup of all the work we’ve done, and forgot to save, we can start the reconstruction. Open the Project menu and select “Run Script”
run script

When you press the run button, Framework will perform every action in the list. It pauses on error, allowing you to check what’s going on before proceeding.
run script had an error

Once the script has run it’s course, you can accept the changes, or revert back to the way it was.
run script worked

And there we go. Hours of worked gone and back again.

One last note, it may be worth enabling the auto save from the Project->Options menu item. It makes the entire premise of this article superfluous.

Dataset Hackery on 11.1, and some wonderful news!

Hacking Datasets in 11.1 – and some wonderful news!

The previous article I wrote on the subject doesn’t work on 11.1. It looks like IBM is wisening up to my tricks. So here’s the new way to do it.

This is actually significantly easier than the way I posted before. To start, create a list report as normal. The list should be standard: no groups, no footers or headers, no subtotals at all. Save and close the report.

Next, reopen the report. This gives us the correct URL parameters we need:
dataset hackery
https://SERVER/ibmcognos/bi/?perspective=authoring&id=i62549E69468542B288D1DFA3859A6BF1&isViewer=false&isNewFromModule=false&isNewFromPackage=false&isNewDataSetFromModule=false&isNewDataSetFromPackage=false&isTemplate=false&isDataset=false&UIProfile=Titan&cmProperties%5Bid%5D=i62549E69468542B288D1DFA3859A6BF1&rsFinalRunOptions%5Bformat%5D=HTML&rsFinalRunOptions%5Ba11y%5D=false&rsFinalRunOptions%5Bbidi%5D=false&rsFinalRunOptions%5BrunInAdvancedViewer%5D=true&rsFinalRunOptions%5BDownload%5D=false&rsFinalRunOptions%5Bprompt%5D=true&rsFinalRunOptions%5BisApplication%5D=false

Change that to isDataset=true and press enter. The page will reload with the report in the dataset skin of report studio. Save it as a new dataset – this new object will be a regular dataset, you can refresh it from the portal screen as normal.

Now for the wonderful news. IBM has for some reason decided to grant me IBM Champion status! Ignoring the immediate instinct to question their sanity, I want to assure everyone that this accolade won’t change anything about my blog. I certainly won’t let this go to my head, and my ego shall remain carefully grounded. In other, completely unrelated news, I will be selling opportunities for selfies with me in Think 2019!