Import a burst report and hide worksheets for burst recipients

When report authors burst a report, users can run a report once and divide the results for distribution to multiple recipients. Each report recipient sees only the subset of data to which they have access. You can distribute burst reports by email, save to a directory for viewing in IBM® Cognos® Connection, or both.

IBM Cognos Analytics recipient users can use IBM Cognos for Microsoft Office to import burst reports.

In this topic, you learn how to

  • show sales targets for each sales representative on a single worksheet

    The sample list report, Bursted Sales Performance Report, shows how the product sales report is bursted to a sales manager for Northern Europe sales staff.

  • hide worksheets so that only some burst recipients see the information
  • protect the workbook so that access to the hidden worksheets is restricted

    Important: Hiding, locking, and protecting a workbook and worksheet is not intended to help secure or protect any confidential information that you keep in a workbook. It helps to only obscure data or formulas that might confuse other users and prevents them from viewing or making changes to that data.

It should take 10 to 15 minutes to complete this topic.

Procedure

  1. Select the Browse Content tab.
  2. Import the Bursted Sales Performance Report report from GO Data Warehouse (query), GO Office Report Samples.
  3. When importing the report, create a new worksheet for each report page, ignore the formatting for the headers, and automatically resize the columns for your list element.

    The sales target for each representative appears in a separate worksheet.

  4. Hide the worksheets for Hester Uhlenbroek (Bursted Sa Page 1-3) and Lovisa Svinhufvud (Bursted Sa Page 1-5).

    Note that the sheets labeled Bursted Sa Page 1-3 and Bursted Sa Page 1-5 are not shown.

  5. Protect the structure of the workbook.

    Locking the structure of a workbook prevents users from

    • viewing worksheets that you have hidden
    • moving, deleting, hiding, or changing the names of worksheets
    • inserting new worksheets

    You can also hide a worksheet so that it can only be recovered using VBA code, and then protecting the project or the Visual Basic Editor with a password.

Results

For more information, see