Dashboards and Reporting

ASM uses the Syncfusion Dashboard Platform for dashboards/wallboards and reporting. You are free, however to use the tool of your choice while still leveraging the many table views shipped with ASM.

Applies to: Versions below ASM 10.6.8.15038

ASM Version 10, embedded Dashboarding and Reporting functionality is provided through the Syncfusion Dashboard Platform.

Alemba uses the latest version of the Syncfusion Dashboard Platform v4.1.0.84.

From September 2022, the Syncfusion Dashboard Platform entered the Extended Support phase of its product lifecycle with a published end of support in September 2024.

Alemba is a Premium Support partner with Syncfusion and support has been extended until customers migrate to Syncfusion's Bold BI Platform.

ASM Hermes 10.6.8 DEC 24 MR (15038): Support has been added to embed Bold BI as part of the updated Analytics System Administration.

Ad-Hoc DB/Table Views for Reporting and Dashboards

ASM ships with numerous table views already configured. If you find you need one that is not already included, you can create them right from ASM Core through the Search Results screens.

ASM allows export of search results as custom views that you can use for reporting in ASM or the tool of your choice. For more information, please see: Exporting Table Views or contact Alemba Support.

Best Practices for Using Views for Reporting

Using views for reporting, instead of accessing the database directly, offers numerous advantages including improved performance, better security, and easier maintenance. Here are the best practices for leveraging views in your reporting strategy:

• Optimize Performance: Custom views can aggregate and present data in a manner that's directly useful for reporting, reducing the need for complex queries at report generation time. This leads to faster report generation.

• Enhance Security: Views can serve as a security mechanism by restricting access to underlying tables and sensitive data. Only expose necessary data in views to ensure users only see what they need.

• Maintainability: Changes to the database schema can break reports that access tables directly. Using views abstracts the underlying table structures, making your reports more resilient to changes.

• Consistency: Using views ensures that all reports are based on the same business logic and calculations, providing a single source of truth across the organization.

• Simplify Complex Queries: Complex logic and calculations can be encapsulated within views, making it easier to write and understand the reports that rely on them.

For implementing these practices, it's advised to collaborate with your database administrators and BI developers to ensure views are optimized and aligned with business requirements.

Access to the full online library of capabilities, documentation and how-to information can be found here:

Overview - Syncfusion Dashboard Platform | Syncfusion.comhelp.syncfusion.com