This is one of 4620 IT projects that we have successfully completed with our customers.How can we support you?
Feasibility analysis of automated cube processing in MS Analysis Services
Project duration: 20 days
Brief description
The controlling information system compares the costs and revenues that accrue for a unit supplied with energy. Data Warehouse (DWH) provides the basis for standard reports that are created periodically by the controlling department. The cubes required here are operated on Microsoft SQL Server Analysis Services and loaded with data from the DWH DB. Due to the need for a more tightly clocked load process, a feasibility analysis is performed for cube processing and a prototype is implemented.
Supplement
The requirements exceed simple, automated cube processing and have an impact on the choice of a suitable method. With regard to the automation, attention is paid to the fact that there are different types of cubes and datasets with different currentness and characteristics are loaded to each. In addition, a switch mode is implemented to keep both an active and a passive cube. For cubes with an archive dataset, the management process is modified and optimized. The processing is implemented with the .Net Framework Assemblies (Analysis Management Objects (AMO)) in PowerShell scripts. The scripts are executed in SQL Server Management Studio by the SQL Agent Jobs.
Subject description
To satisfy the requirements for further development of the cubes and for the availability of the different datasets, a suitable and flexible procedure is implemented for cube processing. An automated process minimizes the administrative effort and reduces the memory required for the archive cubes.
Overview
- Industries energy
- Specialist tasks data warehouse, software development
- DV tasks Data Warehouse
- System environment Business Intelligence, technical data processing
- Procedure model customer standard
- Databases MS SQL Server
Project period28.08.2015 - 17.09.2015
Have we sparked your interest?
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
