Cognos 8.4 Upgrade. Business Intelligence. Why Cognos 8.4. Increased Performance on Database due to optimized SQL and more filters passed in native SQL Less chance of killing the BIBus core process Firefox 3 support for Cognos Connection, Report View, and Query Studio
Microcharts added to crosstab and list reports
Excel 2007 now supported,
smaller files and
Packages can now be moved into folders
Capabilities can now be defined at the package level
A simplified Report Studio view that uses dimensionally modeled packages only. Designed for Financial Analysts.
Query Studio users can now filter a column without adding it to the report.
Data Lineage can be displayed in Report Studio from the selectable objects, and also in a report against a data item. It shows where a data item came from and any calculation done on that item.
The studio icons are now in a launch list, instead of spread across the top as icons. This list will still only show studios the user has the capabilities to access.
In Excel 2002 worksheets, headers can now be broken across multiple rows. In the Excel 2007 format below, the behavior stays the same and headers stay on the assigned row.
The default for Currency Decimal Separator is , when not defined. Need to change the value to period where it is used.
Nulls are now an acceptable item in picklist prompts. If selected, it will return values with null. To remove this behavior add a null filter to the prompt query.
In this example there is a single data item displayed in a header, Open/Close.
To do this, the report designer had to insert a table and then a list frame with a single data item in the list.
Instead, use the new singleton object which is a single data item element.
The Don’t Print class behavior has changed. It tells the object to not print or show in PDF or Excel formats. However it still shows in HTML outputs.
There are a couple solutions to this if you don’t want the object to show in HTML. One of the options is below, change the box type of the object to None.
In this example, the DESCRSHORT needs to be changed to Business Unit.
In 8.4, datatypes are now more rigorously checked. In the above example, count is a numerical value and hence does not equal a character as represented by the = ‘’
In this case, you would replace the =‘’ with the is null statement.
Even better for this job though would be to use the coalesce function to replace Nulls with 0.
The new page shows all three drill through entries, even though the label on one of the entries is still hidden and hence was not displayed in 8.2.
The new drill through link page shows more detail and has a debug option now to display the passed source values to the target report.
When running Framework Manager 8.2 and 8.4 concurrently, be sure to install 8.4 into a separate directory, here it is installed in c84.
One of the new features in Framework Manager 8.4 is the Object dependency tool to show you any dependencies before you make a change to the model.