9.3

Edit

WorkFusion Analytics custom dashboards backup and restore

General migration flow

The workbook migration flow includes the following steps:

  1. Download Workbook.
  2. Change data source connections if needed.
  3. Rename Workbook according to the naming convention.
  4. Publish Workbook to a new instance.

Backup

Backup dashboards means download them from WorkFusion Analytics Server.

WorkFusion Analytics Server 9

  1. Open the WorkFusion Analytics Server page and select appropriate Site.

  2. Click Projects.

  3. Choose the needed one.

  4. Find workbook for downloading and expand workbook menu by pointing and clicking three dots.

  5. Click Download. The TWBX workbook file will be downloaded.

WorkFusion Analytics Server 10

  1. Open the WorkFusion Analytics Server page and select appropriate Site.

  2. Click Projects.

  3. Choose the needed one.

  4. Find a workbook for downloading and expand the workbook menu by pointing and clicking three dots.

  5. Click Download. The TWBX workbook file will be downloaded.

Restore

WorkFusion Analytics Desktop usage

Step 1: Change connections (optional)

note

If all connections to the database server remain the same, skip the step and proceed to the next.

  1. Open the recently downloaded workbook file in WorkFusion Analytics Desktop.

  2. Go to worksheet by pointing and clicking the Go to sheet button in the Dashboard section.

  3. On the Data tab, right-click a data source and select Edit data source....

  4. Edit data base connection settings and click OK. Move to the dashboard sheet.

Step 2: Sign into server

  1. On the menu bar, select Server - Sign in....

  2. Enter BI server URL and click Connect.

  3. Enter WorkFusion Analytics Server credentials and click Sign In (a user should have Publisher, Site, or Server Administrator role).

  4. Select the appropriate Site for publishing.

Step 3: Publish workbook

  1. On the menu bar, select Server - Publish Workbook....

  2. Check the Project and Name fields.

    It's important to use the _custom postfix in name, to meet WF Dashboard configuration requirements. The name should not start with a digit. After a workbook publish dashboard will appear on the Analytics > Custom page of Control Tower.

  3. Choose the Show sheets as tabs option.

    Optionally, there is an opportunity to add refresh extract schedule.

  4. Click Edit in the Sheets section and select sheets to publish.

  5. Click Edit in the **Data Sources **section and change a publish type to Embedded in workbook and authentication mode to Allow refresh access.

  6. Click Publish.

  7. Check the published workbook on BI server.

← PreviousNext →