Yonyou BQ business intelligence platform-chart Function

UFIDA Bq
Business Intelligence platform-chart Function

 

Overview

Yonyou
BQ
The chart function of the business intelligence platform consists of two parts.

I,
Excel
Chart Function

Yonyou
BQ
Business Intelligence platform and
Microsoft Excel
Is completely seamless integration, so,
Microsoft Excel
The Statistical Chart function in
UF report
7.0
And the chart design method is also
Microsoft Excel
Similarly, if you have personalized requirements or require statistical charts that exceed the scope of this document, you can directly refer
Microsoft Excel
To help you Design charts. At the same time, the chart type depends on the userInstall


Of
Microsoft Office
Software


.

II,
EIS
Chart Function

EIS (
Decision Information System
):
Is the latest query that can be executed by clicking a buttonDatabase


Because
EIS
You can view and analyze the associated queries and various report files on the same interface, and the reports are also associated.
EIS
This makes it easier for end users to access information.

In yonyou
BQ
In the business intelligence platform,
Excel
The chart functions mainly include three-dimensional bar chart and pie chart, dual-axis line chart, amount trend chart, columnar stacked chart, and radar chart.
EIS
The chart function includes map, funnel chart, spine chart, column chart, and line chart,
Pie
Shape chart, ring chart, area chart,
Vista
Table,
Bevel
Tables, composite charts, cellular charts, dashboards, and other chart types.

Excel
The chart function is not covered in this article.

 

Procedure

1
The examples in this article are based on the previous data table field statistics and linked to relevant detail fields.

2
Create a smart query, mainly for the field statistics of a table. This smart query is named field statistics.
SQL



As follows:

Select Table_name, count (*) Fieldnumber, sum (data_length) fieldlength, Sum (decode (nullable, 'n', 1, 0 )) Nonnullcolumn, Sum (decode (nullable, 'y', 1, 0 )) Nullcolumn From User_tab_cols Where table_name Like 'center _ tbl_question %' Group Table_name

3
For convenience, we directly use
SQL
And rename the related data columns.

4
And create a new smart query, mainly the detailed field description of a table. This smart query is named as field details, and the related data column name is also renamed.

Select Table_name, column_name, data_type, Data_length, data_precision, nullable, column_id From SYS. user_tab_cols Order Table_name, column_id

5
, Create a table name parameter, directly use
SQL
Method

Select distinct {TT}. SYS. user_tab_cols.table_name From {TT}. SYS. user_tab_cols Where {TT}. SYS. user_tab_cols.table_name like 'Center _ tbl_question %'

6
The final two smart queries are as follows:

7
, Create a form to start
EIS
Report design.

8
Drag field statistics and field details to the form, and click Yes

9
, Select Insert chart on the shortcut button

The main attributes of the chart are described as follows:

Binddataset:
Bound query object

Bindenvvar:
The parameter to be passed when the link is bound,
In this example, click different data tables,
Detailed Table Structure linked to the table.
Therefore, the parameter passed is the table name.

Linkto:
Target object linked

Axiscolumn:
Column name corresponding to the chart

Seriescolumns:
Values of columns corresponding to each block

Charttype:
Select the chart type. The funnel chart type is "13-funnel ".
".

Sytle:
Select the style of the corresponding chart type, such as 2D and 3D Vista.
And so on

10
Right-click the attribute page in the chart and set the bound dataset,
X/y
Related Fields of the axis and bind query variables.

11
, Right-click "Link", we can see all objects in the system shared area, here we select field details.

12
, And then view the related properties of the chart control again.

13
, After we refresh the data, you can see

14
Click the relevant table name to open the field details of the corresponding table.

Summary

Yonyou
BQ
The business intelligence platform provides
Excel
And
EIS
A large number of chart functions to meet the needs of information decision-making support. The diversified data analysis results are displayed on a single platform. Its powerful analysis function is used to send key data to decision makers without the needProgramming


Complex
EIS
Display.

Other chart production methods are very similar to the pie chart. They are based on space limitations and are not repeated again.