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.
|Published (Last):||13 November 2013|
|PDF File Size:||8.32 Mb|
|ePub File Size:||1.22 Mb|
|Price:||Free* [*Free Regsitration Required]|
A Data Button Bar provides the report author the ability to create buttons based on the number of records returned by a data item. 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.
The Pie Chart and Data Deck must also use different queries. Displaying the report name in a footer Getting ready How to do it Overriding crosstab intersection drill-through definitions Getting ready How to do it Since a single version of the output is shared, each user consumes the same reporting application and role based security is not honoured.
This is a valuable tool for ensuring the queries are filtered properly and no unnecessary data or images are included in the reporting application. Conditional column titles Getting ready How to do it The same objects can be inserted again on the other cards ensuring uniformity. The following example provides the step by step instructions on how to use the Auto Select to set the last item in a Data Drop-Down List object.
Cognos:Cognos BI Active Report CookBook – Cognos BI 10 Forum
The following sections will present commonly used techniques that leverage standard controls to deliver compelling end user experiences. Alternatively, the author can hide replrts level prompt controls and enable progressive disclosure by putting all of the lower-level controls into their own Decks.
The title of each Card should reflect the conditional styling that is present on that Card.
This process is made easier with the introduction of the Active Report Preview and its ability to select the device or size of device of the desired device.
When a dashboard is built using fixed sizing it is possible to overlay additional report objects. Templates are particularly useful when numerous reports need to be created using the same layout. In order to ensure a successful integration of the two technologies, the following considerations should be kept in mind:. The figure also illustrates the dialog that would appear by selecting the Info menu option or the Show Tab Control Recordset. Some of the most common scenarios include:.
This results in improved performance and enhances the overall experience. The control provides the report author the ability to supply the available values based on the record set returned by a specified data item.
Reporting applications can display video content for the end user. Some of the solution’s key features include:. The HTML Item describes the size of the frame that will display the video and the source of the video.
Rajib Bhattacharya: Two Cognos 10 Cookbooks that you cannot afford to miss
Using the prompt and promptmany macros in query subjects Getting ready How to do it There’s more… Why make filters mandatory? If the number of buttons is dynamic then a Repeater Table can be used so that the number of buttons is driven from a query.
To implement this functionality the chart should be placed in a Data Deck that is driven by the desired time period. This helps to minimize the output file size. Fixed sizing can be applied to the objects on the card and to the deck to ensure they are all the same. In applications where users can tolerate a longer load time and the file is shared to all users as a saved output in IBM Cognos Connection or on a network drive then it is not unlikely that a file over 20MB would be acceptable.
By leveraging drill-through functionality while connected to the IBM Cognos BI server, a business user can drive a deeper analysis without losing context. An author can use background effects or images to improve the visual appeal of reporting applications. As a result, the single-file output can be placed in a shared location and made accessible to anyone who has access to this network location.
The dialog box on the left hand side displays the Active Report Variables and the right hand side displays the Active Report Controls. If a known number of buttons are needed, a Static Repeater Table can be used to create the button bar. 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. Additionally, all IBM Cognos role based security will remain intact when a user chooses to run the report.
Since they are disconnected, an Active Report being consumed in Cognos Workspace requires a saved output to be created. Auto Horizontal animation will be enabled on this deck to support the iPad swiping functionality. With a focus on performance, the IBM Cognos This behaviour can affect the layout of a fixed size dashboard.
The Show Variables dialog box gives the author the current value of all variables and allows the author to understand how the variables are changing as a user interacts with the report. Choosing the output format from a atcive Getting ready How to do it Additionally, it is important to keep in mind 1 amount of data that is contained in a list or crosstab when laying out a fixed size report.
Leveraging layout component reference objects has a similar effect to using classes for styling.
IBM Cognos 10 Report Studio Cookbook – Second Edition
As data is filtered, the width of the columns will automatically adjust to fit the data that is currently being shown. The wide array of IBM Cognos Active Report controls ensures that the desired functionality can be achieved and an engaging end user experience can be delivered to business users. The following example will step a user through creating two simple Active Reports; one Active Report will be a Data Button Bar that assigns a value to the variable.
Getting started with scatter charts Getting ready How to do it In order to build useful reports and ensure a successful deployment, the author must carefully examine the use case and determine the best course of action. A report author defines the interactivity in an IBM Cognos Coognos Report in order to deliver a tailored user experience to their end users.
Validating textbox prompts Getting ready How to do it In this case, it is a Table with three rows and one column.