CN105405002A - Formula data configuration method and system based on SAP platform - Google Patents
Formula data configuration method and system based on SAP platform Download PDFInfo
- Publication number
- CN105405002A CN105405002A CN201510617347.5A CN201510617347A CN105405002A CN 105405002 A CN105405002 A CN 105405002A CN 201510617347 A CN201510617347 A CN 201510617347A CN 105405002 A CN105405002 A CN 105405002A
- Authority
- CN
- China
- Prior art keywords
- formula
- operational
- symbol
- resolution path
- analytic method
- 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
Landscapes
- Stored Programmes (AREA)
Abstract
The invention discloses a formula data configuration method and a system based on an SAP platform. The method includes: extracting formula information related in different business systems and saving the information into a formula cache region; splitting a formula into a basis calculation formula, basic operators, and a combined calculation formula, and establishing a corresponding parse path and a parse method for each operation formula and the operators; creating a formula configuration table in the SAP platform; and combining different operation formulas and the basic operators in the configuration table, and configuring the final calculation formula. The beneficial effects of the method and the system are that different operation formulas, operators, and the parse methods thereof are maintained in the configuration table, users can select different calculation formulas for calculation according to different business calculating logics, in this way, when the users change the business logic calculations or increase businesses, the users only need to configure the corresponding calculation formulas in a production system to achieve the corresponding goals, and the stability of the system is improved.
Description
Technical field
The present invention relates to computer information processing field, particularly relate to a kind of formula data collocation method based on SAP platform and system.
Background technology
SAP (systemsapplicationsandproductsindataprocessing) is a software managed for enterprise resource manage system (enterpriseresourceplanning).
SAP system only has the computing formula of a standard, when calculating for Different Rule different business, just cannot realize calculating for the computing formula of particular service model or other combination computing formula if run into, now, need to realize computing for each service conditions coding, to obtain corresponding result, cannot flexible configuration.So not only workload is large, and in maintenance process afterwards, needs a large amount of exploitations, difficult in maintenance.When editing formula, needing to call program one by one and going to check formula logical OR service computation logic, causing very large impact to the ageing of enterprise operation.
Summary of the invention
Object of the present invention is exactly to solve the problem, and proposes a kind of formula data collocation method based on SAP platform and system.The formula of various complexity that the method and system will be used, by splitting, the mode of combination is set to configurable and is easy to the formula storehouse of safeguarding and parsing scheme, has the advantage that real-time is good and easy to operate.
To achieve these goals, the present invention adopts following technical scheme:
Based on a formula data collocation method for SAP platform, comprise the following steps:
Step 1: the configuration parameter reading different business systems, extracts the formula info related in different business systems, and by described formula info stored in formula buffer area;
Step 2: by said extracted to formula be split as basic calculating formula, fundamental operation symbol and combination computing formula further, and set up corresponding resolution path and analytic method for each operational formula and operational symbol;
Step 3: set up formula allocation list in SAP platform, safeguards into allocation list by all operational formulas in formula buffer area and fundamental operation symbol and their resolution path, analytic method;
Step 4: formula needed for type of service, transfers to obtain corresponding operational formula and fundamental operation symbol, different operational formulas and fundamental operation symbol is combined, be configured to final computing formula in allocation list.
The information comprised in described formula allocation list comprises: type of service, formula type, operational symbol, resolution path, analytic method.
The corresponding unique resolution path of each operational formula or operational symbol and analytic method in described step 2, described resolution path associates with the identification information of setting with analytic method, each identification information unique resolution path of correspondence and analytic method;
Described identification information can be transferred the corresponding operational formula of allocation list or operational symbol and resolve.
Operational formula is associated with type of service, the operational formula of association identical services type is stored in same formula group.
When changing service logic computation rule or Added Business, by increasing corresponding computing formula and resolution path thereof at formula buffer area, analytic method realizes.
Based on a system for the formula data collocation method of SAP platform, comprising:
For reading the configuration parameter of different business systems, extract the formula info related in different business systems, and by the module of described formula info stored in formula buffer area;
For by said extracted to formula be split as basic calculating formula, fundamental operation symbol and combination computing formula further, and set up the module of corresponding resolution path and analytic method for each operational formula and operational symbol;
For setting up formula allocation list in SAP platform, all operational formulas in formula buffer area and fundamental operation symbol and their resolution path, analytic method are safeguarded the module into allocation list;
For formula needed for type of service, in allocation list, transfer to obtain corresponding operational formula and fundamental operation symbol, different operational formulas and fundamental operation symbol are combined, is configured to the module of final computing formula.
The information comprised in described formula allocation list comprises: type of service, formula type, operational symbol, resolution path, analytic method.
For the formula extracted being split as further basic calculating formula, fundamental operation symbol and combination computing formula, and the module setting up corresponding resolution path and analytic method for each operational formula and operational symbol also comprises: for the unit by each operational formula or the corresponding unique resolution path of operational symbol and analytic method;
For the unit that resolution path and analytic method and the identification information of setting are carried out associating;
For the unit by corresponding for each identification information unique resolution path and analytic method;
Transfer the corresponding operational formula of allocation list or operational symbol for utilizing identification information and carry out the unit of resolving.
Also comprise: for the module that operational formula and type of service are carried out associating, for the operational formula of association identical services type being stored in the module in same formula group.
Also comprise: for when changing service logic computation rule or Added Business, by the module increasing corresponding computing formula and resolution path thereof at formula buffer area, analytic method realizes.
The invention has the beneficial effects as follows:
The present invention by creating formula allocation list in SAP platform, different operational formulas, operational symbol and related resolution method thereof are safeguarded in allocation list, user can for the different computing formula of different service computation logical OR Model Selection, calculate, like this when user changes service logic calculating or Added Business, user only needs in the corresponding computing formula of production system configuration or reaches corresponding object by existing formula combinations, save a large amount of time and human cost, and add the stability of system.Simultaneously due to the configurability of formula, the calculating flexibility ratio of different service types improves greatly, adds the reusability of configuration effort stream.
Accompanying drawing explanation
Fig. 1 is the inventive method process flow diagram.
Embodiment:
Below in conjunction with accompanying drawing and embodiment, the present invention will be further described:
The present invention is according to computational logic, self-defining formula is classified, be divided into basic calculating formula and combination computing formula, and write corresponding analytic method for these self-defining formula, the service computation of current existing all complexity can be carried out by the combination of these formula, and for follow-up new service computation, can be added by the mode of configuration;
Concrete grammar is as shown in Figure 1:
Step 1: the configuration parameter reading different business systems, extracts the formula info related in different business systems, and by described formula info stored in formula buffer area;
Step 2: by said extracted to formula be split as basic calculating formula, fundamental operation symbol and combination computing formula further, and set up corresponding resolution path and analytic method for each operational formula and operational symbol; Shown in table specific as follows:
The corresponding unique resolution path of each operational formula or operational symbol and analytic method, described resolution path associates with the identification information of setting with analytic method, each identification information unique resolution path of correspondence and analytic method; Identification information can be transferred the corresponding operational formula of allocation list or operational symbol and resolve.
Step 3: set up formula allocation list in SAP platform, safeguards into allocation list by all operational formulas in formula buffer area and fundamental operation symbol and their resolution path, analytic method;
The information comprised in allocation list comprises: type of service, formula type, operational symbol, resolution path, analytic method.
Step 4: formula needed for type of service, transfers to obtain corresponding operational formula and fundamental operation symbol, different operational formulas and fundamental operation symbol is combined, be configured to final computing formula in allocation list.Wherein, basic calculating formula or fundamental operation symbol comprise: add, subtract, multiplication and division, with or, the basic computing such as non-.
Operational formula is associated with type of service, the operational formula of association identical services type is stored in same formula group.
When user performs the corresponding business containing formula, from formula allocation list, the complicated formulas of user configured correspondence is obtained according to type of service, then splitting complicated formulas is fundamental formular, and analytic method program corresponding for fundamental formular is taken out execution from Formula Parsing table.
User can for the different computing formula of different service computation logical OR Model Selection, calculate, like this when user changes service logic calculating or Added Business, user only needs in the corresponding computing formula of production system configuration or reaches corresponding object by existing formula combinations, save a large amount of time and human cost, and add the stability of system.
In other embodiment, for the analytic method of complex mathematical formula, comprise the following steps:
Step one: according to all operational formulas in formula buffer area and fundamental operation symbol and their resolution path, the grand of computational mathematics model is set; The specific implementation of the exploitation of the to the effect that computational mathematics model VBA code of this step.In VBA code, can be passed to the basic data of EXCEL according to SAP system, according to different mathematics computing models, the calculating of developing correspondence is grand.
Step 2: SAP system calls the grand of the computational mathematics model finished writing in advance by DOI technology, carry out numerical evaluation according to mathematical model; Dynamic variable is set to needing the EXCEL data area calculated.Different calculation procedure codes is created for different mathematics computing models; One is become by code wrap to comprise the grand of two input parameters.Wherein XvalueAsString is set, YvalueAsString two input parameters.These two input parameters are the range of choice of EXCEL.
$ A $ 1:$ E:4, its meaning represented is the scope of A1 to E4 in this sheet of Sheet1 in EXCEL.
According to calculating the data record number of input and different computation models, obtaining corresponding input parameter Xvalue and Yvalue value and carrying out the calculating of core.
Step 5: the result calculated is stored in the position of specifying, after SAP now judges that calculating completes, read this position and store information, transfer back to SAP; SAP system reads the data of assigned address and exports.
Based on a system for the formula data collocation method of SAP platform, comprising:
For reading the configuration parameter of different business systems, extract the formula info related in different business systems, and by the module of described formula info stored in formula buffer area;
For by said extracted to formula be split as basic calculating formula, fundamental operation symbol and combination computing formula further, and set up the module of corresponding resolution path and analytic method for each operational formula and operational symbol;
For setting up formula allocation list in SAP platform, all operational formulas in formula buffer area and fundamental operation symbol and their resolution path, analytic method are safeguarded the module into allocation list;
For formula needed for type of service, in allocation list, transfer to obtain corresponding operational formula and fundamental operation symbol, different operational formulas and fundamental operation symbol are combined, is configured to the module of final computing formula.
The information comprised in described formula allocation list comprises: type of service, formula type, operational symbol, resolution path, analytic method.
Also comprise: for the module by each operational formula or the corresponding unique resolution path of operational symbol and analytic method;
For the module that resolution path and analytic method and the identification information of setting are carried out associating;
For the module by corresponding for each identification information unique resolution path and analytic method;
Transfer the corresponding operational formula of allocation list or operational symbol for utilizing identification information and carry out the module of resolving.
Also comprise: for the module that operational formula and type of service are carried out associating, for the operational formula of association identical services type being stored in the module in same formula group.
Also comprise: for when changing service logic computation rule or Added Business, by the module increasing corresponding computing formula and resolution path thereof at formula buffer area, analytic method realizes.
And realize the module of complex mathematical Formula Parsing.
By reference to the accompanying drawings the specific embodiment of the present invention is described although above-mentioned; but not limiting the scope of the invention; one of ordinary skill in the art should be understood that; on the basis of technical scheme of the present invention, those skilled in the art do not need to pay various amendment or distortion that creative work can make still within protection scope of the present invention.
Claims (10)
1., based on a formula data collocation method for SAP platform, it is characterized in that, comprise the following steps:
Step 1: the configuration parameter reading different business systems, extracts the formula info related in different business systems, and by described formula info stored in formula buffer area;
Step 2: by said extracted to formula be split as basic calculating formula, fundamental operation symbol and combination computing formula further, and set up corresponding resolution path and analytic method for each operational formula and operational symbol;
Step 3: set up formula allocation list in SAP platform, safeguards into allocation list by all operational formulas in formula buffer area and fundamental operation symbol and their resolution path, analytic method;
Step 4: formula needed for type of service, transfers to obtain corresponding operational formula and fundamental operation symbol, different operational formulas and fundamental operation symbol is combined, be configured to final computing formula in allocation list.
2. a kind of formula data collocation method based on SAP platform as claimed in claim 1, it is characterized in that, the information comprised in described formula allocation list comprises: type of service, formula type, operational symbol, resolution path, analytic method.
3. a kind of formula data collocation method based on SAP platform as claimed in claim 1, it is characterized in that, the corresponding unique resolution path of each operational formula or operational symbol and analytic method in described step 2, described resolution path associates with the identification information of setting with analytic method, the corresponding unique resolution path of each identification information and analytic method;
Described identification information can be transferred the corresponding operational formula of allocation list or operational symbol and resolve.
4. a kind of formula data collocation method based on SAP platform as claimed in claim 1, is characterized in that, operational formula associated with type of service, the operational formula of association identical services type is stored in same formula group.
5. a kind of formula data collocation method based on SAP platform as claimed in claim 1, it is characterized in that, when changing service logic computation rule or Added Business, by increasing corresponding computing formula and resolution path thereof at formula buffer area, analytic method realizes.
6., as claimed in claim 1 based on a system for the formula data collocation method of SAP platform, it is characterized in that, comprising:
For reading the configuration parameter of different business systems, extract the formula info related in different business systems, and by the module of described formula info stored in formula buffer area;
For by said extracted to formula be split as basic calculating formula, fundamental operation symbol and combination computing formula further, and set up the module of corresponding resolution path and analytic method for each operational formula and operational symbol;
For setting up formula allocation list in SAP platform, all operational formulas in formula buffer area and fundamental operation symbol and their resolution path, analytic method are safeguarded the module into allocation list;
For formula needed for type of service, in allocation list, transfer to obtain corresponding operational formula and fundamental operation symbol, different operational formulas and fundamental operation symbol are combined, is configured to the module of final computing formula.
7., as claimed in claim 6 based on the system of the formula data collocation method of SAP platform, it is characterized in that, the information comprised in described formula allocation list comprises: type of service, formula type, operational symbol, resolution path, analytic method.
8. as claimed in claim 6 based on the system of the formula data collocation method of SAP platform, it is characterized in that, for the formula extracted being split as further basic calculating formula, fundamental operation symbol and combination computing formula, and the module setting up corresponding resolution path and analytic method for each operational formula and operational symbol also comprises: for the unit by each operational formula or the corresponding unique resolution path of operational symbol and analytic method;
For the unit that resolution path and analytic method and the identification information of setting are carried out associating;
For the unit by corresponding for each identification information unique resolution path and analytic method;
Transfer the corresponding operational formula of allocation list or operational symbol for utilizing identification information and carry out the unit of resolving.
9. as claimed in claim 6 based on the system of the formula data collocation method of SAP platform, it is characterized in that, also comprise: for the module that operational formula and type of service are carried out associating, for the operational formula of association identical services type being stored in the module in same formula group.
10. as claimed in claim 6 based on the system of the formula data collocation method of SAP platform, it is characterized in that, also comprise: for when changing service logic computation rule or Added Business, by the module increasing corresponding computing formula and resolution path thereof at formula buffer area, analytic method realizes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510617347.5A CN105405002A (en) | 2015-09-24 | 2015-09-24 | Formula data configuration method and system based on SAP platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510617347.5A CN105405002A (en) | 2015-09-24 | 2015-09-24 | Formula data configuration method and system based on SAP platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105405002A true CN105405002A (en) | 2016-03-16 |
Family
ID=55470474
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510617347.5A Pending CN105405002A (en) | 2015-09-24 | 2015-09-24 | Formula data configuration method and system based on SAP platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105405002A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874243A (en) * | 2016-12-21 | 2017-06-20 | 武汉斗鱼网络科技有限公司 | Formula processing method and device based on character string |
| CN109189385A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Algorithm configuration method, apparatus, computer equipment and storage medium |
| CN112394976A (en) * | 2020-10-16 | 2021-02-23 | 深圳市科漫达智能管理科技有限公司 | Formula self-defining configuration method and related device |
| CN112860464A (en) * | 2021-04-06 | 2021-05-28 | 深圳乐信软件技术有限公司 | Operation relation configuration method and device, computer equipment and storage medium |
| CN114357944A (en) * | 2021-12-17 | 2022-04-15 | 永中软件股份有限公司 | Layout method of large operator formula and computer device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521411A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Formula and formula data processing device and formula and formula data processing method |
| CN103093043A (en) * | 2013-01-09 | 2013-05-08 | 中国电力科学研究院 | Design method for formula computing tools in power information system and design system thereof |
| CN103236014A (en) * | 2013-04-26 | 2013-08-07 | 浪潮集团山东通用软件有限公司 | Method for flexibly defining payment and ownership formulas of enterprise annuity account management system |
| CN104408544A (en) * | 2014-10-28 | 2015-03-11 | 用友优普信息技术有限公司 | Formula resolving apparatus and method |
-
2015
- 2015-09-24 CN CN201510617347.5A patent/CN105405002A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521411A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Formula and formula data processing device and formula and formula data processing method |
| CN103093043A (en) * | 2013-01-09 | 2013-05-08 | 中国电力科学研究院 | Design method for formula computing tools in power information system and design system thereof |
| CN103236014A (en) * | 2013-04-26 | 2013-08-07 | 浪潮集团山东通用软件有限公司 | Method for flexibly defining payment and ownership formulas of enterprise annuity account management system |
| CN104408544A (en) * | 2014-10-28 | 2015-03-11 | 用友优普信息技术有限公司 | Formula resolving apparatus and method |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874243A (en) * | 2016-12-21 | 2017-06-20 | 武汉斗鱼网络科技有限公司 | Formula processing method and device based on character string |
| CN106874243B (en) * | 2016-12-21 | 2020-05-12 | 武汉斗鱼网络科技有限公司 | Formula processing method and device based on character string |
| CN109189385A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Algorithm configuration method, apparatus, computer equipment and storage medium |
| CN112394976A (en) * | 2020-10-16 | 2021-02-23 | 深圳市科漫达智能管理科技有限公司 | Formula self-defining configuration method and related device |
| CN112860464A (en) * | 2021-04-06 | 2021-05-28 | 深圳乐信软件技术有限公司 | Operation relation configuration method and device, computer equipment and storage medium |
| CN114357944A (en) * | 2021-12-17 | 2022-04-15 | 永中软件股份有限公司 | Layout method of large operator formula and computer device |
| CN114357944B (en) * | 2021-12-17 | 2024-02-20 | 永中软件股份有限公司 | Layout method of large operator formula and computer device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105405002A (en) | Formula data configuration method and system based on SAP platform | |
| US11144506B2 (en) | Compression of log data using field types | |
| CN102129425B (en) | The access method of big object set table and device in data warehouse | |
| CN109086126B (en) | Task scheduling processing method and device, server, client and electronic equipment | |
| US11151089B2 (en) | Compression of log data using pattern recognition | |
| CN108171528B (en) | Attribution method and attribution system | |
| CN103389895A (en) | Method and system for generating front end page | |
| CN111144089B (en) | Method and equipment for checking difference between part list and model file of design software | |
| JP2019512126A (en) | Method and system for training a machine learning system | |
| CN103164393B (en) | Report form formula disposal route and system | |
| CN110471754A (en) | Method for exhibiting data, device, equipment and storage medium in job scheduling | |
| CN105279613A (en) | Accounting affair processing method and system | |
| CN110635962A (en) | Abnormity analysis method and device for distributed system | |
| CN108874379B (en) | Page processing method and device | |
| CN103677852A (en) | Design method of extensible class natural language formula editor | |
| CN104123303A (en) | Method and device for providing data | |
| CN101894317B (en) | System and method for driving business logic through data changes | |
| CN103186384A (en) | Business-component-oriented software designing and analyzing system and using method thereof | |
| CN110020343A (en) | The determination method and apparatus of web page coding format | |
| CN111143461A (en) | Mapping relation processing system and method and electronic equipment | |
| CN106843822A (en) | One kind performs code generating method and equipment | |
| CN105068793A (en) | Method and apparatus for generating business logic relation diagram and realizing business application | |
| CN104731900A (en) | Hive scheduling method and device | |
| US10318937B2 (en) | Generating a product model | |
| CN110019198B (en) | Data query method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160316 |
|
| RJ01 | Rejection of invention patent application after publication |