CN109933613A - A kind of method and system accessing SAP BW report result set - Google Patents
A kind of method and system accessing SAP BW report result set Download PDFInfo
- Publication number
- CN109933613A CN109933613A CN201910212248.7A CN201910212248A CN109933613A CN 109933613 A CN109933613 A CN 109933613A CN 201910212248 A CN201910212248 A CN 201910212248A CN 109933613 A CN109933613 A CN 109933613A
- Authority
- CN
- China
- Prior art keywords
- sap
- access
- result set
- report
- report result
- 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
- 238000000034 method Methods 0.000 title claims abstract description 45
- 230000008569 process Effects 0.000 claims abstract description 13
- 230000009466 transformation Effects 0.000 claims abstract description 8
- 239000011159 matrix material Substances 0.000 claims description 3
- 238000003860 storage Methods 0.000 abstract description 7
- 238000012423 maintenance Methods 0.000 abstract description 3
- 238000005516 engineering process Methods 0.000 description 5
- 238000013461 design Methods 0.000 description 3
- 230000002776 aggregation Effects 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 230000002354 daily effect Effects 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000005452 bending Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of methods for accessing SAP BW report result set, comprising: receives the access request that external system is sent；One 16 unique ID of distribution give this access process of the external system；The access parameter in access request is parsed, a dynamic search engine is generated according to the access parameter parsed；Search engine is used to retrieve corresponding SAP BW report result set, SAP BW report result set is converted into corresponding request format；SAP BW report result set after format transformation is back to unique ID, discharges unique ID.The present invention can enable external system efficiently and rapidly access the report of SAP BW, reduce external system for the amount of storage of throwing data under SAP BW system, ensure that the efficient, consistent of accessed data, flexibility；In addition, external system multi-user can access SAP BW report by unique RFC user, the maintenance cost of SAP BW system is reduced.
Description
Technical field
The present invention relates to computer software and applied technical fields, in particular to a kind of access suitable for external system
The method and system of SAP BW report result set.
Background technique
SAP BW system is the data warehouse of an enterprise-level, by acquisition to SAP and non-SAP system data, storage,
Analysis and management provide integrated, the platform towards commercial affairs.Data central warehouse of the SAP BW system as enterprise, it can be with
It intelligently manages the mass data information of entire enterprise information system and therefrom excavates valuable information, it is daily to enterprise
OA operation analysis provides strong data analysis support and ensures, and provides strong decision support to company manager, to make
Enterprise is sensitiveer to market reaction quick, and entire enterprise also has more vitality and competitiveness.BW system why can play as
This important role depends on its unique data model storage and report reading manner.
Data model storage:
SAP BW system data is stored in InfoCube (in information cube) (such as Fig. 2).InfoCube is mainly by the fact
Table and dimension table, aggregation table composition.InfoCube itself is using a kind of extension star schema model.Pass through the star-like frame of extension
Structure: dimension table does not store master data directly, but stores the SID of master data, the SID table of dimension table and master data by SID with
Master data is associated:
The advantages of SID technology:
1, because SID is Int type, Int type it is faster than the query rate of Char type, so using SID skill
The query rate of report is faster than previous after art；
2, just that master data is independent after using SID technology, master data can be made by model all in system
It shares, meets the rule reused in soft project.
The aggregation table of SAP BW refers to according to several in InfoCube or dimensional information Object Creation small
InfoCube, is newly-generated one true table in fact, and additional some corresponding dimension tables can effectively improve the access of data
Efficiency.
Report reading manner:
The dedicated report developing instrument of SAP BW is Query Designer, and report demonstration tool is Query Analyzer
Or Web Query.By using the report that Query Designer is created, in conjunction with querying condition and report Access Model,
Efficient data accessing engine can dynamically be formed.
Therefore: by above explanation, carry out data storage using SAP BW and carry report using SAP BW to develop work
Tool, can efficiently be rapidly performed by the reading and access of data.
But in daily operation, central data warehouse of the SAP BW system as enterprise can usually be faced more
Data access demand of a external system for SAP BW system, it is contemplated that SAP BW system data is for magnanimity and from not
Same system merge, and currently used method is that data form result set made of rigid condition limitation, under timing
It throws, is used for external system.But external system, usually it is desirable that consistent with BW report used in everyday, querying condition needs
Very flexibly, it may be assumed that external system wishes efficiently can quickly access as the report access tool that SAP BW is carried
Report under all InfoCube (information cube) of SAPBW system, at present the two of SAP BW demonstration tool, Query
Analyzer is to be nested in Excel that external system calling can not be supplied, and Web Query is can to open to visit to external system
It asks, but since the included format of web access and the whole style of external system will be different, so both the above mode
All it is unable to satisfy the requirements for access of external system.
Summary of the invention
It is an object of that present invention to provide it is a kind of suitable for external system access SAP BW report result set method and system,
So that external system is efficiently and rapidly accessed the report of SAP BW, reduces external system for throwing data under SAP BW system
Amount of storage ensure that the efficient, consistent of accessed data, flexibility；In addition, external system multi-user can be by unique
RFC user accesses SAP BW report, reduces the maintenance cost of SAP BW system.
To reach above-mentioned purpose, in conjunction with Fig. 1, the present invention proposes a kind of access SAP BW report result suitable for external system
The method of collection, which comprises
The access request that external system is sent is received, including at least in access request has access report name, access parameter.
One 16 unique ID of distribution give this access process of the external system.
The access parameter in the access request is parsed, one is generated according to the access parameter parsed and dynamically searches for and draw
It holds up.
Described search engine is used to retrieve corresponding SAP BW report result set, by the SAP BW report result set
It is converted into corresponding request format.
SAP BW report result set after format transformation is back to unique ID, discharges unique ID.
In further embodiment, the initial format of the SAP BW report result set is the dotted sequence table of XY.
In further embodiment, the request format is matrix format.
In further embodiment, the method also includes:
The SAP BW report result set is automatically converted into corresponding request format according to the classification of external system.
In further embodiment, the method also includes:
Using SAP function NUMBER_GET_NEXT, individually primary access locking ID is generated.
In further embodiment, the method also includes:
SAP standard RRX_GRID_GET is used to generate dynamic search engine.
In further embodiment, the method also includes:
Use SAP function SWC_DDIC_QUERY_TABLE_FIELDS with format transformation.
In further embodiment, the method also includes:
Access process is generated into log.
Based on preceding method, what the present invention further mentioned a kind of access SAP BW report result set suitable for external system is
System, the system comprises receiving module, ID distribution module, parsing module, search engine generation module, search module, formats to turn
Change the mold block, sending module.
The receiving module is used to receive the module of the access request of external system transmission, and including at least in access request has
Access report name, access parameter.
The ID distribution module is used to distribute one 16 unique ID to this access process of the external system.
The parsing module is used to parse the module of the access parameter in the access request.
Described search engine generation module is used to generate a dynamic search engine according to the access parameter parsed
Module.
Described search module is for using described search engine to retrieve the module of corresponding SAP BW report result set.
The format converting module is used to for the SAP BW report result set being converted into the module of corresponding request format.
The sending module is used to for the SAP BW report result set after format transformation to be back to unique ID, discharges institute
State the module of unique ID.
External system sends the access SAP BW report result for being suitable for external system mentioned by access request to the present invention
The system of collection, system distributes one 16 unique ID to this access process of the external system first, until access terminates,
ID release.
SAP system has stringent account resource control (that is: each account is to need individually payment), passes through distribution 16
Unique ID passes through the side of RFC when so that external system accesses SAP BW to the mode of each access process of external system
Formula only realizes the demand of external system multi-user access with a system RFC user.
After distribution ID success, access request is parsed, by the access parameter parsed, access search is generated and draws
It holds up and carries out back-end data access, then the SAP BW report result set that will acquire is converted into the module of corresponding request format, according to
The dynamic I D of generation, backward reference result set are used for external system.
Data are changed by analyzing XY sequence as the storage of XY sequence for example, being integrated by the data result that search engine returns
Bending moment battle array is shown (i.e. from the dotted gauge outfit explanation of field that is adjusted to of XY to data filling).
The above technical solution of the present invention, compared with existing, significant beneficial effect is:
1, external system equally can quickly access the existing report of BW with SAP BW system itself, under reducing periodically
The workload for needing independent customized development is thrown, while saving the data space of external system.
2, it ensure that the consistency of data, for example, financial account or material account, if the account phase does not close, then in the account phase
Data are adjustable, and external system and SAP BW system maintain data consistency.
3, external system is accessed by unique RFC user, reduces the O&M expense of SAP BW system.
4, it is that the data for meeting own system and report show that format, user experience are better that external system is received.
It should be appreciated that as long as aforementioned concepts and all combinations additionally conceived described in greater detail below are at this
It can be viewed as a part of the subject matter of the disclosure in the case that the design of sample is not conflicting.In addition, required guarantor
All combinations of the theme of shield are considered as a part of the subject matter of the disclosure.
Can be more fully appreciated from the following description in conjunction with attached drawing present invention teach that the foregoing and other aspects, reality
Apply example and feature.The features and/or benefits of other additional aspects such as illustrative embodiments of the invention will be below
Description in it is obvious, or learnt in practice by the specific embodiment instructed according to the present invention.
Detailed description of the invention
Attached drawing is not intended to drawn to scale.In the accompanying drawings, identical or nearly identical group each of is shown in each figure
It can be indicated by the same numeral at part.For clarity, in each figure, not each component part is labeled.
Now, example will be passed through and the embodiments of various aspects of the invention is described in reference to the drawings, in which:
Fig. 1 is the flow chart of the method for the access SAP BW report result set for being suitable for external system of the invention.
Fig. 2 is the storage mode structure chart of SAP BW system data of the invention.
Specific embodiment
In order to better understand the technical content of the present invention, special to lift specific embodiment and institute's accompanying drawings is cooperated to be described as follows.
In conjunction with Fig. 1, a kind of method that the present invention refers to access SAP BW report result set suitable for external system, the side
Method includes:
Step 1 receives the access request that external system is sent, and including at least in access request has access report name, visits
Ask parameter.
The present invention is suitable for the report that external system calls current all openings of SAP BW system to use to user, so calling
Parameter is that dynamic inputs.
One 16 step 2, distribution unique ID give this access process of the external system.
External system sends the access SAP BW report result for being suitable for external system mentioned by access request to the present invention
The system of collection, system distributes one 16 unique ID to this access process of the external system first, until access terminates,
ID release.
SAP system has stringent account resource control (that is: each account is to need individually payment), passes through distribution 16
Unique ID passes through the side of RFC when so that external system accesses SAP BW to the mode of each access process of external system
Formula only realizes the demand of external system multi-user access with a system RFC user.
It is dynamic to generate one according to the access parameter parsed for access parameter in step 3, the parsing access request
Search engine.
Step 4 uses described search engine to retrieve corresponding SAP BW report result set, by the SAP BW report
Result set is converted into corresponding request format.
SAP BW report result set after format transformation is back to unique ID by step 5, discharges unique ID.
Access process is generated log by step 6, is convenient for back-stage management.
After distribution ID success, access request is parsed, by the access parameter parsed, access search is generated and draws
It holds up and carries out back-end data access, then the SAP BW report result set that will acquire is converted into the module of corresponding request format, according to
The dynamic I D of generation, backward reference result set are used for external system.
In some instances, can according to the classification of external system by the SAP BW report result set be automatically converted into
Corresponding request format, to meet the requirement of different classes of external system.For example external system is categorized into operation system, is surveyed
Test system, maintenance system etc., for different types of external system, each not phase of the format of the SAP BW report result set of return
Together, system type can be parsed from access request and be obtained.Even, it can be parsed out the external system for sending access request
Client type, different formats is set, to improve user experience.
For example, being stored by the original state that the data result that search engine returns integrates as XY sequence, passes through and analyze XY sequence
Data are changed matrix and shown (i.e. from the dotted gauge outfit explanation of field that is adjusted to of XY to data filling) by column.
From the foregoing it will be appreciated that the present invention can be understood as creating an application programming interfaces, for enabling external system
Quickly access SAP BW system.
Below by an example to the access SAP BW report result set for being suitable for external system mentioned by the present invention
Method is specifically addressed, and the specific embodiment of this example is as follows:
1, a Function Group is created.
2, a Function Module is created.
3, a parameter is created in the parameter Import of Function Module input table, the following table of structure:
| Field | Data element | Type | Length | Field description |
| MANDT | MANDT | CLNT | 3 | Client |
| PRMT_NUM | char | 10 | Record sequence | |
| PRMT_ITEM | char | 10 | Record row project number | |
| COMPID | RSZCOMPID | char | 30 | The title (ID) of reporting component |
| PRMT_NAME | char | 30 | Parameter name | |
| SIGN | RALDB_SIGN | char | 1 | Create SIGN field when SELECT-OPTIONS table |
| OPT | RSZ_OPERATOR | char | 2 | Select the operator in option and other expression formulas |
| LOW | RSCHAVL | char | 60 | Dimension: user's defined property value field |
| HIGH | RSCHAVL | char | 60 | Dimension: user's defined property value field |
4, locking ID is generated, and using SAP function NUMBER_GET_NEXT, generates individually primary access locking ID.
5, according to access parameter, the technology of the technology ID of accessed report and the querying condition of accessed report are read
The technology contents information of ID and querying condition.
6, according to the access parameter parsed, dynamic search engine is generated, the quick-searching of data is carried out；Specifically make
With SAP standard RRX_GRID_GET.
7, since the content that search engine retrieving comes out is the dotted sequence table of XY, need to convert showing format (i.e. from XY point
Shape is adjusted to gauge outfit explanation of field and fills to data), use SAP function SWC_DDIC_QUERY_TABLE_FIELDS.
8, collection is returned the result to external system finally by interface.
Various aspects with reference to the accompanying drawings to describe the present invention in the disclosure, shown in the drawings of the embodiment of many explanations.
Embodiment of the disclosure need not be defined on including all aspects of the invention.It should be appreciated that a variety of designs and reality presented hereinbefore
Those of apply example, and describe in more detail below design and embodiment can in many ways in any one come it is real
It applies, this is because conception and embodiment disclosed in this invention are not limited to any embodiment.In addition, disclosed by the invention one
A little aspects can be used alone, or otherwise any appropriately combined use with disclosed by the invention.
Although the present invention has been disclosed as a preferred embodiment, however, it is not to limit the invention.Skill belonging to the present invention
Has usually intellectual in art field, without departing from the spirit and scope of the present invention, when can be used for a variety of modifications and variations.Cause
This, the scope of protection of the present invention is defined by those of the claims.
Claims (9)
1. a kind of method for accessing SAP BW report result set, which is characterized in that the described method includes:
The access request that external system is sent is received, including at least in access request has access report name, access parameter；
One 16 unique ID of distribution give this access process of the external system；
The access parameter in the access request is parsed, a dynamic search engine is generated according to the access parameter parsed；
Described search engine is used to retrieve corresponding SAP BW report result set, the SAP BW report result set is converted
At corresponding request format；
SAP BW report result set after format transformation is back to unique ID, discharges unique ID.
2. the method for access SAP BW report result set according to claim 1, which is characterized in that the SAP BW report
The initial format of result set is the dotted sequence table of XY.
3. the method for access SAP BW report result set according to claim 1, which is characterized in that the request format is
Matrix format.
4. the method for access SAP BW report result set according to claim 1, which is characterized in that the method is also wrapped
It includes:
The SAP BW report result set is automatically converted into corresponding request format according to the classification of external system.
5. the method for access SAP BW report result set according to claim 1, which is characterized in that the method is also wrapped
It includes:
Using SAP function NUMBER_GET_NEXT, individually primary access locking ID is generated.
6. the method for access SAP BW report result set according to claim 1, which is characterized in that the method is also wrapped
It includes:
SAP standard RRX_GRID_GET is used to generate dynamic search engine.
7. the method for access SAP BW report result set according to claim 1, which is characterized in that the method is also wrapped
It includes:
Use SAP function SWC_DDIC_QUERY_TABLE_FIELDS with format transformation.
8. the method for access SAP BW report result set according to claim 1, which is characterized in that the method is also wrapped
It includes:
Access process is generated into log.
9. a kind of system for accessing SAP BW report result set, which is characterized in that the system comprises:
Receiving module, for receiving the module for the access request that external system is sent, including at least in access request has access to report
Table name, access parameter；
ID distribution module, for distributing one 16 unique ID to this access process of the external system；
Parsing module, for parsing the module of the access parameter in the access request；
Search engine generation module, for generating the module of a dynamic search engine according to the access parameter parsed；
Search module retrieves the module of corresponding SAP BW report result set for using described search engine；
Format converting module, for the SAP BW report result set to be converted into the module of corresponding request format；
Sending module discharges described unique for the SAP BW report result set after format transformation to be back to unique ID
The module of ID.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910212248.7A CN109933613A (en) | 2019-03-20 | 2019-03-20 | A kind of method and system accessing SAP BW report result set |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910212248.7A CN109933613A (en) | 2019-03-20 | 2019-03-20 | A kind of method and system accessing SAP BW report result set |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109933613A true CN109933613A (en) | 2019-06-25 |
Family
ID=66987698
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910212248.7A Pending CN109933613A (en) | 2019-03-20 | 2019-03-20 | A kind of method and system accessing SAP BW report result set |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109933613A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103384239A (en) * | 2012-12-19 | 2013-11-06 | 航天数联信息技术（深圳）有限公司 | Report generating method and system |
| CN104573065A (en) * | 2015-01-23 | 2015-04-29 | 广东能龙教育股份有限公司 | Report display engine based on metadata |
| CN104715052A (en) * | 2015-03-27 | 2015-06-17 | 国家电网公司 | Method and system for generating statement |
| CN108647304A (en) * | 2018-05-09 | 2018-10-12 | 中国平安人寿保险股份有限公司 | Report display system, method, computer equipment and storage medium |
| CN109492138A (en) * | 2018-10-22 | 2019-03-19 | 中国银行股份有限公司 | A kind of data query processing method and system |
-
2019
- 2019-03-20 CN CN201910212248.7A patent/CN109933613A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103384239A (en) * | 2012-12-19 | 2013-11-06 | 航天数联信息技术（深圳）有限公司 | Report generating method and system |
| CN104573065A (en) * | 2015-01-23 | 2015-04-29 | 广东能龙教育股份有限公司 | Report display engine based on metadata |
| CN104715052A (en) * | 2015-03-27 | 2015-06-17 | 国家电网公司 | Method and system for generating statement |
| CN108647304A (en) * | 2018-05-09 | 2018-10-12 | 中国平安人寿保险股份有限公司 | Report display system, method, computer equipment and storage medium |
| CN109492138A (en) * | 2018-10-22 | 2019-03-19 | 中国银行股份有限公司 | A kind of data query processing method and system |
Non-Patent Citations (1)
| Title |
|---|
| 张国文: ""基于SAP数据仓库出具财务报表的应用研究"", 《电脑知识与技术》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11157489B2 (en) | Data querying | |
| CN101908015B (en) | Device and method for creating test case based on components | |
| US7194485B2 (en) | Mapping XML schema components to qualified java components | |
| JP5298117B2 (en) | Data merging in distributed computing | |
| CN100565510C (en) | Data access layer class generator | |
| Schmidt et al. | Why and how to benchmark XML databases | |
| US7424470B2 (en) | Local data repository generation | |
| US20090172553A1 (en) | Spreadsheet Software Services | |
| CN101996067A (en) | Data export method and device | |
| CN110032594B (en) | Customizable data extraction method and device for multi-source database and storage medium | |
| CN104573065A (en) | Report display engine based on metadata | |
| CN103309904A (en) | Method and device for generating data warehouse ETL (Extraction, Transformation and Loading) codes | |
| CN201435074Y (en) | Device for generating test case based on member | |
| US20070043689A1 (en) | Lightweight generic report generation tool | |
| CN110377668A (en) | Data analysing method and system | |
| US8095532B2 (en) | Apparatus and method for generating report data in a multi-user environment | |
| CN102375859B (en) | Method and equipment for processing information | |
| US20050144087A1 (en) | Disparate sales system integration and method | |
| CN109933613A (en) | A kind of method and system accessing SAP BW report result set | |
| CN106503038B (en) | A kind of method and system of automatic buffer network request returned data | |
| Tritt et al. | HDMF: Hierarchical Data Modeling Framework for modern science data standards | |
| Rong et al. | Design of heterogeneous Data SQL access scheme based on postgreSQL | |
| Papakonstantinou et al. | The Enosys Markets data integration platform: lessons from the trenches | |
| CN107844349B (en) | Control method and device based on user interface | |
| CN108228688B (en) | Template generation method, system and server based on XBRL |
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: 20190625 |