Dashboards and Reporting

ASM uses Syncfusion 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.

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

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.

Last updated

Was this helpful?