This documentation describes the current functionality of the product. References to items that are not currently available may be included. No implication of any. IBM Cognos Analysis Studio · Creating a Basic Analysis · Working With Items in the Tips for IBM Cognos Series 7 PowerPlay Users · Limitations When. IBM Cognos 8 BI Analysis for Microsoft Excel Installation Guide, link to pdf version IBM Cognos 8 Business Intelligence PowerPlay Client.
|Published (Last):||17 December 2009|
|PDF File Size:||19.18 Mb|
|ePub File Size:||10.14 Mb|
|Price:||Free* [*Free Regsitration Required]|
A member can appear sorted in the metadata tree and on the report without slowing performance. The Palette property provides palettes that match those from studioo versions of Excel.
There is now support for multiple hierarchies of a single anaysis for dimensionally-modeled relational data sources. This allows you to restrict when the drill path is available to users. You can apply conditional styles to crosstab cells based on an adjacent value in the crosstab. In bubble charts, a new Bubble Size property allows you to control the size of bubbles in relation to the actual values of the Z-axis.
You can now link groups of data items from different queries in a report so that when you drill up or down on one query, data items in the other query also drill up or down.
Viewing lineage information ensures that you add the correct data items to a report.
In addition, the sorting of data by member is enhanced. Synchronized Drilling Up and Drilling Down with Multiple Queries You can now link groups of data items from different queries in a report so that when you drill up or down on one query, data items in the other query also drill usdr or down.
Lineage Information for Data You can now view lineage information of a data item to see what the item represents before you add it to a report. Crosstab Measures Can be Formatted Based on Other Crosstab Measures You can apply conditional styles to crosstab cells based on an adjacent value in the crosstab.
For more information about query reuse, see the Framework Manager User Guide. You can now perform dynamic filtering of data in Report Studio reports. For more information about queries in the relational reporting style, see Working with Relational Queries.
New Features in Version | Report Studio User Guide
For example, you can map the member caption instead gukde the business key to the target. For more dtudio, see Create an Intersection Tuple. Links to directly-related topics are included. In Report Studio, you can now define a drill-through definition that allows a report to be shown on the Go To page only when a specific measure, dimension, hierarchy, alternate hierarchy, level, or query item exists in the source report.
For example, you can conditionally color the bubbles in a bubble chart based on any combination of the measures, and you can conditionally color an entire row of the crosstab based on any measure in the columns. For 88.4, you can view the lineage information of a model calculation to see how it was created.
For more information, see Insert a Analyais. Microcharts are miniature line and column charts. You can disable query reuse for each individual query in Report Studio, or you can disable query reuse for the entire package in Framework Manager.
This means that the hierarchical relationship of a level is considered when member sorting is applied. Extended Suppression Capabilities You can now suppress rows, columns, or rows and columns based on zero, null, divide by zero, and overflow values in reports created with relational, dimensionally-modeled relational, and OLAP data sources. Other types of drill-through targets are now supported.
Analysis Studio User Guide 10.2.1
New Chart Types The following new chart types are now available: New Features in Version 8. You can now insert calculated members and measures in an intersection tuple. Individual segment height is a percentage of the respective column total value. For more information about color palettes, see Customizing the Color Palette of wnalysis Chart. For more information, see Using Drill-through Access. For more information, see Add Background Effects.
By default, the business key is used. Win-loss charts guid microcharts where the value of each bar is either one or minus one.