IBM COGNOS ANALYSIS FOR MICROSOFT EXCEL UPDATE
IBM COGNOS ANALYSIS FOR MICROSOFT EXCEL FULL

Smart title вЂ“ Data is used to display the title.

New title options to allow further customisation to the visualisations.

For example, you can set the minimum and maximum value of the value axis with the Value axis minimum / maximum value option.

New axis options allow you to change the value axis tick interval in some visualisations.

What about axis and title options? There are two new options in this release. With this release, you can now use Logarithmic scales when the data you are displaying is much less or much more than the rest of the data of when or when the percentage differences between values are important. The padding and angle were changed to improve the legibility.ДЄnother issue that I have found with visualisations in general were their scaling capabilities. As of this version, the categorical axis labels were improved. In the past or even recent releases, legibility on visualisations has always been an area of improvement. Let us focus on the features that I thought was more interesting than others in this release.Дashboards вЂ“ Making Visualisations easier to use

IBM COGNOS ANALYSIS FOR MICROSOFT EXCEL FULL

The full release notes can be found here.

Ability to attach reporting content to emails to improve collaboration and sharing capabilities.ДЄlso, it is worth mentioning that IBM continues to standardise their platforms with implementing additional Carbon Design practices, such as new icons and updates to fonts and colours.

When creating data sets, you can now have access to the query explorer/editor (including reusing an existing report and its queries in the data set).

Disabling the On-Demand toolbar when you want to hide options from users.

Additional customisations of Visualisations (axis, labels, title, baseline options, Legends, and Logarithmic scales) to allow greater flexibility.

Some of the key changes that caught my attention this time round included: The table should now reflect the most up to date version of your report object.In this latest release, Cognos Analytics 11.1.7 has provided a good mix of bug fixes, enhancements, and new features. If you would like to keep your current format, then select Refresh the Data Only and click Yes. You can choose to refresh the data only, or the data as well as the formatting.

The IBM Framework for Microsoft Office window opens.

IBM COGNOS ANALYSIS FOR MICROSOFT EXCEL UPDATE

If your report runs on a regular basis and you would like to update the information within the table to reflect the current data, click Refresh. (Be aware that large amounts of data may take some time to load.) You can now format the table as desired. Once youвЂ™ve checked the desired options, click Finish. When youвЂ™ve selected the desired report elements, click Next.ДЇor my Order Method list, IвЂ™ve chosen to Import as an Excel List and Automatically Resize Columns for columns with long header names. The report elements listed will appear with the names given in the original report, so it is best to be descriptive when making the report in Cognos so that you know what information you are selecting. If you are inserting multiple objects, itвЂ™s best to add them separately. This is where you choose the objects in your report that you would like to insert. If you are okay with the default options, click Next. Click on the report so that it is highlighted, then click вЂImport ContentвЂ™ at the bottom of the IBM pane. Navigate to the location of the contents you would like to insert into the workbook. The My Folders and Team Content tabs should now appear in the right IBM navigation pane. YouвЂ™ll be prompted to enter your credentials. To get started, click the вЂњIBMвЂќ tab.Д¬lick the вЂњIBM Cognos for Microsoft OfficeвЂќ icon that appears.ДЄ pane will open on the right side of your screen.Д¬lick the вЂњ+вЂќ button next to the server you added after installation. An IBM tab will appear on the ribbon of your Microsoft products. After youвЂ™ve entered in the information, close and reopen Excel (or whichever Microsoft product you are in). Once installed, youвЂ™ll be asked to enter information regarding the environment to which you will connect. Here, weвЂ™ll go through the necessary steps to transferring items from a report to Excel after installing the product. IBM Cognos is a helpful product for someone who often gives presentations containing data that changes but the other content that remains constant, such as a monthly sales breakdown PowerPoint presentation. IBM Cognos for Microsoft Office is an easy way to get information from an IBM Cognos report to a Microsoft product, such as Excel, Word, or PowerPoint.

Ibm cognos analysis for microsoft excel