CN111444283A - Method for calculating SAP BW4 by using SAP HANA - Google Patents
Method for calculating SAP BW4 by using SAP HANA Download PDFInfo
- Publication number
- CN111444283A CN111444283A CN202010416990.2A CN202010416990A CN111444283A CN 111444283 A CN111444283 A CN 111444283A CN 202010416990 A CN202010416990 A CN 202010416990A CN 111444283 A CN111444283 A CN 111444283A
- Authority
- CN
- China
- Prior art keywords
- data
- hana
- sap
- adso
- real
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for calculating SAP HANA citation SAP BW4, which comprises the following steps of extracting data from an SAP HANA source database, extracting required data from the HANA source database by utilizing a HANA S L T data synchronization mechanism, carrying out conversion logic processing on the extracted data in SAP BW4, selecting a required data table as a data source, establishing conversion for ADSO, writing AMDP routine codes in ADSO conversion by using tables required by other service requirement logics as virtual tables, storing the processed data in BW4 in BW4 as a timing task, carrying out a processing chain timing task for DTP of ADSO, automatically updating the data for the model in a specified time system, synchronously displaying the processed activity data quoted and stored in SAP HANA and other required real-time data in the HANA database, utilizing better data loading performance of BW4, carrying out more favorable optimization on the HANA model, and greatly improving the running time of the HANA model.
Description
Technical Field
The invention belongs to the technical field of computers, and particularly relates to a method for calculating SAP BW4 by utilizing SAP HANA.
Background
The SAP HANA database is a set of memory database formed by combining software and hardware developed by SAP company, uses a memory as a database, adopts column type storage (more suitable for data compression and calculation), directly executes all related operations of the database in the memory, and omits performance influence caused by I/O interaction compared with the traditional database, so that the execution efficiency is high, and the execution speed of SQ L is improved by hundreds of times.
The SAP HANA platform model has the running time not exceeding 10 seconds, otherwise, the SAP HANA platform model has the influence on the efficiency of front-end application display and seriously influences the experience of users, but under the conditions of large data volume and complicated business requirement logic (for example, when the annual data total amount of MKPF and MSEG tables in ERP exceeds 20 hundred million), the HANA model has the running time of more than 1 minute when the two tables are subjected to correlation calculation. If other tables are needed to be correlated for operation, the running time is far more than 1 minute, which causes that when the front end user uses the system, the front end user needs to wait for more than 1 minute to have response.
In view of this, the simplest and most efficient optimization method which is currently most widely used is to reduce the amount of data, although this method is basically of no technical content, but only an order of magnitude reduction. Theoretically alone, there is no need for optimization of HANA, and the efficiency of HANA operation is not a concern as long as resources are sufficient. However, such a viewpoint is not recognized from a technical point of view.
Disclosure of Invention
The invention aims to provide a method for calculating SAP HANA by referring to SAP BW4, and aims to optimize a HANA model more favorably by using better data loading performance of BW4 under the conditions that SAP HANA model requires large data and service requirement logic is complex, and part of logic data can be divided into real time and non-real time, and greatly improve the operation time of the HANA model.
The purpose of the invention is realized by the following technical scheme:
a method of SAP HANA referencing SAP BW4 calculation, the method comprising the steps of:
s1, extracting data from the SAP HANA source database, namely extracting required data from the HANA source database by utilizing a HANA S L T data synchronization mechanism;
s2, performing conversion logic processing on the extracted data in SAP BW 4: selecting a demand data table as a data source, creating conversion for ADSO, and writing an AMDP routine code in the ADSO conversion by using tables required by other service demand logics as virtual tables;
s3, storing the processed data in BW4 in BW4 as a timing task: performing a processing chain timing task for the DTP of the ADSO, and automatically updating data for the model by a system at a specified time;
and S4, synchronously displaying the activity data which is referred and processed in the SAP HANA and other required real-time data in the HANA database.
Since BW4 belongs to the same database as HANA, data in the HANA database can also be processed in BW 4.
The conversion logic process creates ADSO in BW4, selects a main requirement data table as a data source, creates conversion for the ADSO, selects tables required by other service requirement logics as virtual tables, writes AMDP routine codes in the ADSO conversion, wherein the AMDP codes can be selected from ABAP codes and HANA SQ L syntax, the SQ L syntax has better operation performance than the ABAP codes in BW4 in terms of data processing degree, the HANA SQ L syntax is usually selected to complete the AMDP codes, then sets full extraction packet uploading data for DTP creation of the ADSO, and finally the result data is non-real-time required data, and in the step, the ADSO model needs to generate External SAP HANAVIew for reference in HANA modeling.
The timing task refers to a processing chain timing task for the DTP of the ADSO in BW4, the system automatically updates data for the model at the specified time, and the DTP data loading mode mainly comprises: if the new data is updated, incremental extraction is set to accumulate and load the new data, and if all data needs to be updated, full extraction is set to update all data; and finally, storing the latest loaded data in the ADSO.
The non-real-time and multi-data logic complex part utilizes BW4 to calculate based on an HANA memory database, a mechanism that most of front-end data analysis, data management and possibly related planning functions are sunk into HANA is carried out, data in BW4 are packaged and uploaded in rows, the data are uploaded in BW4 and are completely stored in ADSO as active data, the generated ADSO active table and the HANA database required table are output in the same view through table main keys JOIN through HANA modeling, the step greatly optimizes the requirement result of synchronous display of real-time and non-real-time data in an HANA platform creation model due to the use of an ERP large table and the unaffected data loading time, and can enable the HANA model to obtain obvious performance improvement.
The invention has the beneficial effects that: under the conditions that the SAP HANA model has large required data and complex service required logic, and part of logic data can be divided into real-time data and non-real-time data, the BW4 is utilized to better optimize the HANA model, and the operation time of the HANA model is greatly improved.
Drawings
FIG. 1 is a flow chart of the calculation of the HANA reference SAP BW4 of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Fig. 1 is a flowchart of a method for calculation of HANA reference SAP BW4 according to an embodiment of the present invention, the method including the following steps:
s1, extracting data from the SAP HANA source database;
since BW4 belongs to the same database as HANA, data in the HANA database can also be processed in BW 4.
In the embodiment of the invention, the required business logic obtains the partial real-time data part and the non-real-time data part according to analysis, the ERP table which needs to be used for many times comprises MKPF and MSEG, if the conventional HANA traditional modeling mode is used for realizing the operation, the HANA model runs slowly due to overlarge data quantity, so that the real-time data required in the business logic is modeled by the traditional HANA modeling mode in the embodiment, the non-real-time data is modeled by BW4 and stored in BW4, and finally the data is integrated in the same model by the HANA by using the HANA main key of the data table to create the view through the real-time data and the non-real-time data, thereby achieving the result required by the real-time analysis of the business requirements.
S2, carrying out conversion logic processing on the extracted data in SAP BW 4;
in the embodiment of the invention, ADSO is created in BW4, a main requirement data table is selected as a main data source to create conversion for the ADSO, tables required in other business requirement logics are used as virtual tables to write AMDP routine codes in the ADSO conversion, the AMDP codes can be ABAP codes or HANA SQ L grammar, the SQ L grammar in BW4 has better data processing performance than the ABAP codes, the HANA SQ L grammar is usually selected to complete the AMDP codes, the ADSO writes the AMDP codes by adopting the HANA SQ L grammar, then DTP is created for the ADSO to extract packet system upload data in full quantity, the final output result data is non-real-time required data, and the ADSO model in the step needs to generate External SAP HANA View for reference in the HANA.
S3, storing the processed data in BW4 in BW4 as a timing task;
BW4 is the same as the old BW processing chain processing mechanism, and creates a processing chain for ADSO in BW4 to do timing task; and creating a working processing chain for loading data based on the DTP of the ADSO, and automatically updating the data for the ADSO by a system at a specified time. In the embodiment of the invention, the non-real-time data needs to update all data, so that a mechanism for deleting the original target data in the ADSO and extracting and updating all data in full is selected, and the latest data is stored in the ADSO.
And S4, synchronously displaying the activity data which is referred and processed in the SAP HANA and other required real-time data in the HANA database.
In the embodiment of the invention, a non-real-time and multi-data logic complex part utilizes BW4 to calculate based on an HANA memory database, most of front-end data analysis, data management and possibly related planning functions are sunk to the HANA for carrying out mechanism, data in BW4 are uploaded in a packet mode, the data are uploaded in BW4, the data are stored in ADSO, the generated ADSO activity table and a table required by the HANA database are stored in the same view through HANA modeling, and finally required data are output through a table main key JOIN; the step greatly optimizes the requirement result of synchronous display of real-time data and non-real-time data in the HANA platform creation model due to the use of an ERP large table and the influence on data loading time, and can obviously improve the performance of the HANA model.
The foregoing is illustrative of the preferred embodiments of the present invention only and is not to be construed as limiting the claims. The present invention is not limited to the above examples, and the specific structure thereof is allowed to vary, and those skilled in the art can make various changes and modifications according to the present invention without departing from the spirit of the present invention, which is defined by the scope of the appended claims.
Claims (5)
1. A method of SAP HANA referencing SAP BW4 calculation, comprising the steps of:
s1, extracting data from the SAP HANA source database, namely extracting required data from the HANA source database by utilizing a HANA S L T data synchronization mechanism;
s2, performing conversion logic processing on the extracted data in SAP BW 4: selecting a demand data table as a data source, creating conversion for ADSO, and writing an AMDP routine code in the ADSO conversion by using tables required by other service demand logics as virtual tables;
s3, storing the processed data in BW4 in BW4 as a timing task: performing a processing chain timing task for the DTP of the ADSO, and automatically updating data for the model by a system at a specified time;
and S4, synchronously displaying the activity data which is referred and processed in the SAP HANA and other required real-time data in the HANA database.
2. The method of claim 1 for SAP HANA referencing SAP BW4 computing, wherein in S1, the mechanism of S L T data real-time synchronization is used to extract real-time data from the HANA database, the required business logic is analyzed to obtain a real-time data part and a non-real-time data part, the real-time data required in the business logic is modeled by using a traditional HANA model, the non-real-time data is modeled by using BW4 and stored in BW4, and finally the real-time data and the non-real-time data are integrated in the same model by using a HANA to create a view through a data table main key in the HANA so as to achieve the result required by the business requirement real-time analysis.
3. The SAP HANA referencing SAP BW4 calculation method according to claim 1, wherein in S2, the extracted data is subjected to conversion logic processing by writing AMDP routine codes in BW4 conversion, in BW4, SQ L grammar has better data processing performance than ABAP code, in terms of data processing degree, HANA SQ L grammar is selected to complete AMDP codes, DTP creation for ADSO is set to extract full amount of packet system upload data, and the final result data is non-real-time required data, and the ADSO model generates External SAP HANA View for referencing in HANA modeling.
4. The method of SAP HANA referencing SAP BW4 calculation of claim 1, wherein in S3 the processed data is saved in BW4 as a timed task timing update;
the timing task refers to a processing chain timing task for the DTP of the ADSO in BW4, the system automatically updates data for the model at the specified time, and the DTP data loading mode mainly comprises: if the new data is updated, incremental extraction is set to accumulate and load the new data, and if all data needs to be updated, full extraction is set to update all data; and finally, storing the latest loaded data in the ADSO.
5. The method as claimed in claim 1, wherein in S4, the non-real-time and multiple data logic complex part is calculated based on the HANA memory database by BW4, and the front-end data analysis, data management and related planning functions are sunk to the HANA for mechanism, and the data in BW4 is uploaded in packets, the data is uploaded in BW4 and stored in ADSO as active data, and the generated ADSO active table and HANA database required table are output in the same view by HANA modeling through table primary key JOIN.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010416990.2A CN111444283A (en) | 2020-05-18 | 2020-05-18 | Method for calculating SAP BW4 by using SAP HANA |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010416990.2A CN111444283A (en) | 2020-05-18 | 2020-05-18 | Method for calculating SAP BW4 by using SAP HANA |
Publications (1)
Publication Number | Publication Date |
---|---|
CN111444283A true CN111444283A (en) | 2020-07-24 |
Family
ID=71656882
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202010416990.2A Pending CN111444283A (en) | 2020-05-18 | 2020-05-18 | Method for calculating SAP BW4 by using SAP HANA |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111444283A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113506159A (en) * | 2021-06-07 | 2021-10-15 | 广发银行股份有限公司 | SAP HANA-based cost allocation method, SAP HANA-based cost allocation device, SAP HANA-based cost allocation equipment and SAP storage medium |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20140279836A1 (en) * | 2013-03-13 | 2014-09-18 | Sap Ag | Configurable Rule for Monitoring Data of In Memory Database |
CN105447069A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | BW platform based account checking platform data synchronization method and system |
CN106708972A (en) * | 2016-12-06 | 2017-05-24 | 江苏电力信息技术有限公司 | Method for optimizing ABAP by utilizing SLT component based on HANA database |
CN107679232A (en) * | 2017-10-24 | 2018-02-09 | 安徽马钢自动化信息技术有限公司 | A kind of synchronous method of SAP HANA source databases and other databases |
CN110390475A (en) * | 2019-07-10 | 2019-10-29 | 国电南京自动化股份有限公司 | A kind of early warning and decision support method based on group's big data |
-
2020
- 2020-05-18 CN CN202010416990.2A patent/CN111444283A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20140279836A1 (en) * | 2013-03-13 | 2014-09-18 | Sap Ag | Configurable Rule for Monitoring Data of In Memory Database |
CN105447069A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | BW platform based account checking platform data synchronization method and system |
CN106708972A (en) * | 2016-12-06 | 2017-05-24 | 江苏电力信息技术有限公司 | Method for optimizing ABAP by utilizing SLT component based on HANA database |
CN107679232A (en) * | 2017-10-24 | 2018-02-09 | 安徽马钢自动化信息技术有限公司 | A kind of synchronous method of SAP HANA source databases and other databases |
CN110390475A (en) * | 2019-07-10 | 2019-10-29 | 国电南京自动化股份有限公司 | A kind of early warning and decision support method based on group's big data |
Non-Patent Citations (1)
Title |
---|
刘晓明: "基于SAP BW的商务智能分析与应用", 《中国优秀博硕士学位论文全文数据库(硕士)经济与管理科学辑》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113506159A (en) * | 2021-06-07 | 2021-10-15 | 广发银行股份有限公司 | SAP HANA-based cost allocation method, SAP HANA-based cost allocation device, SAP HANA-based cost allocation equipment and SAP storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107391653B (en) | Distributed NewSQL database system and picture data storage method | |
US9678969B2 (en) | Metadata updating method and apparatus based on columnar storage in distributed file system, and host | |
US7822710B1 (en) | System and method for data collection | |
CN110489445B (en) | Rapid mass data query method based on polymorphic composition | |
CN102033748B (en) | Method for generating data processing flow codes | |
US11275759B2 (en) | Data storage method and apparatus, server, and storage medium | |
CN107491515B (en) | Intelligent power distribution and utilization data conversion method based on big data platform | |
CN104462224A (en) | Cloud disc file online editing method | |
AU2017399399A1 (en) | Method and system for optimizing database system, electronic device, and storage medium | |
CN110597821A (en) | Method and device for changing database table structure | |
CN107247624A (en) | A kind of cooperative optimization method and system towards Key Value systems | |
CN103034553B (en) | Intelligent verification algorithm, method and device for report designer | |
CN111444283A (en) | Method for calculating SAP BW4 by using SAP HANA | |
US8600990B2 (en) | Interacting methods of data extraction | |
US7958083B2 (en) | Interacting methods of data summarization | |
CN111126619B (en) | Machine learning method and device | |
CN104618471A (en) | Application state transition method applied to different terminals | |
CN105302551B (en) | A kind of method and system of the Orthogonal Decomposition construction and optimization of big data processing system | |
US11874753B2 (en) | Log compression | |
CN103279328A (en) | BlogRank algorithm parallelization processing construction method based on Haloop | |
CN111026764B (en) | Data storage method and device, electronic product and storage medium | |
CN112860812A (en) | Information processing method, apparatus, device, storage medium, and program product | |
CN103353864A (en) | Method and system for excavating approximate dictionary rule of database, and database terminal | |
CN112783927A (en) | Database query method and system | |
CN110825786A (en) | Spark-based big data association rule mining method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200724 |