[Direct Connection] Transferring Parameters by Directly Suffixing Dashboard URLs

Version

Application Scenario

In an integrated environment, you may want to only filter data of the management store through directly adding relevant parameters at the end of the dashboard URL (to form a parameter transferring URL, such as http://xxxxxxxx?ShopNature=Management store) after opening the store dashboard.

Implementation Method

• You can add parameters in the SQL dataset.

• You can directly add parameter conditions in the frontend dashboard to filter data.

If you need to transfer parameters through the filter component, you can refer to the documents Dynamic Control of Result Values Through Parameters in Calculation Fields and Jumping to a Web Link.

Adding a SQL Dataset

1. Select Direct-Connected Data in the dataset attribute setting if both the Extracted Data and Direct-Connected Data functions are available at the same time. Choose Public Data, select a business package, click Add Dataset, and select SQL Dataset from the drop-down list, as shown in the following figure.

2. Enter the SQL statement select * from 'Retail_Store Dimension' where ShopNature in ('${ShopNature}'). ${ShopNature} is the set parameter variable. Click Refresh, set Default Value to Self-store and Parameter Type to Text, click Preview, and save the dataset, as shown in the following figure.

Creating a Group Table

Click the Group Table icon in Chart Type and drag fields into Dimension and Indicator to create a component, as shown in the following figure.

Transferring Parameters

Transferring Parameters Through the Public Link

To filter data by transferring parameters in the URL, first obtain the dashboard URL. Go to the dashboard, click Public Link on the dashboard menu bar, enable Share Link, and click Copy Link, as shown in the following figure.

For example, the obtained URL is http://localhost:37799/webroot/decision/v5/conf/subject/page/edit/ceaff2fbd1b147e19b80bef9139c48bf/report/55ca1a19dcdd4515b3ef2a268d03de4b.

Add a parameter condition (?ShopNature=Management store) at the end of the obtained URL to form http://localhost:37799/webroot/decision/v5/conf/subject/page/edit/ceaff2fbd1b147e19b80bef9139c48bf/report/55ca1a19dcdd4515b3ef2a268d03de4b?ShopNature=Management store.

Enter the URL with added parameters on the address bar. You can view that data of Management store is displayed after filtering through parameter transferring in the URL.

Transferring Parameters Through the Preview Link

You can also transfer parameters by adding ?Parameter name=Parameter value at the end of the preview URL.

Click Preview to obtain the preview URL, as shown in the following figure.

Add ?ShopNature=Management store at the end of the preview URL. 

You can view data of Management store is displayed in the group table after filtering through parameter transferring, as shown in the following figure.

You can also perform filtering with multiple conditions by adding multiple parameters at the end of the URL to transfer parameters.

Creating a SQL Dataset with Multiple Parameters

Create a SQL dataset and enter the SQL statement with multiple parameters select *  from 'Retail_Store Dimension' where ShopNature in ('${ShopNature}' ) and ShopStyle in ('${ShopStyle}' ).

Click Refresh, set Default Value to Fashion hall and Self-store, and save the dataset, as shown in the following figure.

Creating a Dashboard

Create a component through fields (including Shop Nature, Shop Style, and Count) in this data table, as shown in the following figure. The field display values in the component are the default parameter values.

Transferring Parameters

You can refer to section "Transferring Parameters Through the Public Link" to obtain the dashboard URL. Add multiple parameters and their corresponding values at the end of the obtained URL.

For example, the obtained preview URL is

http://localhost:37799/webroot/decision/v5/conf/subject/page/edit/9ce5fd2b6b154114b1fd4489ff0f1c13/report/9d65ee3a00904ec79f8ba7665d8b9b7a.

Add parameters (?ShopNature=Management%20store&ShopStyle=Living%20Hall) at the end of the URL to form http://localhost:37799/webroot/decision/v5/conf/subject/page/edit/9ce5fd2b6b154114b1fd4489ff0f1c13/report/9d65ee3a00904ec79f8ba7665d8b9b7a?ShopNature=Management%20store&ShopStyle=Living%20Hall.

After you add parameters, the corresponding parameter values can be directly displayed in the dashboard after filtering by parameter transferring, as shown in the following figure.