Overview
Version
| FineBI Version | Functional Change |
|---|---|
6.0 | / |
6.1.2 | Added the control parameter SystemOptimizationConfig.shieldFunction. |
Problem
If the individual FineBI subjects are placed together with the corresponding data and components, you can maintain them more conveniently. To maintain subject isolation and avoid cross-subject table usage, FineBI has blocked certain functions that may lead to subject overlap.
However, in some cases, you must use tables outside a subject to realize functions such as copying and pasting the components to other subjects, copying and pasting the dashboards to other subjects, or merging tables outside a subject with tables in the subject.
Implementation Method for Unlocking
You can use the FINE_CONF_ENTITY Visualization Configuration plugin to configure relevant parameters, allowing you to call tables within and outside a subject.
1. Plugin Installation
You can obtain the plugin at https://community.finereport.com/plugin/?id=107.
For details about how to install the plugin, see Plugin Management.
2. Parameter Value Modification for Limit Removal
After the plugin is installed, log in to the FineBI system as the super admin and choose System Management > System Tool (added automatically).
Click Select Parameter Configuration, select SystemOptimizationConfig.shieldFunction as System Parameter Name (key), and set System Parameter Value (value) to false. Click Save after completion.
| Parameter Name | Parameter Description | Parameter Value |
|---|---|---|
SystemOptimizationConfig.shieldFunction | Determines whether the use of tables within or outside the subject is limited. | The parameter value (true by default) needs to be of the Boolean type. true: The use of tables within the subject is limited. false: The use of tables within or outside the subject is not limited. |
3. FineBI Project Restart
Click Save after modifying configurations based on relevant rules. A prompt appears: "The parameters you modified will take effect after restart. Restart the server first."
Restart the FineBI project to make the configurations take effect.
Effect After Unblocking
After modifying the control parameter, you can view and use the following functions.
Copying and Pasting Components to Other Subjects
You can copy components from the current subject and paste the components to other subjects. The following figure shows the function entry.
Copying and Pasting Dashboards to Other Subjects
You can copy dashboards from the current subject and paste the dashboards to other subjects. The following figure shows the function entry.
Multi-Selecting Tables
For multiple tables that have been associated, you can put the fields of the tables into a large and wide table for easy analysis.
Click Switch Data and then click Multi-select Tables. For example, after selecting BIdemo_Bank_Loan Type, you can continue to select fields from BIdemo_Bank_Loan Details associated with BIdemo_Bank_Loan Type. Select Credit Rating, and you can view the data column of Credit Rating during the data preview.
Note:1. After the function is blocked, you can realize the same effect by using Join as the replacement of Multi-select Tables.
2. After selecting fields from the first table, you can continue to select fields from tables associated with the table. Tables unrelated to the table will be grayed out, and you cannot select fields from the tables.
Combining Tables Within and Outside a Subject
When you select Join or Union All, you can select only tables within the same subject in the system, thereby maintaining subject isolation.
After unblocking, click , and you can select tables outside the current subject, as shown in the following figure.
