COGNOS 8.4 ANALYSIS STUDIO USER GUIDE PDF
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):||1 October 2004|
|PDF File Size:||9.98 Mb|
|ePub File Size:||8.39 Mb|
|Price:||Free* [*Free Regsitration Required]|
Links to directly-related topics are included. You can guire 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. For more information, see Create a Drill-up and Drill-down Report. For more information about queries in the dimensional reporting style, see Working with Dimensional Queries. 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 Add Background Effects. A greater variety of colorful graphics and backgrounds are now available for dashboards and reports. Other types of drill-through targets are now supported. In Report Studio, you can studiio 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.
New Features in Version | Analysis Studio User Guide
In previous releases, if a query contained multiple hierarchies from the same dimension, you encountered errors or no data appeared in your report. When you apply a filter to a source report and then drill through to a target report, the target report is automatically filtered if cogbos item you selected is in a query in the target report. This means that the hierarchical relationship of a level is considered when member sorting is applied.
Line charts now include an option for creating step line charts. A guid 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. There is now support for multiple hierarchies of a single dimension for dimensionally-modeled relational data sources.
Analysis Studio User Guide 10.2.1
You can now perform dynamic filtering of data in Report Studio reports. By default, the business key is used.
For more information, see Suppress Empty Cells. For more information, see Using Drill-through Access. Viewing lineage information ensures that you add the correct data items to a report.
This allows you to sort using uzer members and measures. Enhanced Report Graphics A greater variety of colorful graphics and backgrounds are now available for dashboards and reports. 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 various versions of Excel.
You can now insert calculated members and measures in an intersection tuple.
New Features in Version | Report Studio User Guide
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. A data item’s lineage information traces the item’s metadata back through the package and the package’s data sources.
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 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.
Microcharts are miniature line and column charts. Extended Suppression Capabilities You can now suppress hser, 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.
For example, you can view the lineage information of a model calculation to see how it was created. New Query Properties The following two new properties allow you to customize queries: New Chart Types The following new syudio types are now available: This allows you to restrict when the drill path is available to users.
For more information, see Insert a Hierarchy.
In addition, the sorting of data by member is enhanced. For example, you can map the member caption instead of the business key to the target. For more information about color palettes, see Customizing the Color Palette of a Chart.