<< Click to Display Table of Contents >> Current:  Yonghong Z-Suite White Paper  Yonghong Z-Suite V8.5.1

❖New Key Features

1. Self-Service Data Preparation

New Data Masking Function to Further Ensure Data Security

Encrypted display of sensitive data, even the business personnel who produce the dashboard cannot see the complete data, which ensures the security of the data.

After the masking rule is set at the data set, it can be applied directly in the column Property-> Edit-> Data Masking of a single data set.

You can add users, groups, and roles to the blacklist, for example "Business Sales Group" as desensitization users. All users under this group enter the data set and dashboard to view the data and see only the desensitized data.

Desensitization user "mandy", logs in and sees the masked data is the data set and dashboard as follows.

 

Get Kylin and Kyligence's Cube Directly

The new version could get data directly from Kylin and Kyligence's cube without defining complex sql. Note: Only versions after Kylin 2.0 are supported.

Eight calculations in Kylin or Kyligence are involved: SUM, MAX, MIN, COUNT, COUNT_DISTINCT, TOP_N, PERCENTILEE, etc.

Add the pre-aggregated column "AAA" to the dashboard and you will see the results sorted by TopN.

 

Column-level Permission Supports Whitelist Mode to Meet Different Business Scenarios

Column-level permission settings, on the basis of the original blacklist mode, add the support for the whitelist mode. Blacklist mode can be used when only a few users shall be blocked; whitelist mode can be used when there are too many users to block;

Blacklist: This column is not visible to users, groups, and roles in the selected list.

Whitelist: This column is visible to users, groups, and roles in the selected list.

 

Support Multi-Version Database Driver with Eager Loading

The function of driver management effectively solves the problem of versions conflict of drivers. And without restarting Yonghong, you can query data at the same time.

For example, the drivers of big data source such as Kylin, Hbase, Hive and Impala can be used to query data at the same time without conflict. You can also query data of two versions of the same database at the same time, such as oracle 8 and oracle 9. You just need to define the drivers' names for oracle_8 and oracle_9 in the driver list and upload the corresponding driver. After uploading the driver, the data can be previewed normally.

When you add a driver, set the driver name for the new custom driver.

In the data source page, select the driver as "Custom", then select a custom driver name (named after "Driver Name (Class Name)" here), and save the data source after testing the connection.

 

2. Advanced Analytics

Add Python Model and Python Data Node

Add Python model, Python data and Python drawing nodes to better support mining scenarios using Python language.

 

New Python Cases Displayed on Homepage of Advanced Analytics

•Credit card transaction fraud detection

This example uses Python model node to connect Python data node and design algorithms to complete credit card transaction fraud detection, helping card issuers to achieve anti-fraud and protecting the property of cardholders.

•Identification of electric power stealing and leakage

This example uses Python drawing node to process data (LLE dimensionality reduction) simply collected by the power measurement automation system and visualize the dimensionality reduction effect, which is helpful for further classification and identification of users who steal electricity.

 

3. Dashboard

Add Dependency Analysis to Clearly Understand the Interdependence Between Data and Resources

New visual dependency analysis, showing the data set, data sources, SQL statements, databases, database tables that the dashboard relies on. At the same time, it supports the return of dependency results through WebAPI.

 

Multi-Granularity Expression Achieves Different Degrees of Aggregation of the Calculation in One Table

Yonghong V8.5.1 supports multi-granularity expression that allow users to easily integrate values of different degrees of aggregation into a single chart to meet the analysis needs of more business scenarios.

Aggregation functions that used to require complex scripting, or be difficult to realize, can now be implemented with a simple formula. With the multi-granularity expression, you can easily calculate "the contribution of sales of one market to total sales nationwide", "the average maximum sales volume by region", and so on.

 

Add Application Market to Meet Customer's Personalized Expansion Needs

In the new version, the application market is launched. Users can download the required applications through the address http://plugins.yonghongtech.com. After downloading, they can open Yonghong Manage System - Application Management for installation. Application market of V8.5.1 has provided some applications, including Dingtalk integration, enterprise WeChat integration and so on. Later Yonghong will continue to introduce more applications to the market, and you can download the application according to the project requirements.

There are two kinds of applications in the application market: free and paid. Users need to register and log in to download free apps or to download trial paid apps. If you need to purchase a paid application, you need to contact the market department or salesman to purchase it. After purchase, download the corresponding application from application market.

