Yonyou BQ business intelligence platform-chart Function

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.