As the owner, you can view your published analytical work in the workbook consumption channel. This topic describes how to create and manage Quick BI workbooks.
Prerequisites
You have purchased the value-added service for asset consumption and enabled the asset consumption module for the current tenant.
Before you use the workbook feature, you must initialize the consumption channel. For more information, see Create and manage consumption channels.
Limits
To consume a table in the BI channel, the data source's cluster must be connected to the Dataphin cluster network.
You cannot create Quick BI analysis tasks if the data source is Hive on CDH 5.x (Hive 1.1.0) or MySQL 5.1.43.
If full table scan is disabled in Dataphin, you must enable it for analysis tasks when you create a Dataphin data source in Quick BI. This prevents SQL runtime errors. Use the following statement:
set oneservice.allow.full.scan=true.Only on-premises deployments of Quick BI V5.5.1_feature_2509 support data tables from AnalyticDB for PostgreSQL.
Create a workbook
On the Dataphin home page, choose Asset > Asset Consumption from the top menu bar.
In the navigation pane on the left, choose Consumption > My BI Analysis. On the My BI Analysis page, click the Quick BI Workbook tab, and then click Create Workbook. The Create Quick BI Analysis dialog box appears.
In the Create Quick BI Analysis dialog box, configure the parameters.
Parameter
Description
Analysis Task Type
Click Expand Details for more information.
Associated Asset
Select the table assets for which to create analysis tasks. You can search for an asset by name or filter by source. You can select multiple assets.
Workspace
If the selected consumption channel is configured with a default workspace and you have management permission for that workspace, the system automatically fills in the default workspace that is configured for the consumption channel. If no default workspace is set or you do not have management permission for that workspace, you need to select a workspace with management permission. To create a workspace, see Create and Manage Workspaces.
Dataset
If a dataset already exists for the selected asset in the chosen workspace, its name is displayed. If no dataset exists, one is automatically created before the analysis task is created. You can specify a name for the new dataset.
Click OK to validate the configuration.
After the configuration is validated, the system creates the required data source, dataset, and Quick BI workbook. You are then automatically redirected to the workbook creation page on the Quick BI platform for further configuration. For more information, see Create a Workbook.
View workbooks
The Quick BI Workbook tab lists the analytical work that you own and have published. This tab provides a unified view and quick access to your work, and displays the workbook name, publishing status, and BI workspace information.
You can search for analytical work by name or filter the list by publishing status or workspace.
In the Actions column for an analytical work, you can perform the following operations:
Feature
Description
View
Click to go to the Quick BI platform to view the workbook task. For more information, see Workbooks.
Edit
Click to go to the Quick BI platform, where you can modify the workbook's fields, page configuration, and more. For more information, see Manage Workbooks.