Open the application market in Yonghong Forum, and you can go to Yonghong Forum to view announcements and instructions. Forum address: https://www.yonghongtech.com/webbbs/portal.php. Customers with new application requirements can go to the Forum to publish their requirements.

 

Add Large-Screen Chart Type to Meet Advanced Visual Presentation Requirements

In the new version, the new chart type plug-in includes flip clock, rotating clock, and JS moving picture background to meet the personalized needs of large-screen display of customers.

•Flip clock and rotation clocks do not need to bind data columns and automatically display the current time.

•You can select JS animation for the background of the dashboard to display the dynamic background.

 

Add Data Verification Rules to Strengthen the Reporting Function

Form editor adds verification rules , including text, cell phone, ID, zip code, and mailbox. If the input format is incorrect, relevant prompts will be given.

Cells do not support input when the editor selects a drop-down list, timestamp and date. When it is a drop-down list, the search is implemented in the drop-down list. Note: Searching in drop-down lists is not supported on the mobile terminal.

 

Excel Export Optimization to Support Format Retention after Export

Excel export supports format retention, that is, the format of the data you see after export is the original format.

If the customer needs to preserve the data format when exporting to excel, the property export.datasheet.keepview = true needs to be configured in bi.properties, and the default system property value is false.

 

Echart Plug-ins Participating in Filtering Linkage, Pushing Alerts, and etc., Making the Analysis Experience More Excellent

•Echart plug-ins support filtering linkage with system built-in components.

When the built-in components perform brush or zoom operations, the echart plug-ins can be linked. But echart plug-ins do not support brush and zoom.

For the echart plug-ins with legend, click the legend item to filter the data bound to the plug-in, and link other components of the same data source in the dashboard when filtering.

•The time line chart and migration chart support the setting of the mark size to control the size of bubble mark or point mark.

•Plug-ins support viewing the detail data.

•Plug-ins support the alert function.  Alerts can be pushed to the target person when alert conditions are met.

 

Enhance the Ability to View Dashboards and Improve Self-Service Analysis Experience

When viewing a dashboard, you can modify the filter conditions and the dashboard format. These two operations, which are "Filter" and "Format", are added into "Actions"in V8.5.1.

The dashboard makers can enable the viewers to filter the dashboard data in View Mode by dragging the "Filter" action to "View Actions".

The dashboard makers can enable the viewers to amend the format of the dashboard in View Mode by dragging the "Format" action to "View Actions".

 

Optimize Visualization Performance and Speed up Loading

•Optimize map performance to speed up opening.

•Optimize the parsing logic of map data loading, loading it as needed instead of loading all the data at once, to improve the loading speed of the map component and increase the memory efficiency.

•Optimize dashboard loading performance to open the dashboard in shorter time.

•The new version optimizes dashboard loading logic, shortens dashboard execution time, and speeds up dashboard opening.

•Optimize the performance of favorites and sharing. The new version reconstructs the function of the favorites and sharing, greatly improving performance, and the experience would be very smooth.

 

Optimize Operating Experience and Facilitate Making Dashboards

•Parameter components realizes script-free visual submission.

•Optimize the filter components layout.

•Support changing the title location of filter components.

•Map components add rendering dynamic effects, displaying data loading and changing effects.

•Support setting the color of drop-down parameter components separately in dashboard theme.

 

4. Workflow

New Workflow Module Helping Enterprises to Approve Data Submitted to Database

The new workflow system satisfies the reporting and approval requirements of the enterprise, so that data reporting becomes safer and more reliable.

Workflow module is divided into two parts: workflow management and workflow application. The administrator sets the approval steps and persons in charge through Workflow management. After the process is completed, the workflow is released for use by specific business personnel. The staff submit application through the workflow. Once the workflow starts, the approval shall go on according to the workflow steps.

Workflow management permissions need to be configured in authentication and authorization. Only users with workflow management permission can make, modify, and delete workflows.

 

Process-Oriented Approval Procedure Not Only Saves Time and Effort, But Also Make Data More Reliable

The data filled and submitted are automatically transferred to the relevant responsible person for approval by the workflow engine, which not only ensures the correctness of data, but also saves time and effort.

When approving, the user can approve or reject the application. Approved data is automatically filled into the database (depending on whether the workflow maker let the data filled in the database table). Rejected applications return to the applicant, who can made a change and submit again(depending on whether the workflow marker allows changing and resubmit).

 

Visualized Operation Easily Customizing a Variety of Approval Processes

