A Query Method for Hierarchical Node Data

Abstract

The invention discloses a method for querying hierarchical node data. By using the method, MDX (multidimensional expressions) statements, BWETL (band width extract transform and load) data extracting and RFC (request for comment) remote functions are invoked integrally, the hierarchical node data are queried, hierarchical nodes are inputted, and queried nodes are inputted on a data retrieval platform. The method for querying hierarchical node data comprises the following steps of examination on authorization: verifying authorization of inputted nodes and personnel using the method; parameter transmitting: transmitting parameters to a function if verification passes and performing specific data extracting operation; executing on a node report: invoking a BWQUERY node report according to the parameters after the parameters are received by the function; invoking of the MDX statements: invoking the MDX statements if data of the inputted nodes exist, transmitting the running result of the report to an inner table of the function and maintaining the running result as a queried parameter; and returning of the result: reading data from a DSO (digital storage oscilloscope) model according to the node parameters and limiting conditions of the function, and returning the result to the data retrieval platform to obtain the hierarchical node data. By using the method, the data acquisition efficiency is improved, and data uploading is stable.

Description

technical field [0001] The invention belongs to the field of electric power, and in particular relates to a method for querying hierarchical node data aimed at the large amount of data query of hierarchical nodes. Background technique [0002] SAP ERP system is a set of enterprise management software developed by Germany's SAP company. The system has complete applications for daily management of enterprises. Through configuration, seamless data integration between applications can be realized. Enterprise data display platforms often need to extract corresponding data from the SAP ERP system for daily analysis. The existing technology provides data to third parties directly through RFC functions. The main disadvantage is that the transmission speed of large data volumes is relatively slow, and the processing of complex logic comparisons Difficulties, many query analysis had to be given up because users could not get effective response time, which was a big blow to the enterpr...

AI Technical Summary

Problems solved by technology

Enterprise data display platforms often need to extract corresponding data from the SAP ERP system for daily analysis. The existing technology provides data to third parties directly through RFC functions. The main disadvantage is that the transmission speed of large data volumes is relatively slow, and the processing of complex logic comparisons Difficult, many queries and analyzes have to be given up because users cannot get effective response time, which is a big blow to the informatization construction of enterprises

The link that affects data reading is mainly because the recursive call of hierarchical nodes is relatively slow, which restricts the acquisition of data. However, it is inevitable to read data on the hierarchical structure and interpret the level of each node. A better method is needed. The implementation method to deal with this kind of problem

Images