Intro
In the context of a number of recent enhancements, we thought it is worthwhile to write up a brief summary of the Tabular model services available within the Abylon Rapid Platform and highlight how they support development, processing and logging.
Development
First of all, during development, tabular models can be deployed to any number of environments just like ETL processes, databases, reports (etc.). There is no need to rewrite the connections every time you move to a live environment, the platforms will do it for you after setting up the appropriate parameters. It also provides the possibility to publish user-level self-service models to a productive environment.
The developer’s life is made much easier by automating the creation of dynamic measure tables. Dynamic measure is useful for any business, but the creation and maintenance of the necessary tables and measures is time-consuming and sensitive to changes. Abylon Rapid Analytics takes this burden off the developer’s shoulders. It also makes it easy to produce measures based on selected measures such as LY, MTD, ALL, etc. based on calculation groups.
Processing
Our execution plan manager allows the usage of several OLAP processing steps in each execution plan item. Such as:
- Full process, this is obvious
- Dynamic partitioning, code-driven version: dynamic partitioning creates the partitions according to the configuration and processes the appropriate number. Main features: rolling window, incremental partitioning, incremental processing, fix interval.
- Dynamic partitioning, data mart-driven: the data market developer has the possibility to create his own stored procedure, which passes the processing and creation command to the framework.
Logging
- Metadata backup: main data of SSAS tabular models installed on environments, up to the query level of partitions.
- SSAS instance monitoring: load, queries monitoring with Platform Planning functionality.
This is just a short teaser because this list could go on and on. We believe that, as with the whole Rapid Platform, in this case our strengths lies in the convenience of the ready-made solution, the cost-effective customization and the fast, customer-oriented development.
The available features do not set a mandatory direction, but provide opportunities, and the developments made during implementation help to fully meet the needs of our customers and provide support and good foundation for further BI development projects.
