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):||11 January 2009|
|PDF File Size:||3.14 Mb|
|ePub File Size:||13.46 Mb|
|Price:||Free* [*Free Regsitration Required]|
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 to the target item.
For more information about query reuse, see the Framework Manager User Guide. When you apply a filter to a source report and then drill through to a target report, the target report is automatically filtered if the item you selected is in a query in the target anaysis.
In addition, the sorting of data by member is enhanced. New Chart Types The following new chart types are cgnos available: For more information, see Create an Intersection Tuple. Viewing lineage information ensures that you add the correct data items to a report.
For more information, see Using Drill-through Access. You can now insert calculated members and anapysis in an intersection tuple. 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.
Microcharts are miniature line and column charts. For more information, see Insert a Hierarchy. For example, you can now include borders with rounded corners, transparent background fills and images, studi shadows, and background gradients. For more information, see Add Background Effects. By default, the business key is used. 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.
Analysis Studio User Guide 10.2.1
This chart type is often used to represent a win analyss loss. Other types of drill-through targets are now supported. Line charts can now also include opening, closing, minimum, and maximum value markers. Enhanced Report Graphics A greater variety of colorful graphics and backgrounds are now available for dashboards and reports.
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. For more information about queries in the relational reporting style, see Working with Relational Queries. You can now link groups of data items from different queries in a report so tsudio when you drill up or down on anlysis query, data items in the other query also drill up or down.
You can now view lineage information of a data item to see what the item represents before you add it to a report. Line charts now include an option for creating studoi line charts. A greater variety of colorful graphics and backgrounds are now available for dashboards and reports.
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.
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 up or down.
Listed below are new features since the last release. 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.
Win-loss charts are microcharts where the value of each bar is either one or minus one. For more information, see Create a Drill-up and Drill-down Report.
New Features in Version | Report Studio User Guide
Also, members of a level are sorted in the context of their ancestor levels. For more information about queries in the dimensional reporting style, see Working with Dimensional Queries. Individual segment height is a percentage of analyysis respective column total value. New Features in Version 8.
New Query Properties The following two new properties allow you to customize queries: 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 example, you can map the member caption instead of the business key to the target.
Marimekko charts are percent stacked charts in which the width of a column is proportional to the total of the column’s values. A data item’s lineage information traces the item’s metadata back through analgsis package and the package’s data sources. Intersections Tuples Can Include Calculated Members and Measures You can now insert calculated members and measures in an intersection tuple.
New Features in Version | Analysis Studio User Guide
You can apply conditional styles to crosstab cells based on an adjacent value in the crosstab. A member can appear sorted in the metadata tree and on the report without slowing performance. There is now support for multiple hierarchies of a single dimension for dimensionally-modeled relational data sources.
This means that the hierarchical relationship of a level is considered when member sorting is applied. 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 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 example, you can view the lineage information of a model calculation to see how it was created.