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):||14 November 2014|
|PDF File Size:||10.15 Mb|
|ePub File Size:||10.25 Mb|
|Price:||Free* [*Free Regsitration Required]|
Marimekko charts are percent stacked charts in which the width of a column is proportional to the total of the column’s values.
For more information, see Suppress Empty Cells. Other types of drill-through targets are now supported. Intersections Tuples Can Include Calculated Members and Measures You can now insert calculated members and measures in an intersection tuple.
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.
You can now view lineage information of a data item to see what the item represents before you add it to a report. When the source report is based on a dimensional package and you choose to pass parameter values, you can now choose what property of the source metadata item to map qnalysis the target item.
For more information about color palettes, see Ussr the Color Palette of a Chart. New Chart Types The following new chart types are now available: A data item’s lineage information traces the item’s metadata back through the package and the package’s data sources. Win-loss charts are microcharts where the value of each bar is either one or minus one.
You can now link groups of stuvio items guie 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. A new Line Type property for the Line object in the chart allows you to use vertical and horizontal lines to connect the data points, forming a step-like progression.
For more information about queries in the relational reporting style, see Working with Relational Queries. For more information, see Using Drill-through Access. This allows you to restrict when the drill path is available to users. A member can appear sorted in the metadata tree and on the report without slowing performance. 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.
Listed below are new features since the last release. Viewing lineage information ensures that you add the correct data items to a report.
New Features in Version | Report Studio User Guide
New Query Properties The following two new properties allow you to customize queries: 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.
For more information, see Insert a Hierarchy. 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. New Features in Version 8. This allows you to sort stjdio calculated members and measures. There is now support for multiple hierarchies of a single dimension for dimensionally-modeled relational data sources.
Links to directly-related topics are included.
Analysis Studio User Guide 10.2.1
For more information about queries in the dimensional reporting style, see Working with Dimensional Queries. 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. Individual segment height is a percentage of the respective column total value. For example, you can now include borders with rounded corners, transparent background fills and images, drop shadows, and background gradients.
A greater variety of colorful graphics and backgrounds are now available for dashboards and reports.
For example, you can map the member caption instead of the business key to the target. For more information, see Add Background Effects. You can now perform dynamic filtering of data in Report Studio reports. For more information, see Create an Intersection Tuple.