Export dashboard

1.1 Version

1.2 Application scenario

FineBI's export feature can be used when users need to export dashboards to save data and charts for some other processing or reporting purposes.

Component export can be found in the document: Component Export to Excel.

1.3 Function introduction

Dashboards can be exported by mounting them in a directory or in the dashboard editing screen. Data analysis dashboards can optionally be exported to Excel or PDF.

• Export after mounting to a directory. Non-admin users need to enable directory export permission by the administrator to export the dashboard. As shown in the figure below.
  

• Export directly from the dashboard edit/preview page, as shown below.

2.1 Operation steps

1）Click "Export > Export Excel" to generate the file. As shown in the figure below.

2）Save the downloaded Excel file.

2.2 Excel file

When you select Export Excel, an Excel file is generated, which supports exporting the entire data analysis dashboard preview screen to Excel. The number of sheets included in the exported Excel is related to the number of components, generally, the sheet name is the corresponding component name. For example, if the above dashboard contains two components, the exported Excel will contain three sheets: 

1) Excel data of table component 

2) Excel data of chart component 

3) Dashboard page.

Note: When exporting Excel globally for multiple Tab components, the components need to be exported separately by the number of tab pages, and the export name is Tab component name - tab page name.

2.2.1 Table Components Excel Data

The table component is exported as it is displayed after expanding all dimension nodes. It also includes the theme color and column width set by the component. Users can further process the exported Excel data for other uses, such as aggregation, as shown in the figure below.

2.2.2 Chart Components Excel Data

The aggregated results of the chart component, aggregated by all dimensions in the component, are exported and stored in a detailed form, as shown in the following figure.

2.2.3 Dashboard page

The "Dashboard" page will include graphical effects for each component, and the layout will be exactly the same as the corresponding layout on the PC side. If various filtering components are used in the interface, the corresponding export will also receive the corresponding filtering effects of the components. That is, the exported content is consistent with the analysis results viewed by the current user. As shown in the figure below.

2.3 Order of Excel file export

Export components in the overall dashboard page from left to right, from high to low.

3.1 Operation steps

1）Select "Export>Export Pdf", as shown below.

2）Save the generated PDF file.

3.2 PDF file

The exported PDF will only show the overall effect of the dashboard interface. The position of each component on the interface, such as charts, will be displayed exactly according to the layout on the PC side, while the corresponding components and other filtering conditions will also be exported. That is, the exported effect is the user in the PC side to see the data and graphics corresponding effect. The following figure shows.

4.1 No export permission

Problem Description

In a Linux environment, the user does not have template authentication on, and when SuperManager exports Excel, it prompts: No export privileges.

Cause Analysis

Under Linux, the native jvm x-server support is required for image processing, and the option -Djava.awt.headless=true should be added to the startup command.

Solution

See Section 5.1 in Modifying FineBI Configuration Parameters.

4.2 Export loading images

Promblem description

Export when not fully loaded, export loading status image.

Cause Analysis

The template can be PDF exported before the data is loaded, but the export is the image of the loading state.

4.3 Public links do not support export

The public links feature does not have Save As and Export functions.

4.4 Export Excel error, export as error

Problem Description

Export error：java.lang.NullPointerException at sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264)

Cause Analysis

No fonts installed, environmental issues.

Solution

Execute the command yum install fontconfig directly in the linux environment, and then restart the linux system.

4.5 Special characters exported will become underscored

Problem Description

When exporting Excel or pdf when the template name contains special characters, the special characters in the exported file name will become underscores.

Cause Analysis

Because the browser does not support special character file names for downloading files.

4.6 Export error, indicating that the travel limit is exceeded. 1000000

Problem Description

Can preview, export error, prompt out of row restriction: 1000000 .

Cause Analysis

The amount of data has actually exceeded the limit, but the preview is going to the paging engine, so the preview is normal.

But the export is all data, the underlying engine is still limited.

4.7 Cluster without export privileges

Problem Description

Projects cannot be exported and scheduled.

Cause Analysis

The environment is missing export parameters.

Solution

Reference document configuration parameters: Tomcat server deployment

4.8 Export from error

Problem Description

The detail table is exported as null.json

Cause Analysis

The system is not registered or the number of visitors exceeds the registration limit number will affect the export.

4.9 Exported "null" text file

Problem Description

Global export Excel, exported "null" text file.

Cause Analysis

There is a problem with the "BI Template Export" plug-in used.

Solution

Download and use the latest export plugin.

4.10 No permission to export large data volume schedules

Problem Description

Schedule export shows no permission.

Cause Analysis

The customer's data is 1.07 million large data, and set the server network level to limit the response time of 20 s. The time to export this detail table this dashboard is 2 and a half minutes, which is greater than the response time, resulting in no permission to export.

Solution

Lifts the response time limit.

4.11 Google Chrome detail sheet export Excel failed

Problem Description

Google Chrome detail export to Excel fails, keeps spinning in a circle. When I access the project environment with Google Chrome, the export is normal for a small amount of data, but the export fails for 200,000 pieces of data, and it keeps spinning in a circle.

Cause Analysis

Problems with Google Chrome

Solution

Switch the Google Chrome browser to export in no-trace mode, or reinstall Google Chrome to export

4.12 An exclamation point appears after Excel export

Problem Description

Using the Kyligence Enterprise Edition database, an exclamation point appears on the exported Excel, as shown below.

Cause Analysis

There is a space at the end of the data field.

Solution

Removes spaces from field data in the Kyligence database.

4.13 Very slow export

Problem Description

Exporting the dashboard is very slow, but eventually it can be exported successfully.

Cause Analysis

This may be caused by the use of the nashron environment export.

Solution

It is recommended to use J2V8 as the JS runtime environment when exporting. If you still use Nashron environment to export BI dashboards, you may have slow export speed problems. For Linux systems it is recommended to upgrade gcc.