6.0.16 Update Log

Version

Upgrade Compatibility

In FineBI that is upgraded to 6.0.16 and later versions for the first time for the server dataset, you can replace the original class files with new class files. Since then, any later upgrade will no longer require class file replacement.

You can replace the original class files in webapps\webroot\WEB-INF\classes\com\fr\log path, and perform restart for the replacement to take effect.

6016+.zip

--Function Optimization--

IF Function Optimization

In previous business scenarios, only the nested IF function can meet the calculation requirement when there are multiple conditions, which made the formula lengthy and difficult to understand.

In 6.0.16, the statement logic of the IF function has been optimized to avoid the lengthiness caused by nested IF functions in multi-condition value assignment scenarios.

For example, assume that you need to label students with different scores.

• Before: if(Score<60,"Failed",if(Score<70,"Passed",if(Score<80,"Good","Excellent")))

• Now: if(Score<60,"Failed",Score<70,"Passed",Score<80,"Good","Excellent")

For details, see IF.

IFERROR Function Added

The IFERROR function is added to identify and process abnormal data. The abnormal data refers to the positive infinity (∞), negative infinity (-∞), and NAN (∞/∞).

For details, see IFEROR.

--Enhanced Table Display Capability--

Summary Row/Column Hiding Supported

In 6.0.16, you can display desired indicators and hide undesired indicators in Summary Method for crosstabs. For example, you can display only the summary columns of the Product Purchased and Purchase Quantity indicators.

For details, see Summary Row/Column.

In-Group Summary Row Displayed in the Tree/List Structure

In 6.0.16, the function of displaying in-group summary rows in the tree structure and list structure has been added, enhancing the table effect.

For details, see Style.

Summary Optimization After Grouping Customization of Indicator Names

In 6.0.16, the summary row/column is calculated according to the customized grouping method after grouping customization is performed on indicator names. For details, see Indicator Name.

Row Header Node Optimization

The function of displaying the row/column header node is optimized, allowing you to hide the header node. For example, you can use this function to hide the row header node of a grouping table, as shown in the following figure.

For details, see Table Format.

--Enhanced Chart Usability--

Chart Color Optimization

(1) More color schemes are added. Three industrial colors are added for the dark mode and seven colors (three industrial colors and four category colors) are added for the light mode.

(2) Existing colors have been optimized with larger contrasts and more vivid colors (available to new users installing FineBI of 6.0.16 and later versions).

For details, see Chart Color.

Legend Optimization

• The default legend style (color legend slider and size legend slider) has been optimized.

• The default legend position (middle and lower by default) is optimized.

• A prompt hovers when the legend text exceeds the maximum range.

Category Axis Optimization

Axis titles are not displayed for the category axis by default.

--Component--

Time Field Filtering Optimization

In 6.0.16 and later versions, date field filtering is optimized in the analysis area and result filter, making it more convenient to filter data in a certain period of time.

For details, see Analysis Area Filtering and Result Filter.

(1) You can filter data in/not in a certain period of time.

(2) You can filter the time point/parameter data by/since a certain date.

• Time Point

• Parameter

--Dashboard--

Dashboard Hover Effect Optimization

For details, see Dashboard Style.

(1) You can determine whether to display component hover shadows in 6.0.16.

You can disable the shadow for a dashboard with multiple hover components, beautifying the dashboard effect.

(2) The table scrollbar supports hover display, further beautifying the dashboard.

SQL Parameter Optimization

Optimizing the Function of Binding Parameters to Filter Components

For details, see SQL Dataset Parameter Writing Example.

(1) Parameter display optimization

• Only parameters in the data source of the subject are displayed. Parameters unrelated to the subject are no longer displayed.

• The source paths and parameter names are displayed for parameters, facilitating parameter source locating.

• Parameters are displayed in a double-level directory tree for a clearer presentation effect.

(2) Parameter binding optimization

• A filter component can be bound to multiple SQLvparameters. After binding, all bound parameters are subject to the value of the filter component.

• When setting the SQL parameters to be bound to the filter component of the same dashboard, you cannot select parameters      that have already been bound to the dashboard.

Transferring the Default Value Corresponding to the Login Name

The filter component can filter out different data from a dashboard to different users by default. For details, see Transferring the Default Value Corresponding to the Login Name by the Filter Component.

For example, the login user jack can only view the information about all account managers in the sales region Hangzhou (where jack is located) filtered by the filter component, as shown in the following figure.

Dashboard Preview Zoom Limit

The parameter SystemOptimizationConfig.scaleLowerLimitBI/SystemOptimizationConfig.scaleUpperLimit is added to restrict the zoom lower and upper limits during dashboard preview.

For details, see Dashboard Adaption.

--Analysis Document--

Public Link Sharing Supported by Analysis Documents

In 6.0.16, the function of sharing and mounting public links of analysis documents has been added, allowing you to share analysis documents for others to view.

For details, see Sharing Dashboards Through Public Links.

StarRocks Data Connection Optimization

You can select catalog (data directory). In this way, you can obtain data from the external catalog of StarRocks. For details, see StarRocks Data Connection.

SQL Parameter Optimization

The YYYY-MM-DD HH:MM:SS format is added for SQL dataset parameters. For details, see Adding SQL Datasets.

Data Alert Optimization

For details, see Introduction to the Data Alert Plugin Using.

(1) Data Alert allows you to add date fields as dimensions.

(2) The alert content related to the responsible person is dynamically generated and pushed based on the abnormal data of the alert object. Dynamic receivers can receive real-time alert notification information only related to themselves.

Row Permission Optimization

In business scenarios, sometimes row permissions need to be filtered to meet the viewing requirements of different objects. You can add multiple login user information items as the row permission condition.

For details about how to use this function with the filter component, see Transferring the Default Value Corresponding to the Login Name by the Filter Component.

You can expand formulas supported respectively by business tables and permission tables to filter row permissions.

For details, see Row Permission-Supported Formula.

Performance Analysis Optimization

(1) The FineBI performance analysis function is directly integrated into the product (no longer provided by plugins).

(2) Performance analysis is supported for both real-time data and extracted data.

(3) The time consumption calculation logic of the execution phase is optimized.

For details, see Performance Analysis.

Canvas Resizable

In business scenarios on the mobile terminal, you may always encounter the inconsistency between the mobile terminal layout during PC preview and the actual mobile terminal layout. In 6.0.16, nine new default canvases are added for the mobile terminal. You can select a default canvas for the mobile terminal to set the layout based on your commonly used phone model.

Style Customization Added

In 6.0.16 and later versions, you can directly set the style of text components and vertically center them on the mobile terminal. You can also directly set the title of components, eliminating the need to repeatedly switch back to the PC for setting. The effect after setting is clear at a glance. For details, see Mobile Layout.

• Rich text setting of the text component (adapting to vertical centering of the text component)

• Rich text setting of the component title

Default Optimization on the Mobile Terminal

(1) The layout configuration on the mobile terminal is optimized, improving the production efficiency.

• The legend position is optimized. Legends displayed in the upper left and the upper middle on the PC are displayed at the top on the mobile terminal. Legends displayed in the lower left and the lower middle on the PC are displayed at the bottom on the mobile terminal.

• The chart font is set to self adaptation by default.

• The full-screen button is not displayed by default for text components and KPI indicator card components.

• The filter component style is optimized, allowing you to perform multi-component layout setting more conveniently.

(2) Interaction viewing is optimized to improve user experience.

• In 6.0.16, the cross interaction style is no longer selected for KPI indicator cards.

• The blue-dotted interaction style in the top left corner is canceled after linkage.