The workflow maker simply drags the nodes into the canvas and connects them with arrows, and easily gets a flow chart that shows the steps of the process.

 

Support Different Approval Paths

Yonghong workflow supports administrators to set conditions and follow different approval paths according to different conditions. For example, when the reimbursement amount is less than 5000 yuan, only manager approval is required, and when the reimbursement amount exceeds 5000 yuan, director approval is required in addition to manager approval. \

 

E-mail Reminder of To-do Task, and Get the Task Message in Time

When a user has a process to approve, he may receive an e-mail reminding him that a task needs to be approved.

 

5. Enterprise Management

Health Guardian, Intelligently Giving System Operation and Maintenance Suggestion

Yonghong Z-Suite adds a new health guardian module, which automatically collects the basic data of the system such as disk, RAM, and CPU, resource data about dashboards, data sets, scheduled tasks, and etc., as well as the behavior data such as user activities and dashboard accesses, so that administrators and operation and maintenance personnel can understand the current system operation status more clearly and troubleshoot more easily.

Users can also manually create a health check report, and Yonghong Z-Suite will give reasonable suggestions for optimization based on the system's current status.

Note: the health check depends on the monitoring system. For versions other than Z-Suite, you cannot use it even if you purchase a health check without purchasing the monitoring system.

 

Docking with SMS Platform to Receive Short Messages and Realize Dynamic Login

The new version docks with the Chuanglan SMS platform. You can use the functions related to the SMS, such as  dynamic login, retrieve the password by mobile, receive short messages (system messages, scheduled task messages, alerts, etc.), when you use the license with the authorization of the SMS platform module, and configure the account and password of the Chuanglan platform. Please refer to the SMS Platform Configuration Instructions for detailed configuration steps.

Note:

1.        To use the SMS function, you need to configure the area code and mobile phone number in User Management.

2.        If your company already has your own SMS platform (not Chuanglan platform), the system can also achieve docking, but requires certain customization development.

 

Optimization of LDAP User Password Mechanism

In the new version, LDAP users cannot change their passwords in the system, but only in the LDAP server. The relevant pages and logics have been optimized.

 

Authorization Editing Adds Inheritance Logic, Making Authorization More Convenient

In authorization editing, if a user/group/role is authorized to the parent resource, the user/group/role is automatically authorized to the child resources as well.

 

Docking with the DingTalk, Enabling Viewing Dashboards and Receiving Messages in DingTalk

The new application market provides Dingtalk plug-in which enables Yonghong to dock the DingTalk after installation.

You need to upload Yonghong E application to the DingTalk development background and complete relevant configuration in the system, so as to realize the functions of viewing dashboards and receiving messages in DingTalk. Please refer to the DingTalk Configuration Instructions for detailed configuration steps.

 

Yonghong System Integrated into WeChat Work Supports Single Sign-on

Yonghong Z-Suite V8.5 already supports receiving messages by WeChat Work, and the new version further optimizes WeChat Work integration and enables single sign-on. After synchronize and configure the contacts, and add Yonghong server address in the background of WeChat Work, you can view dashboards in WeChat Work. Please refer to the WeChat Work Configuration Instructions for detailed configuration steps.

Note: The WeChat Work integration application has been added to the application market, which needs to be installed before it can be used. It contains the application configuration and notification push configuration pages of enterprise WeChat in the system. If you have used this function in V8.5 and tend to update it to V8.5.1, you need to contact the business to reinstall the application.

 

Support Controlling the Number of Created or Executed Scheduled Tasks by Group

The user can configure the parameter job.concurrency.limit in bi.properties, whose default value is false. If the parameter is configured to true, the administrator can limit the maximum number of jobs created or running simultaneously by groups. When the number of jobs of the group users has reached the maximum value, the job cannot be created anymore. When the number of jobs in operation has reached the maximum value, the following jobs will not run immediately, but will enter the queue and wait to run. When any job completes, it will run in sequence.

If the admin does not set the job limit for a child group, it will inherit the job limit of its immediate parent group.

Note: The limit number needs to be less than license CPU cores, and in a multi-C load-balanced environment, the sum of the limit numbers of first-level groups should be less than the sum of the total number of CPU cores of all C nodes.

 

Interaction Optimization and Performance Improvement

•The performance of authorization configuration in multi-C environment is greatly improved;

•The alert system is on by default;

•Prompt when there are spaces in the Mac installation directory;

•Hide the console management module to non-C nodes;

•Login page based HTML5;

