FineBI Template Performance

  • Last update: 2026-09-24
  • Overview

    Version

    FineOps Version
    Functional Change
    V2.15.0/
    V2.33.01. Renamed the original Template Performance tab Business Performance.

    2. Separated FineReport Template Performance and FineBI Template Performance.

    V2.34.0

    1. Optimized the Performance Setting configuration by separating business types.

    2. Expanded performance observation indicators to help you fully understand template access and performance status.

    V2.36.0Adjusted the detailed indicators for FineBI template performance and aligned indicator definitions with dashboard calculation logic.
    V2.38.0Supported automatic redirection with parameters during performance troubleshooting to improve troubleshooting efficiency.

    Application Scenario

    The FineBI Template Performance function is one of the business performance monitoring capabilities provided by FineOps.

    It helps you fully understand the access and performance status of FineBI dashboards, quickly locate performance bottlenecks, and reduce troubleshooting costs.

    Prerequisites

    1. Check the function scope.

    This function applies only to FineBI dashboards accessed from desktops.

    To use this function, the FineBI version must be either FineBI V6.1.9 to V6.1.x or V7.0.8 and later.

    2. Ensure Tracing has been enabled.

    Before using this function, make sure link tracing has been enabled. For details, see Prerequisites for Using Tracing.

    3. Ensure Performance Setting has been configured. 

    Log in to FineOps as the admin, select the target project, choose Health Inspection > Business Performance, and click Performance Setting in the upper-right corner.

    Click FineBI Template Performance, configure the FineBI template performance settings of the project, and click Save to complete the configuration.

    Setting Item
    Description
    Data Refresh TimeSet the execution time for aggregating and calculating data at the default interval every day. The default value is 2:00 AM.
    Default Displayed FieldSelect the fields displayed by default in the overview table and detail table in FineBI Template Performance. This setting applies after page refresh.
    Slow Query Threshold

    Requests that exceed the set value are counted as slow requests.

    The default value is 10,000 ms. This item is required, must be an integer, and must be at least 1,000 ms.

    Function Entry

    1. Log in to FineOps as the admin, enter the target managed project, and choose Health Inspection > Business Performance.

    2. On the Business Performance page, select FineBI Template Performance from the drop-down list to switch to the corresponding monitoring module.

    Performance Overview

    The performance overview page includes the Performance Overview Chart and Performance  Overview Table sections, providing a global view of FineBI dashboard access.

    Configuring Query Conditions

    1. Set display fields.

    On the overview page, click Display Field in the upper-right corner and select the dimensions and indicators to be displayed. This setting takes effect on the drill-down details of the overview chart and the overview table.

    Dimension/Indicator
    Description
    Template PathFull path of the dashboard in the user's analysis
    Template NameDashboard name
    Directory NameName of the platform directory to which the dashboard is mounted
    Template Publication Status
    Published, Unpublished, or Pending Approval
    CreatorDashboard creator
    Template ID

    Dashboard ID

    Last Usage TimeTime when the dashboard was last accessed
    Optimization SuggestionDashboard issues identified by FineOps and suggested optimization directions
    Access Count
    Number of dashboard operations, including preview, edit, and export operations
    Access User CountNumber of users who access dashboards, including preview, edit, and export operations
    Average FMP

    First Meaningful Paint (FMP) indicates the duration from when a user opens a dashboard to when the visible area of the dashboard finishes loading and becomes interactive.

    The average loading time indicates the average FMP of the dashboard.

    Median FMP

    Median FMP of the dashboard

    Maximum FMP

    Maximum FMP of the dashboard

    Total Slow Query Count

    A slow query is a request whose duration exceeds the value of Slow Query Threshold in the "Prerequisites" section.

    This field displays the total number of slow queries.

    Slow Query Ratio

    Total slow queries/Total queries

    Table Component CountNumber of table components in the dashboard
    Chart Component CountNumber of chart components in the dashboard
    Filter Component CountNumber of filter components in the dashboard

    2. Filter dashboards.

    Click Filter to filter the FineBI dashboards in the overview chart and overview table.

    Queries time out after 60 seconds. If a query times out, the query fails, and a message indicating a performance query timeout appears. Narrow the query scope and try again.

    Filter Item
    Description
    Time Range

    Filters FineBI dashboards by access time.

    • The default setting is Last 24 Hours. You can switch to Last 7 Days, Last 30 Days, Last 90 Days, or Custom.

    • Custom interval query results are cached and continue to be displayed until the next query. The time range of the last query is displayed to help avoid duplicate queries.

    • The retention period of business data is 5 days by default. To adjust it, see Prerequisites for Using Tracing.

    Access UserFilters users who access dashboards by username.
    Template ID

    Filters dashboards by dashboard ID.

    Template NameFilters dashboards by dashboard name.
    Template Publication StatusFilters dashboards by publication status. The statuses include Published, Unpublished, and Pending Approval.
    Directory NameFilters dashboards by directory name.
    Template ScopeFilters dashboards by full path.
    Average FMP

    Filters dashboards by average FMP.

    Slow Query Count

    Filters dashboards by slow query count.

    Performance Overview Chart

    The overview chart visually displays template access in charts, including the following three charts.

    Chart Type
    Description
    Top N by Access Count

    It displays FineBI dashboards with the highest access volume in descending order in a column chart.

    The x-axis shows the access count, and the y-axis shows the template name. You can scroll to view all resources.

    Click the corresponding column to go to the Detail tab page in FineBI Template Performance.

    Duration DistributionIt displays all FineBI dashboards by Access Count and Average FMP, helping you quickly locate high-access and high-latency dashboards.

    The x-axis shows the access count, and the y-axis shows the average FMP (ms).

    Click the corresponding scatter point to go to the Detail tab page in FineBI Template Performance.

    Overall Access Trend

    It displays the trends of the overall average FMP and total access count of the system within the selected time range to help identify the inflection point where performance deteriorates.

    The x-axis shows dates, and the y-axis shows the average FMP and total access count.

    Click a data point to go to the Detail tab page in FineBI Template Performance.

    result (14).png

    Performance Overview Table

    The overview table displays performance indicators aggregated by template ID.

    1. View details of a single template.

    Click the Template ID link of a template. The system passes the template ID in the row, the access user, and the queried time range of the current overview page to the Detail tab page in FineBI Template Performance and automatically triggers a query.

    Optimization suggestions include the following items.

    ItemMeaning
    No optimization is needed.

    Slow query ratio ≤ 0.2

    You are advised to reduce the total number of components.Number of table components and chart components > 30
    You are advised to reduce the number of chart componentsNumber of chart components > 6

    2. Export data.

    Click the  icon to export the data displayed on the current page as an Excel file to the local device for offline analysis and archiving.

    • The maximum number of exported rows is 1,000,000. If the limit is exceeded, only the first 1,000,000 rows are exported. If the data volume is too large, you are advised to narrow the time range and export data in batches.

    • The export timeout limit is 5 minutes. If the export times out, the message "Export timeout. Reduce the data range." appears. You are advised to narrow the time range or reduce filter items and execute the export again.

    Performance Details

    Each row in the detail table displays one access record of a template.

    Configuring Query Conditions

    1. Set display fields.

    On the Detail tab page, click Display Field in the upper-right corner and select the dimensions and indicators to be displayed. This setting takes effect on the detail table.

    Dimension/Indicator
    Description
    Access TimeTime when a user accesses the dashboard
    Access UserName of the user who accesses the dashboard
    Template PathFull path of the dashboard in the user's analysis
    Template IDDashboard ID
    Template NameDashboard name
    Session ID
    ID of this access session
    Access TypePreview, Edit, and Export
    Version TimeVersion of the project when the dashboard is accessed
    Cluster IDID of the cluster when the dashboard is accessed
    First Meaningful Paint

    The duration from when a user opens a dashboard to when the visible area of the dashboard finishes loading and becomes interactive

    First Contentful PaintThe duration from when a user opens the dashboard to when the first content is rendered
    Slow Query Count

    Total number of slow queries

    A slow query is a request whose duration exceeds the value of Slow Query Threshold in the "Prerequisites" section.

    Failed Query CountNumber of failed query requests 

    2. Filter dashboards.

    Click Filter to filter the FineBI dashboards in the detail table.

    Queries time out after 60 seconds. If a query times out, the query fails, and a message indicating a performance query timeout appears. Narrow the query scope and try again.

    Filter Item
    Description
    Time Range

    Filters FineBI dashboards by access time.

    • The default setting is Last 24 Hours. You can switch to Last 7 Days, Last 30 Days, Last 90 Days, or Custom.

    • Custom interval query results are cached and continue to be displayed until the next query. The time range of the last query is displayed to help avoid duplicate queries.

    • The retention period of business data is 5 days by default. To adjust it, see Prerequisites for Using Tracing.

    Access UserFilters users who access dashboards by username.
    Template ID

    Filters dashboards by dashboard ID.

    Template NameFilters dashboards by dashboard name.
    Session IDFilters dashboards by session ID.
    Access typeFilters dashboards by access type.
    First Meaningful PaintFilters dashboards by FMP.
    Slow Query Count

    Filters dashboards by slow query count.

    Failed Query Count

    Filters dashboards by failed query count.


    Detail Table

    The following redirection operations are available in the performance detail table.

    Entry
    Target and Parameter
    Session IDYou are redirected to the Detail tab page in FineBI Component Performance, where this session ID is passed, and the query time range is extended by 10 minutes before and after the access time. You can view all component queries triggered by this access.
    Access TrendYou are redirected to the Overview tab page in FineBI Template Performance,  where the template ID in the row is passed, and the query time range is set to Last 7 Days. You can determine whether the issue occurs occasionally or continuously.
    First-Screen TraceYou are redirected to the First-Screen Trace tab page, where the first-screen trace details of this access are displayed.
    TraceYou are redirected to the Trace tab page, where the trace details of this access are displayed.

    Click the  icon to export the data displayed on the current page as an Excel file to the local device for offline analysis and archiving.

    • The maximum number of exported rows is 1,000,000. If the limit is exceeded, only the first 1,000,000 rows are exported. If the data volume is too large, you are advised to narrow the time range and export data in batches.

    • The export timeout limit is 5 minutes. If the export times out, the message "Export timeout. Reduce the data range." appears. You are advised to narrow the time range or reduce filter items and execute the export again.




    Attachment List


    Theme: Project Management
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy