One of the major challenges Business Intelligence (BI) customers face today is the integration of different source systems in one Enterprise Data Warehouse landscape. Not only different heterogeneous technical platforms must be interfaced, but also different master and transaction data semantics must be consolidated. In addition, an Enterprise Data Warehouse must provide flexible structures and layers in order to adapt quickly to new business challenges (such as changed objectives, mergers, acquisitions, etc.) Beyond these designtime aspects, Enterprise Data Warehousing should facilitate the administration and monitoring of all processes (such as load processes, distribution of data etc.) and proactively help coping possible performance issues – especially regarding increasingly sophisticated data volume requirements.
The IT scenario Enterprise data warehousing (EDW) enables customers to create and operate a data warehouse in an enterprise-wide environment. It combines strategic analyses and operational reporting, enables the business to report real-time, integrates heterogeneous systems and facilitates designtime as well as runtime of BI models and processes.
EDW covers all steps an administrator requires to set up a highly flexible, reliable, robust and scalable BI solution and easily administrate it.
Scenario Variants:
- Modeling the enterprise data warehouse
Describes processes like data modeling, data acquisition, data cleansing/transformation, data distribution and meta data & document management.
- Running the enterprise data warehouse
Describes processes like controlling the data flow, administration and monitoring, performance optimization (including BI accelerator), information lifecycle management and user management (authorizations).
Here is a list of the most important new capabilities; for further information, please refer to the IT scenario overview:
- BI accelerator
Boosts query performance by orders of magnitude and cuts off administration costs
- Admin Cockpit
Provides overview on BI processes (data load and queries) at one glance
- New data flow
New data flow design capabilities such as transformation and DTP supply additional flexibility and performance
- New analysis authorization concept
The new authorizations concept provides additional flexibility and improves transparency
- Real-time data acquisition
Enables operational reporting by providing information in real-time
