1 / 27

Cognos 8.4 Upgrade

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

nat
Download Presentation

Cognos 8.4 Upgrade

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Cognos 8.4 Upgrade Business Intelligence

  2. 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

  3. Microcharts and Excel 2007 Microcharts added to crosstab and list reports Excel 2007 now supported, smaller files and ECMA supported

  4. Packages Packages can now be moved into folders Capabilities can now be defined at the package level

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

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

  7. 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.

  8. 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.

  9. Cognos 8.4 Splash Screen

  10. 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.

  11. 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.

  12. 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.

  13. 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.

  14. 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.

  15. Singleton Usage cont. Instead, use the new singleton object which is a single data item element.

  16. 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.

  17. 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.

  18. 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.

  19. 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.

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

  21. 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.

  22. Drill Through Page 8.2

  23. 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.

  24. Upgrade Plan

  25. 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.

  26. 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.

  27. Further Resources • Business Intelligence Solutions Website • http://www.it.northwestern.edu/about/departments/bi/index.html • NUBI Listserv email • listserv@listserv.it.northwestern.edu • 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

More Related