Leica Camera.
Among other things, Leica Camera uses Bissantz to prepare the monthly financial statements, daily evaluations and perform ad hoc analyses. A proprietary data warehouse with SAP data was set up for this purpose.
qick-win the initial application for analyzing Access data
data warehouse with Microsoft SQL Server to analyze SAP data with the help of automated ETL
daily and monthly reporting, changes in inventory
status of order processing in production
sales reporting and sales planning
SAP data in focus.
Data Warehousing at Leica Camera.
BARC reports on how the project was implemented in its three-part case study „Efficient analysis of SAP data with Bissantz“. The Würzburg-based analysis and consulting firm examined the Bissantz solutions for SAP data at various companies, including Leica Camera AG.
„Together with Bissantz, a data warehouse was set up with Microsoft SQL Server on a virtual machine. SAP data is loaded overnight using SSIS procedures. The data warehouse corresponds to a classic architecture: first, unmodified data is loaded into a staging area, where it is transformed and loaded into further layers.
The data warehouse follows a stable architecture: first, the unmodified data is loaded into a staging area, where it is transformed and loaded into further layers. DeltaMaster ETL is used for the data modeling of relational models and hierarchies. This structure of the data warehouse enables efficient use of SAP data in combination with other data sources, for example with data from subsidiaries that do not use SAP. These subsidiaries usually input data into the data warehouse manually by providing data as files via data export.“
You can find the complete report in the case study.