SAP smp-a neglected SAP data warehouse
(This is the first blog published by Xu Kun.Http://blog.xukun.com/)
It is often heard on various occasions, or even complained by customers in person.SAPBefore providingTechnical materialsIt's too tricky.N + nAfter that, I finally thought it would be more appropriate to wri
The following content is taken from the Internet and sorted out.
Terms:
Bi (Business Intelligence): Business Intelligence,
DW (data warehouse): Data Warehouse. For details, see section Q1.
OLTP (on-line transaction processing): Online Transaction Processing
It is also known as a transaction-oriented processing syste
warehouse (usually called data mart) according to the data coverage scope ).(3) OLAP (On Line Analytical Processing) server effectively integrates the data required for analysis and organizes the data according to multi-dimensional models for multi-angle and multi-level ana
task of data Warehouse is to organize, summarize and reorganize the information and provide it to the corresponding management decision-maker in time.Q2: Why build a Data warehouse?The enterprise establishes the Data warehouse to
The following content is taken from the Internet and sorted out.
Terms:
Bi (Business Intelligence): Business Intelligence,
DW (data warehouse): Data Warehouse. For details, see section Q1.
OLTP (on-line transaction processing): Online Transaction Processing
It is also known as a transaction-oriented processing syste
Basic concepts:
1. Multi-dimensional dataset: a multi-dimensional dataset is the main object in Online Analytical Processing (OLAP) and a technology that allows quick access to data in a data warehouse. A multi-dimensional dataset is a collection of data. It is usually cons
settings will also become simple and efficient, and the original "Pyramid" organizational structure will become a "flat" organizational structure. There is no doubt that the above advantages will allow enterprises that successfully implement ERP to gain great advantages in the fierce market competition. Specifically, this will reduce costs, increase the efficiency of capital utilization, provide accurate data for decision-making, and reduce opportuni
This paper gives the basic concept of SQL Server Data Warehouse, and uses the example construction process to analyze, for everyone's reference!
Basic concepts:
1. Cubes: Cubes are the primary object of online analytical processing (OLAP) and are a technology that allows fast access to data in a
1. The concept of Data Warehouse began in the 1980s S and first appeared in the book William H. Inmon, known as "the father of Data Warehouse. With
Profound recognition and continuous improvement in system research, management, and maintenance. After summing up, enriching, and integrating the experience of multi-row en
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.