Submitted by: Fraser Gordon, IBM Business Analytics Education (Cognos)
IBM Cognos® Active Report provides an interactive analytics experience in a self-contained BI application for browsing and exploring data offline. Mobile workers can take their data with them to discover opportunities and analyze trends even when they are nowhere near a network.
The following demo is an abstract from the IBM Cognos Report Studio: Author Active Reports (v10.1) is an advanced one-day, instructor-led/instructor-led online course. If you would like to know more about this training course or other training courses, please click here.
Create an active report with a data iterator control that interacts with a data deck to make use of the swiping gesture that allows the user to navigate between pages on an iPad tablet.Studio:
Go Data Warehouse (query)Report Type:
Sales and Marketing (query)Namespace:
Sales (query)Task 1. Create an Active Report.
From the Toolbox tab, drag a Data Deck to the middle right table cell.Click the Source tab, and then drag Products > Product line to the Values drop zone.From the Toolbox tab, drag a Chart to the Data Card drop zone, select the default Pie Donut chart, and then click OK.From the Source tab, drag Sales fact > Quantity to the Default measures drop zone, and drag Products > Product types to the Series (pie slices) drop zone.Right-click the Pie Chart, and then click Go to Query.From the Source tab, drag Products > Product line under Data Items.Point to Query Explorer and rename the queries as follows:
- From the Toolbox tab, drag a Table to the report area, and set the number of columns to 2 and rows to 3.
- Click anywhere in the Table.
- In the Properties title bar, click the Select Ancestor button, and click Page.
- Under Positioning, set Size & Overflow as follows:
Point to Page Explorer, and then click Page1.Select the Pie Chart, and then from the Data menu, click Master Detail Relationships.Click New Link, select Product line from both queries, and then click OK.
- Query1 > Data_Deck_Query
- Query2 > Pie_Chart_Query
This creates a new link between the data deck and the pie chart based on Product line.
Task 2. Add an iterator to enhance report navigation.
- From the Toolbox tab, right-click a Data Iterator object, and drag it to the table cell above the data deck.
When you right-click a control and drag it into the report area, a prompt appears asking whether you want to simply insert the control, or insert it using an existing query.
- Click Insert using an existing query, select Data_Deck_Query, and click OK.
If you select the data iterator control you will see that the Query property is set to Data_Deck_Query in the Properties pane.
- From the Data Items tab, drag Data_Deck_Query > Product line to the Values drop zone for the data iterator.
- Repeat the step above to add Product line to the Label drop zone.
- Select the Data Iterator control, and change Name property to Iterator_DropDown_List.
- Beside the data iterator control, click Create a New Connection, and specify the connection with the following entries:
- Iterator_DropDown_List > Select > Data Deck1
- Data Item (left): Product line
- Data Item (right): Product line
- Active Report Variable: vProduct line
The report layout appears as follows: Task 3. Set a default value for the product line variable.
Task 4. Add animation to a deck to enable swiping.
- From the Active Report Variables tab, expand vProduct line, and then click Set Default Value(s).
- Under Values, click Camping Equipment, and click the green arrow to add it to the Selected values list, and then click OK.
- Run the report, and use the Next and Last buttons to navigate through the product lines.
On iPad tablets, page dots indicate that multiple pages exist, which a user can navigate by using swiping gestures. When authoring reports, you can use data decks to organize multiple pages of data that the consumer can easily navigate through. To do this, you must animate the deck, and set up the interactive behavior so that the deck uses the same variable as the one that selects the cards.
- Close the browser window displaying the report.
- Copy the Data Iterator control, paste it into the bottom table cell, and then set the Name property to Iterator_Dot_Swipe.
- Set the Iterator First, Iterator Previous, Iterator Next and Iterator Last properties to Hide.
- Within Iterator_Dot_Swipe, select the Iterator Label Area, and change the Select UI property to Page Dots Indicator.
- Select the Data Deck control, and set the following properties:
Run the report, and try using both the drop-down list and page dots to switch cards. The results appear as follows:
- Slide Animation Direction: Auto Horizontal
- Set Variable Values: Product line
Note: To prevent the chart from shifting when the user switches cards, select the table cell for the data deck and set the width to 60%. Task 5. Define an access code for the report.
- From the File menu, select Active Report Properties.
- Under Access code, enter a code value of 1234, and click OK.
- Run the report.
- When prompted, enter the access code of 1234, and click OK. The report is only accessible after entering the correct access code.
You created an active report with a data control that interacts with a data deck, to make use of the swiping gesture that allows the user to navigate between pages on an iPad tablet.