Social Icons

Cognos Workspace

In IBM Cognos Workspace, you can create sophisticated interactive workspaces using IBM Cognos content, as well as external data sources such as TM1 Websheets and CubeViews, according to your specific information needs. You can view and open favorite workspaces and reports, manipulate the content in the workspaces, and e-mail your workspaces. You can also use comments, activities and social software such as IBM Connections for collaborative decision making.


Example- Work with a Workspace

Use IBM Cognos Workspace to build sophisticated interactive workspaces that facilitate collaborative decision making. You can open workspace widgets in IBM Cognos Workspace Advanced to edit them.


In this exercise, you will open a Cognos Workspace widget in Cognos Workspace Advanced to make changes and then view your changes in Cognos Workspace. You are a report author in the Sample Outdoors Company. You want to create a workspace showing employee training by organization level. You have a report widget that shows some of the information you need, so you decide to customize
this widget and create a workspace for future reference.

To perform this exercise, you must have the appropriate licensing and security permissions for this functionality.

Procedure

1. Open Cognos Workspace:
a. Start your Web browser.
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos

2. In the IBM Cognos Welcome page, click Create a workspace on the web.

3. Click Create New.

4. In the Content tab of the Content pane, expand Public Folders, Samples,models, Go Data Warehouse (analysis), and Cognos Workspace Source Reports. Drag Employee Training Cost to the workspace.

5. Click the Actions menu icon for the Employee Training widget, and then click Do More. The report widget opens in Cognos Workspace Advanced.

6. Click the chart body to show the drop zones where you can insert data items.

7. Delete Course cost in the Default measure (y-axis) drop zone.

8. In the Source tab of the Content pane, expand HR (analysis), Employee training, and Employee training fact. Drag Course cost to replace Employee expense type in the Series (primary axis) drop zone.
9. In HR (analysis), Employee training, expand Organization, Organization, and drag Organization name (level 1) to replace Organization (level 1) in the Categories (x-axis ) drop zone. 10. Click Done to return to Cognos Workspace. Note your changes to the Employee Training widget.

11. On the application bar, click the Actions menu icon , and click Save as.

12. Click My Folders, and type My Employee Training in the Name text box, and
then click Save.

The final report looks like this:



With IBM Cognos Workspace Advanced, you can perform advanced data exploration and author simple reports.

When you are in a workspace in IBM Cognos Workspace and want to perform deeper analysis and report authoring, you can seamlessly graduate to Cognos Workspace Advanced, where you can perform more advanced data exploration, such as adding additional measures, conditional formatting, and advanced
calculations. You can also launch Cognos Workspace Advanced directly from the IBM Cognos Connection portal.

With Cognos Workspace Advanced, you can create reports with relational or dimensional data sources, and that show data in lists, crosstabs, and charts. You can also use your own external data source. When you are using Cognos Workspace Advanced, if you open a report that was authored in IBM Cognos Report Studio, you can see the objects that can be inserted only in Report Studio, such as map. However, you cannot modify these objects.

Example- Create a Statement-Style Report

Use IBM Cognos Workspace Advanced to create reports with relational or dimensional data sources and to how data in lists, crosstabs, and charts. In this exercise, you will learn how to create a statement-style report.

You are a report author in the finance department of the Sample Outdoors Company. You create a balance sheet that shows the assets, liabilities, and equity for the company over the last few years. To perform this exercise, you must have the appropriate licensing and security permissions for this functionality.

Things to notice:
-When you use Cognos Workspace Advanced, data is live. You do not have to run a report to see the data. From the View menu, you can switch between the Page Design and Page Preview views to see the live data and the design of your report.

Procedure
1. Open IBM Cognos Connection:
a. Start your Web browser.
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos

2. In the IBM Cognos Welcome page, click Author business reports.

3. Click Samples, Models, GO Data Warehouse (analysis).

4. Click Create new, click Financial, and click OK.

5. Insert data in the crosstab zones:
a. In the Content pane, click Insert Members with Children , and click Insert Single Member.
b. In the Source tab of the Content pane, expand Finance (analysis), Finance, Account, and Balance sheet (total). Drag Assets (total) to the Rows zone.
c. Under Balance sheet (total), expand Liabilities & equities (total). Drag Liabilities (total) and Equity (total) to the Rows zone, under Assets (total). Tip: When you drag an object to the crosstab, you see a flashing
horizontal or vertical bar to indicate where the item will be placed in the crosstab.
d. Expand Submission. Drag 2012 Actual results in USD to the Columns zone.
e. Drag 2011 Actual results in USD to the Columns zone, next to 2012 Actual results in USD.
f. Expand Time, 2012, and Q4 2012. Drag December 2012 to the Columns zone, under the 2012 Actual results in USD.
g. Under Time, expand 2011 and Q4 2011. Drag December 2011 to the Columns zone, under the 2011 Actual results in USD.
h. Under Finance (analysis), expand Finance fact. Drag Amount (year to date) to the Measures zone.

6. Expand the rows to view the breakdown of assets, liabilities, and equity:
a. In the report, right-click Assets (total) and click Expand Member to examine the members of the assets.
b. Repeat for Liabilities (total) and Equities (total).

7. Change the title of the report to reflect the contents of the balance sheet:
a. Double-click the heading title, type Sample Outdoors Company, and click OK.
b. In the Toolbox tab of the Content pane, drag the Block object to the right of the Sample Outdoors Company title. Repeat the steps to add a second block underneath the first.
c. In the Toolbox tab of the Content pane, drag the Text Item object inside the first block object. When the Text window opens, type balance sheet as at Dec 31, 2012, and click OK.
d. Drag the Text Item object inside the second block object. When the Text window opens, type (with prior year comparative data), and click OK.
e. Ctrl+click both block objects and, by using the toolbar, change the font to 10 point size (10 pt).

8. Change the currency format of the balance sheet:
a. In your report, under the 2011 Actual results in USD, under December 2011, use Shift+click to select the whole column.
b. Right-click the selection, click Style, and click Data Format.
c. In the Format type list, select Currency.
d. In the Properties pane, click the Currency property, and select $ (USD) - United States of America, dollar.
e. Click the No. of Decimal Places property, and then select 0.
f. Click OK.

9. Copy the formatting to the 2012 column:
a. To copy all the formatting that is applied to the item, click Pick up Style, click the items that you want to format, and then click Apply Style.
b. To copy only one of the formatting styles, click the down arrow next to the Pick up Style icon, and click the style that you want to copy. Then, click the item that you want to format, and click Apply Style.
c. If you want to change a style that you copied, click the down arrow next to the Pick up Style icon, and click Edit Dropper Style. Specify basic and advanced style characteristics, and then click OK.


10. Change the text formatting to reflect a standard balance sheet:
a. Right-click Amount (year to date) and click Edit Data Item Label.In the Data item label box, type Year to date (USD), and click OK.
b. Select Year to date (USD) and, by using the toolbar, change the text to bold.

11. From the Run menu, click Run Report - HTML.