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):||24 November 2012|
|PDF File Size:||9.51 Mb|
|ePub File Size:||20.72 Mb|
|Price:||Free* [*Free Regsitration Required]|
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. For more information, see Create a Drill-up analysiw Drill-down Report. In previous releases, if a query contained multiple hierarchies from the same dimension, you encountered errors or no data appeared in your report.
In Report Studio, you studiio 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 more information about color palettes, see Customizing the Color Palette of a Coynos.
Analysis Studio User Guide
You can apply conditional styles to crosstab cells based on an adjacent value in the crosstab. Win-loss charts are microcharts where the value of each bar is either one or minus one.
For example, you can view the lineage information of a model calculation aanalysis see how it was created. A member can appear sorted in the metadata tree and on the report without slowing performance.
Also, members of sutdio level are sorted in the context of their ancestor levels. Intersections Tuples Can Include Calculated Members and Measures You can now insert calculated members and measures in an intersection tuple.
For more information, analysiss Using Drill-through Access. This chart type is often used to represent a win or loss. Listed below are new features since the last release. 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 disable query reuse for each individual query in Report Studio, or you can disable query reuse for the guise package in Framework Manager. Viewing lineage information ensures that you add the correct data items to a report.
Microcharts are miniature line and column charts. This means that the hierarchical relationship of a level is considered when member sorting is applied.
Analysis Studio User Guide 10.2.1
For example, you can map the member caption instead of the business key to the target. Studip Features in Version 8.
This allows you to restrict when the drill path is available to users. A data item’s lineage information traces the item’s metadata back through the package and the package’s data sources. For more information, see Add Background Anakysis.
There is now support for multiple hierarchies of a single dimension for dimensionally-modeled relational data sources. Individual segment height is a percentage of the respective column total value.
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, see Create an Intersection Tuple.
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. 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, see Insert a Hierarchy. Line charts can now also include opening, closing, minimum, and maximum value markers. Other types of drill-through targets are now supported.
By default, cognoa business key is used.
New Features in Version | Report Studio User Guide
You can now insert calculated members and measures in an intersection tuple. In addition, the sorting stuvio data by member is enhanced. 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.