Cognos 8 4 upgrade
Download
1 / 27

Cognos 8.4 Upgrade - PowerPoint PPT Presentation


  • 250 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Cognos 8.4 Upgrade' - nat


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Cognos 8 4 upgrade l.jpg

Cognos 8.4 Upgrade

Business Intelligence


Why cognos 8 4 l.jpg
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

  • Internet Explorer 7 is now supported for all products and studios

  • Better Administration and Security


Microcharts and excel 2007 l.jpg
Microcharts and Excel 2007

Microcharts added to crosstab and list reports

Excel 2007 now supported,

smaller files and

ECMA supported


Packages l.jpg
Packages

Packages can now be moved into folders

Capabilities can now be defined at the package level


Express authoring l.jpg
Express Authoring

A simplified Report Studio view that uses dimensionally modeled packages only. Designed for Financial Analysts.


Query studio filter column l.jpg
Query Studio Filter Column

Query Studio users can now filter a column without adding it to the report.


Data lineage l.jpg
Data Lineage

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.


Cognos 8 4 behavior changes l.jpg
Cognos 8.4 Behavior Changes

  • Search prompts will now prompt to continue to search if the result set is large.

  • Null values will now be used if selected.

  • Divided values will now show 3 digits after the decimal except for currencies which will use the same number as the numerator.

  • Divided values will use the same format as the numerator if the denominator is a query constant, number, or percentage. Else the format result will be a number.

  • Rounding values will result in as many decimal places as the rounding precision.

  • PDFs can now be paginated horizontally as well as vertically.

  • Using custom formatting and leaving the replace null value box empty results in nulls now being shown instead of 0 values for nulls. Previous versions appeared to be ignoring this format and now it is being used correctly in 8.4.



Cognos 8 4 studio launch l.jpg
Cognos 8.4 Studio Launch

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.


Excel header l.jpg
Excel Header

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.


Currency decimal set as comma l.jpg
Currency Decimal set as Comma

The default for Currency Decimal Separator is , when not defined. Need to change the value to period where it is used.


Nulls in prompts l.jpg
Nulls in Prompts

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.


Singleton usage l.jpg
Singleton Usage

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.


Singleton usage cont l.jpg
Singleton Usage cont.

Instead, use the new singleton object which is a single data item element.


Don t print class l.jpg
Don’t Print Class

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.


Don t print class solution l.jpg
Don’t Print Class Solution

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.


Javascript l.jpg
JavaScript

JavaScript code can break during version upgrades and is not a recommended method.

The above JavaScript is used currently to do this change.

In this example, the DESCRSHORT needs to be changed to Business Unit.


Javascript fix l.jpg
JavaScript Fix

Changed the query to force the new name to be in the result set. This name is now used in the drop down list and no need for JavaScript.


Rigorous datatype checking l.jpg
Rigorous Datatype Checking

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 = ‘’


Rigorous datatype fix l.jpg
Rigorous Datatype Fix

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.



Drill through page 8 4 l.jpg
Drill Through Page 8.4

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.



Framework manager l.jpg
Framework Manager

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.


Framework object dependencies l.jpg
Framework Object Dependencies

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.


Further resources l.jpg
Further Resources

  • Business Intelligence Solutions Website

    • http://www.it.northwestern.edu/about/departments/bi/index.html

  • NUBI Listserv email

  • IBM Cognos Support Site

    • http://www-01.ibm.com/software/data/cognos/products/cognos-8-business-intelligence/support/

  • IT Toolbox Cognos Community

    • http://businessintelligence.ittoolbox.com/topics/pbs/cognos/

  • Reference Manuals

    • Report Studio Professional Authoring User Guide: http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/documentation/docs/en/8.4.0/ug_cr_rptstd.pdf

    • Framework Manager User Guide: http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/documentation/docs/en/8.4.0/ug_fm.pdf

    • Transformer User Guide : http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/documentation/docs/en/8.4.0/ug_cogtr.pdf

    • Report Studio Express Authoring User Guide: http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/documentation/docs/en/8.4.0/ug_rptstd_fin.pdf


ad