Working with Active ReportsIn this chapter, we will cover the following topics: Building tabbed IBM Cognos 10 Report Studio Cookbook, Second Edition. 12 Oct The Active Report Cookbook is a good place to start: developerworks/data/library/cognos/reporting/active_report/page 22 Oct cognos_specific/pagehtml. A must read for Active Reports.

Author: Tale Tojalar
Country: Uzbekistan
Language: English (Spanish)
Genre: Travel
Published (Last): 27 April 2007
Pages: 417
PDF File Size: 17.29 Mb
ePub File Size: 17.28 Mb
ISBN: 790-2-43936-883-1
Downloads: 72459
Price: Free* [*Free Regsitration Required]
Uploader: Nill

This results in improved performance and enhances the overall experience. With this information the IBM Cognos Report author is able to determine how many charts have been created, how many controls are in the report and what records are actve in the report.

Viewing the page structure Getting ready How to do it To avoid this behaviour, the real estate allocated to the list should be set to the lists maximum size or it can be placed in a scrollable block. If the Cognos Mobile app determines that the minimum width is still too wide for the width of the screen, rather than displaying scroll bars or making the user pan horizontally, it will scale the view until it fits perfectly within the width.

On the iPad, a small area on the reoprts may be difficult for a user to select so an alternative control should also be provided.

When working with dimensional data, if multiple dimensions drive a Data Deck and the fact table is large, it is possible to optimize the query and reduce the build time of the reporting application.

IBM Cognos 10 Report Studio Cookbook – Second Edition [Book]

This will prevent the reporting application from becoming unnecessarily large. These buttons can be used to dynamically filter a data container.

You will see a new fictional business case in each recipe that will relate to a real-life problem and then you will learn how to crack it in Report Studio.

Any common styling or static content should be placed outside of the deck in order to avoid it being unnecessarily duplicated. It is mandatory that the variable names match teports that the Public External option is set in order for the context to be passed from one Active Report to another within the IBM Cognos Workspace.

Upon selection, the metrics area will scroll vertically to provide the user with a visual cue that the data has updated.

Picking up and applying styles Getting ready How to do it This functionality is demonstrated in the supporting files Custom Buttons. Alternating drill links Getting ready How to do it Cascading prompts are useful reportz interacting with a reporting application when there is hierarchical data.


To help display the current context and selection state of the dashboard to the end user the styling of aftive custom button can be changed to better reflect an active state.

Working with Active Reports – IBM Cognos 10 Report Studio Cookbook – Second Edition [Book]

It is important to note that for a background effect to appear, it needs to be applied to an area that is a fixed size. When this setting is unchecked, the axes of each chart in the data deck will be scaled to the data contained in that specific chart.

Using the prompt and promptmany macros in query subjects Getting ready How to do it The larger the number of unique chart permutations that an author creates, the larger the size the MHT output file will be. The following image illustrates the dialog box presented to the user after right clicking on a reporting application that has been run from IBM Cognos Report Studio. The Active Report Controls tab complements the variable pane by showing which variables each control is set by and which variables each control sets.

If the use case for a specific reporting application is mobile centric and it will frequently be consumed on the iPad then there are some design considerations that can be taken into account to optimize the end user experience.

A selection expression that is a combination of the variables containing the desired year and product can be used to choose the proper card.

The following example will step a user through creating one simple Active Report and a second regular report; one Active Report will be a Data Button Bar that assigns a value to the variable.

A Data Deck is used because unique content is required for each member of Sales Channel. Filtering rows or columns Getting ready How to do it If a Chart or a Map has no interactivity configured for driving selection, it is a best practice to set the number of Hotspots to zero.

IBM Cognos Active Report 10.2 Cookbook

In order to remain consistent with established iOS navigation standards, scrollable areas on a reporting application when rendered in the IBM Cognos Mobile native iPad application do not have visible scrollbars. This gives acttive end user a stock ticker like experience. These objects will reduce the time required to apply and adjust styling and will also provide a library of design styles that can be reused for other reports.

The following screen capture provides a visual representation of the differences between filtering and segmentation. To accomplish this, ative report object should be duplicated on multiple Cards in a Deck. A Data Toggle Button Bar provides the report author the ability to display multiple selectable buttons based on the number of records returned by a data item. To hide content until a condition is satisfied, a Deck with an empty re;orts card can be used.


The other report will use that value to filter a Simple List. IBM Cognos Active Report technology allows interactive reports to be distributed outside the organization without having to worry about granting those cookbook access to the IBM Cognos server. Aggregation and rollup aggregation Getting ready How to do it In order to accomplish this, the desired string should be built within a Repeater control.

A Deck provides the report author the ability to manually create the desired number of cards. To build a cascading prompt, each control must be filtered by the selections made in all of the higher-level controls.

On the other hand, blocks do not support vertical alignment but they can control overflow by becoming a scrollable area or by clipping content. The following sections discuss recommended design practices and guidelines for some of the main areas of IBM Cognos Active Report content creation. The various levels of the selection hierarchy are contained in separate Decks and variables are used to filter the display Lists and show or hide Decks to provide the desired functionality.

This means that proper sizing must be applied to all objects and propagated throughout the entire object hierarchy in order to maximize screen real estate and avoid scrolling. This is particularly true when styling objects in a deck because many copies of the same styling will otherwise be created.

IBM Cognos 10 Report Studio Cookbook – Second Edition by Abhishek Sanghani, Ahmed Lashin

This can be made of a variety of controls that set the variables such that the user is returned to the desired level of detail. Converting a chart to another chart type Getting coognos How to do it In an Active Report they can be used for creating image and text custom buttons.

When a selection is made and a user wants to drill down, variables and Default Card functionality is used to hide the current Deck and reveal the Deck that contains the lower-level information. The author of the report controls this and the access code is the same for all users.

Then it ascends to advanced techniques and tricks to reporte Studio limitations.