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 June 2014|
|PDF File Size:||20.72 Mb|
|ePub File Size:||4.87 Mb|
|Price:||Free* [*Free Regsitration Required]|
For more information, see Create a Drill-up studuo Drill-down Report. For more information, see Add Background Effects. 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, see Insert a Hierarchy. The Palette property provides palettes that match those from various versions of Excel.
Analysis Studio User Guide 10.2.1
Individual segment height is a percentage of the respective column total value. Also, members of a level are sorted in the context of their ancestor levels.
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. 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.
In previous releases, if a query contained multiple hierarchies from the same dimension, you encountered errors or no data appeared in your report. 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, see Using Drill-through Access. 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 insert calculated members and measures in an intersection tuple. There is now support for multiple hierarchies of a single dimension for dimensionally-modeled relational data sources.
For more information about queries in the dimensional reporting style, see Working with Dimensional Queries. Extended Suppression Anwlysis 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.
You can now link groups of data items from different queries in a report so studjo when you drill up or down on one query, data items in the other query also drill up or down.
New Query Properties The following two new properties allow you to customize queries: For more information about query reuse, see the Framework Manager User Guide. You can apply conditional styles to crosstab cells based on an adjacent value in the crosstab. For more information, see Create an Intersection Tuple. For more information about color palettes, see Customizing the Color Palette of a Chart.
This chart type is often used to represent a win or loss. This allows you to sort using calculated members and measures.
New Features in Version | Report Studio User Guide
Intersections Tuples Can Include Calculated Members and Measures You can now insert calculated members and measures in an intersection tuple.
Links to directly-related topics are included. A member can appear sorted in the metadata tree and on the report without slowing performance. 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.
Microcharts are miniature line and column charts. Viewing lineage information ensures that you add the correct data items to a report.
Line charts now include an option for creating step line charts. For example, you can map the member caption instead of the cogns key to the target. Other types of drill-through targets are now supported. This allows you to restrict when the drill path is available to users. New Features in Version 8.
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. By default, the business key is used. New Chart Types The following new chart types are now available: 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.
In addition, the sorting of data by member is enhanced. 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. Win-loss charts are microcharts where the value of each bar is either one or minus one. Marimekko charts are percent stacked charts in which the width of a column is proportional to the total of the column’s values.
You can now perform dynamic filtering of data in Report Studio reports.
A greater variety of colorful graphics and backgrounds are now available for dashboards and reports. For example, you can view the lineage information cognow a model calculation to see how it was created. For more information, see Suppress Empty Cells. This means that the hierarchical relationship of a level is considered when member sorting is applied.
Line charts can now also include opening, closing, minimum, and maximum value markers. Listed below are new features since the last release.