•Add several new apis for portals and complex dashboards;

•Support dependency analysis, dashboard alert, switching data location, permission control on reporting.

 

6. BIG DATA

Performance Optimization of Grouping and Aggregation under Big Data Volumes to Avoid Excessive Memory Consumption

Manage the memory used in the process of grouping calculation in data mart to avoid excessive memory consumption or even memory depletion when there is much grouping calculation.

 

Optimize Data Mart’s Communication Framework and IO Message Delivery, etc. to Enhance Stability

Reconstruct the mart communication and introduce netty framework to make the mart communication more stable and efficient.

 

Data Mart Supports Inverted Index for Improving Performance

Support inverted index to improve performance, and increase the efficiency of importing data to data mart, and querying data from data mart.

 

Support The Distributed Large Table Join of Mart Data, and Strengthen The Support for Self-Service Analysis Scenarios

In some self-service analysis scenarios, join of data to form a large table cannot be performed in advance and then import the joint table into data mart (for example, in some self-service scenario, whether to join tables and what fields function as associated columns are uncertain, and the original detail table needs to be retained for self-service query). And it does not meet the requirements for map side join (or broadcast join). Therefore, the version 8.5.1 supports to import data into the mart by fragments and join them then.

 

Optimize Data of Date Type in Data Mart to Improve Performance

For date type data, it is necessary to discretize the data during analysis. Users need to check the data of one month, or one quarter. If the date is continuous, the current usage mode is to build another date expression, but this calculation is actually unnecessary. And for mart data, this level of detail expression results in performance degradation by an order of magnitude.

For example, a SQL dataset (on which a corresponding date column is built) is imported into the mart. After that, the relevant date column is a common date type column. The data of the dashboard is already the query based on the mart data. In order to use the sequential comparison or parallel comparison calculation, the date column is again built on the query of the mart, resulting in slow performance.

In the version 851, the date column imported into the mart can be used directly to calculate the year-on-year ratio or month-on-month ratio without creating a new date column, and at the same time improve the use experience and calculation performance.

 

7. APP

Support Dynamic Login with Mobile Phone Verification Code

After connecting to the server, the user can choose Mobile Login on the login page. It supports multiple countries' mobile phone number. The user should enter the mobile phone number, click Send Verification Code, enter the obtained Verification Code and click Login.

 

Add "Mobile Number Verification" for Retrieving Password and Make Password Reset More Convenient

When the password is forgotten, the user can select the mobile phone number for verification. Enter the mobile phone number, click Send Verification Code, enter the obtained Verification Code and click Next to enter the Reset Password page.

 

Support Integration with DingTalk and WeChat Work

•Support the integration of mobile terminal products with enterprise third-party applications such as DingTalk and WeChat Work.

(1)        DingTalk: After purchasing the application at the application market, download and install it, then fill in the server address in the Manage System - Application Management - DingTalk Configuration, and download the application. Create an application in the DingTalk developer tool, upload the application code, and configure the attribute information of the application in the Manage System - Application Management - DingTalk Configuration. Upon completion, authorized users can access the Yonghong app directly in DingTalk.

(2)        Enterprise WeChat: After purchasing the application at the application market, download and install the application, and create the application in the third-party application of the enterprise WeChat users themselves. After creating the application, configure the attribute information of the application in the management system-enterprise application configuration-enterprise WeChat configuration. Authorized users can access the product directly on enterprise WeChat after the addition is complete.

•Receive system message through DingTalk and enterprise WeChat.

The user can receive push messages in DingTalk and enterprise WeChat, including system messages, scheduling task messages, early warning messages. Click Early Warning message to open the report directly.

Note: If the user needs to receive the early warning messages in DingTalk or enterprise WeChat, the user needs to select to push the message to the DingTalk or enterprise WeChat in the early warning setting.

In DingTalk or enterprise WeChat, reports can be shared with DingTalk users or enterprise WeChat users.

 

Optimize IPAD client side and mobile phone WAP end to improve IPAD operation experience

•Optimize the IPAD home page presentation.

•Filter components and parameter components are more adaptable to the IPAD client side and are more user-friendly.

•Add APP download and installation tips on the Wap side.

•Add collection and sharing functions on the Wap side, and support log out status.

 

 

❖New Features List

1. Self-Service Data Preparation

 

2. Advanced Analysis

 

3. Dashboard

 

4. Workflow

 

4. Enterprise Management

 

5. App

 

6. Big Data