WO2019109556A1

WO2019109556A1 - Cube file creation method, device, storage medium and terminal

Info

Publication number: WO2019109556A1
Application number: PCT/CN2018/081041
Authority: WO
Inventors: 温善安; 邓俊俊; 金鑫; 谭志杰; 陈宝花
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-12-08
Filing date: 2018-03-29
Publication date: 2019-06-13
Also published as: CN108255479B; CN108255479A

Abstract

The present application is applicable to the field of communication technologies and provides a cube file creation method, a device, a storage medium and a terminal. The method comprises: upon acquiring a creation instruction, acquiring a file index of a cube file to be created according to the creation instruction, outputting an entry window comprising a key information edit column of the cube file according to the file index; acquiring field values corresponding to the key information input by the file creator from the entry window; associating and storing the key information and corresponding field values thereof on the basis of a save instruction of the key information; and loading the key information and the corresponding field values thereof into a target XML file to generate a cube file. The present application realizes automated creation of cube files and simplifies operations for a file creator, thereby solving issues in the prior art of slowness and inefficiency during the creation of cube files.

Description

Cube file creation method, device, storage medium and terminal

This application is based on the Chinese Patent Application No. 201711291900.6, filed on Dec. 8, 2017, entitled "Cube File Creation Method, Apparatus, Storage Medium, and Terminal", and requires priority.

Technical field

The present application belongs to the field of communications technologies, and in particular, to a method, an apparatus, a storage medium, and a terminal for creating a cube file.

Background technique

Pentaho is currently the most popular open source business intelligence software. It is a workflow-focused BI suite that emphasizes solution-oriented rather than tool components. It brings together a large number of machine learning algorithms that can undertake data mining tasks, including preprocessing data. Classification, regression, clustering, correlation rule analysis, and visualization of data on an interactive interface. The cube files, ie data cubes and cube files, are a kind of multi-dimensional matrix, which can encapsulate multi-dimensional metadata from databases or files, which is convenient for users to explore and analyze data sets from multiple angles. When creating a cube file, the existing technology uses the schema-workbench component of the Pentaho component for development. You need to connect to the database, create a schema file, and then create a cube file, including:

1. Add a new cube file and name it;

2, add the fact table, named;

3. Add a dimension, expand the dimension to add dimension table data, modify the name of the dimension hierarchy attribute, set the primary key of the dimension table to be used to link with the fact table, and set the name displayed by the hierarchical attribute when the user uses the cube file;

4. Set related attribute information of the dimension, including the name given to the user, the name given to the programmer, and the field linked with the fact table;

5, add a hierarchy, set the relevant attribute information of the hierarchy, such as the name given to the user, the name given to the programmer, and the dimension attribute to be displayed in the dimension table;

6. Add metrics, set related attribute information of the metric, such as the name to be viewed by the user, the name to be viewed by the programmer, and the metric aggregation method.

At this point, the cube file is created, and the save control is selected to save the cube file. The steps are interlocked, the operation process is cumbersome, time-consuming, and inefficient. The salesperson who is not familiar with the schema-workbench component cannot independently create the cube file. .

Summary of the invention

The embodiment of the present invention provides a method, a device, a storage medium, and a terminal for creating a cube file, so as to solve the problem that the prior art is time-consuming and inefficient in creating a cube file.

An embodiment of the present application provides a method for creating a cube file, where the method includes:

Obtaining a file index of the cube file to be created according to the creation instruction, and outputting an input window of the key information editing column including the cube file according to the file index;

Obtaining, by the entry window, a field value corresponding to the key information input by the creator;

The key information-based save instruction associates and stores the key information and its corresponding field value;

The key information and its corresponding field values are loaded into the target XML file to generate a cube file.

Further, before the obtaining the creation instruction, before the file index of the cube file to be created is obtained according to the creation instruction, the creation method further includes:

Parse the cube file created by the Schema-workbenth tool to get the text format and key information;

A target XML file is generated according to the text format, and the key information is recorded as an editable item on the entry window.

Further, the loading the key information and its corresponding field value into the target XML file, and generating the cube file includes:

Obtaining a fact table in which the field value corresponding to the key information is located, and obtaining a database for verification according to the name of the fact table;

Generating a verification instruction based on the database;

Verifying, according to the verification instruction, whether the content in the target XML file is consistent with the table information recorded in the database;

If they are consistent, a cube file is generated based on the target XML file.

Further, the creating method further includes:

If the content in the target XML file does not match the table information recorded in the database, the prompt information is output.

Further, the entry window includes an Excel file;

In the Excel file, each key information is an editable item, including at least one edit bar.

The embodiment of the present application further provides a device for creating a cube file, and the device includes:

An editing module, configured to acquire a file index of a cube file to be created according to the creation instruction, and output an input window of a key information editing column that includes the cube file according to the file index;

An obtaining module, configured to obtain, by using the input window, a field value corresponding to the key information input by the creator;

a storage module, configured to associate and store the key information and its corresponding field value based on a save instruction of the key information;

And a generating module, configured to load the key information and its corresponding field value into the target XML file to generate a cube file.

Further, the creating device further includes:

A parsing module for parsing the cube file created by the Schema-workbenth tool to obtain a text format and key information;

And an index generating module, configured to generate a target XML file according to the text format, and record the key information as an editable item on the input window.

Further, the generating module further includes:

a database obtaining unit, configured to obtain a fact table in which the field value corresponding to the key information is located, and obtain a database for verification according to the name of the fact table;

a verification unit, configured to generate a verification instruction based on the database, and verify, according to the verification instruction, whether the content in the target XML file is consistent with the table information recorded in the database;

a generating unit, configured to generate a cube file based on the target XML file if the content in the target XML file is consistent with the table information recorded in the database;

The prompting unit is configured to output prompt information if the content in the target XML file is inconsistent with the table information recorded in the database.

The embodiment of the present application further provides one or more non-volatile readable storage media storing computer readable instructions, when the computer readable instructions are executed by one or more processors, such that the one or more The processor performs the following steps:

The embodiment of the present application further provides a terminal, where the terminal includes a memory, a processor, and computer readable instructions stored on the memory and executable on the processor, where the processor executes the calculated readable instruction sequence Implement the following steps:

Details of one or more embodiments of the present application are set forth in the accompanying drawings and description below. Other features and advantages of the present invention will be apparent from the description, drawings and claims.

DRAWINGS

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings to be used in the embodiments or the prior art description will be briefly described below. Obviously, the drawings in the following description are only It is a certain embodiment of the present application, and other drawings can be obtained according to the drawings without any creative work for those skilled in the art.

1 is a first implementation flowchart of a method for creating a cube file according to an embodiment of the present application;

2 is a second implementation flowchart of a method for creating a cube file according to an embodiment of the present application;

3 is a third implementation flowchart of a method for creating a cube file according to an embodiment of the present application;

4 is a structural diagram of a device for creating a cube file according to an embodiment of the present application;

FIG. 5 is a schematic diagram of a terminal provided by an embodiment of the present application.

Detailed ways

In order to make the objects, technical solutions, and advantages of the present application more comprehensible, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.

Example 1

FIG. 1 shows a first implementation flow of a method for creating a cube file provided by an embodiment of the present application.

In the embodiment of the present application, the method for creating a cube file is applied to a terminal, including but not limited to a computer, a server, and the like.

Referring to FIG. 1, the method for creating a cube file includes:

In step S101, when the creation instruction is acquired, the file index of the cube file to be created is acquired according to the creation instruction, and the input window of the key information editing column including the cube file is output according to the file index.

The embodiment of the present application replaces the original schema-workbenth component by an editing tool developed by itself. The editing tool works by skipping the creator's operation steps on the schema-workbenth component and directly acquiring the key information in the cube file to be created to automatically generate the cube file. The key information is obtained through a preset entry window. Optionally, the entry window includes an Excel file; in the Excel file, each key information is an editable item, including at least one edit bar, the edit bar is used to instruct the creator to input the to-be-created The key information of the cube file. Different from the prior art, when the creation instruction of the cube file is obtained, the embodiment of the present application first obtains the file index according to the creation instruction. The file index is index information of the cube file to be created, including but not limited to the name of the cube file to be created, key information, target XML file, and the like. The entry window is then output according to the key information to prompt the creator to edit the cube file by filling the edit bar on the window.

In step S102, a field value corresponding to the key information input by the creator is obtained through the entry window.

Here, the fact table, dimension table, aggregation table, etc. of the multidimensional data are stored in the database, belonging to the physical model, and the concepts of the data cube, the dimension, and the metric are logical models. The multidimensional analysis engine must understand the logical model and be able to map to the physical model. The multidimensional data model, the cube file, is used to describe this logical model and the mapping to the physical model. In the embodiment of the present application, the key information is description information of the cube file to the logical model, including but not limited to Dimension dimension information, Hierarchy level information, Level level information, and Measure metric information of the physical model. On the entry window, each key information corresponds to at least one edit field, and the creator inputs information such as Dimension, Level, and Measure corresponding to the cube file to be created on the edit bar as needed. The dimension information is a table name of the database, and is a set of hierarchical Hierarchy. The dimension of one aspect generally corresponds to at least one dimension table (Dimension Table), that is, a table storing dimension data. Illustratively, common dimensions include, but are not limited to, time, region, product, and the like. Taking the time dimension as an example, the contents of the dimension table include but are not limited to fields such as date_tk, year, quarter, month, week, day_of_month, day_of_year, and these fields are the levels below the dimension. The contents of the area dimension table include but are not limited to fields such as region_tk, country, province, city, and district.

In step S103, the key information and its corresponding field value are associated and stored based on the save instruction of the key information.

In the embodiment of the present application, the save function identifier is provided on the entry window. If the creator finishes editing the key information on the entry window, the save function identifier may be triggered by a specified gesture operation to input a save instruction.

When the save instruction is obtained, the key information on the entry window and the current field value in the corresponding edit field are associated, and then stored in the specified storage medium to save the creator's edit operation.

In step S104, the key information and its corresponding field value are loaded into the target XML file to generate a cube file.

Here, the target XML file is a template file of the cube file to be created, wherein the content of the key information is in a vacant state, to be filled. After detecting that the creator edits a certain key information on the entry window, the embodiment of the present application automatically fills in the field value input by the creator to the corresponding vacancy position in the target XML file. . Iterate through all the key information on the input window and its corresponding field values, and perform the save operation after filling out to generate the cube file.

Exemplarily, it is assumed that the user inputs the field value StandardDimension in the edit field corresponding to the key information Dimension in the entry window, and enters the field value DIM_RPT_HCPMS_PERIOD in the edit field corresponding to the key information Hierarchy, and the edit column corresponding to the key information level The field values YEAR_ID, QUTER_ID, and MONTH_ID are entered, and are automatically filled in the target XML file. The example is as follows, in which the italic part is the filled field value; finally, the save operation is performed to generate the cube file.

<Hierarchyname="DIM_RPT_HCPMS_PERIOD"visible="true"hasAll="true"primaryKey="PERIOD_ID"caption="日期维">

</Table>

<Levelname="YEAR_ID"visible="true"column="YEAR_ID"

nameColumn="YEAR_NAME"type="String"uniqueMembers="false"levelType="R egular"hideMemberIf="Never"caption="年">

</Level>

<Levelname="QUTER_ID"visible="true"column="QUTER_ID"nameColumn="QUTER_NAME"type="String"uniqueMembers="false"levelType="Regular"hideMemberIf="Never"caption="季&# 24230;">

</Level>

<Levelname="MONTH_ID"visible="true"column="MONTH_ID"nameColumn="MONTH_NAME"type="String"uniqueMembers="false"levelType="Regular"hideMemberIf="Never"caption="月&# 20221;">

</Level>

</Hierarchy>

</Dimension>

In summary, the embodiment of the present application can realize the mass production by editing the key information of the cube file through the input window, thereby improving the efficiency of creating the cube file, and only the creator needs to fill in the edit column according to the given format, and does not need to perform other operations. The terminal automatically generates a cube file according to the input key information, thereby automatically creating a cube file; and does not need to load data such as fact table, dimension table, etc. from the database, and save the content in the input window, without additional Caching mechanism.

Further, based on the first implementation flow of the method for creating a cube file provided in FIG. 1 , a second implementation flow of the method for creating a cube file provided by the embodiment of the present application is proposed.

As shown in FIG. 2, it is a second implementation flowchart of a method for creating a cube file provided by an embodiment of the present application. When a creation instruction is acquired, the file index of the cube file to be created is obtained according to the creation instruction, and the creation is performed. The method also includes:

In step S201, the cube file created by the Schema-workbenth tool is parsed to obtain a text format and key information.

Here, the created cube file is a historical cube file created by the prior art using the Schema-workbenth tool. Since the cube file follows the format of the XML file, it does not need to be compiled during parsing. It only needs to analyze the code rules of the cube file to get the text format and key information. Alternatively, the XML file can be analyzed and processed using OCR technology. The text format is a grammar rule of a code in a cube file, and the key information is a description information of a cube file to a logical model, including but not limited to Dimension dimension information of a physical model, Hierarchy level information, Level level information, and Measure metric. information.

In step S202, a target XML file is generated according to the text format, and the key information is recorded as an editable item on the entry window.

In the embodiment of the present application, the target XML file and the editable item together constitute a file index of the cube file. The key information in the generated target XML file is a vacant state, and is to be filled, thereby obtaining a template file of the cube file, so that the cube file is created without generating the cube file according to the creation step of the Schema-workbenth tool to implement the cube. Batch creation of files. The key information is then recorded as an editable item when editing the cube file, and the editable items define an edit bar which should include key information in the entry window output according to the creation instruction, so that the creator can intuitively edit the key information. To achieve batch editing of cube files.

Steps S203 to S206, wherein the steps S203 to S206 are the same as the steps S101 to S104 described in the embodiment of the present invention. For details, refer to the description of the foregoing embodiment, and details are not described herein again.

Here, the embodiment of the present application generates an object XML file and an editable item by parsing an existing cube file, and the editable item is used to define an edit bar on the entry window, thereby realizing completion of the key on the entry window. The editing operation of the information is more intuitive and convenient than the prior art to create a cube file according to the creation process of the Schema-workbenth tool, which improves the experience of the creator.

Further, based on the first implementation flow of the method for creating a cube file provided in FIG. 1 , a third implementation flow of the method for creating a cube file provided by the embodiment of the present application is proposed.

As shown in FIG. 3, it is a third implementation flowchart of a method for creating a cube file provided by an embodiment of the present application. The step S104 loads the key information and its corresponding field value into a target XML file to generate a cube file. include:

In step S1041, the fact table in which the field value corresponding to the key information is located is obtained, and the database for verification is obtained according to the name of the fact table.

Here, after loading the field value into the target XML file, you can save the operation to get the cube file that can be recognized by the report. The embodiment of the present application may also obtain a fact table storing the field values, and trace the storage path according to the name of the fact table, obtain a database that stores the fact table, and determine a range of the verification. The fact table (Fact Table), that is, the data table, refers to a table that stores data from the business.

In step S1042, a verification instruction is generated based on the database.

Here, the verification instruction is an SQL statement for verifying the accuracy of the target XML file in the database. After obtaining the database, the embodiment of the present application generates an SQL statement based on the database to perform a verification operation on the target XML file.

In step S1043, it is verified whether the content in the target XML file is consistent with the table information recorded in the database according to the verification instruction.

When the verification instruction is executed, the key information loaded in the target XML file is traversed, and each key information is compared with the table information recorded in the database, and the field value and the table information of the key information are determined. Consistent to verify the accuracy of the target XML file.

In step S1044, if they match, a cube file is generated based on the target XML file.

If the key information in the target XML file is consistent with the table information recorded in the database, indicating that the key information in the target XML file is correct, the save operation is performed to generate a cube file.

Optionally, the creating method further includes:

In step S1045, if the content in the target XML file does not match the table information recorded in the database, the prompt information is output.

In the result of the comparison, if one or more key information in the target XML file is inconsistent with the table information recorded in the database, it indicates that the field value corresponding to the key information is incorrect, and there is no maptable fact table, and the prompt is output. information. Here, the prompt information includes, but is not limited to, a pop-up alert window, and all the key information of the verification failure is displayed through the alert window, and the current cube file creation process is suspended.

In the embodiment of the present application, by verifying the field value of the key information, the accuracy of the key information acquired through the input window is ensured, and the validity of the generated cube file is ensured, which is favorable for eliminating the entry in the entry. Invalid cube file caused by incorrect input on the window.

It should be understood that, in the foregoing embodiments, the size of the serial number of each step does not mean the order of execution order, and the order of execution of each step should be determined by its function and internal logic, and should not constitute any implementation process of the embodiment of the present application. limited.

Example 2

FIG. 4 is a structural diagram of a device for creating a cube file according to an embodiment of the present application. For the convenience of description, only parts related to the embodiment of the present application are shown.

In the embodiment of the present application, the device for creating a cube file is used to implement the method for creating a cube file described in the foregoing embodiments of FIG. 1, FIG. 2, and FIG. 3, and may be a software unit and a hardware unit built in the terminal. A unit combining hardware and software, the terminal including but not limited to a computer, a server, and the like.

Referring to FIG. 4, the device for creating a cube file includes:

The editing module 41 is configured to acquire a file index of the cube file to be created according to the creation instruction, and output an input window of the key information editing column that includes the cube file according to the file index;

The obtaining module 42 is configured to obtain, by using the input window, a field value corresponding to the key information input by the creator;

The storage module 43 is configured to associate and store the key information and its corresponding field value based on the save instruction of the key information;

The generating module 44 is configured to load the key information and its corresponding field value into the target XML file to generate a cube file.

Wherein, the entry window includes an Excel file;

Optionally, the creating device further includes:

The parsing module 45 is configured to parse the cube file created by the Schema-workbenth tool to obtain a text format and key information;

The index generating module 46 is configured to generate a target XML file according to the text format, and record the key information as an editable item on the input window.

Optionally, the generating module 44 further includes:

The database obtaining unit 441 is configured to obtain a fact table in which the field value corresponding to the key information is located, and obtain a database for verification according to the name of the fact table;

The verification unit 442 is configured to generate a verification instruction based on the database, and verify, according to the verification instruction, whether the content in the target XML file is consistent with the table information recorded in the database;

a generating unit 443, configured to generate a cube file based on the target XML file if the content in the target XML file is consistent with the table information recorded in the database;

The prompting unit 444 is configured to output prompt information if the content in the target XML file does not match the table information recorded in the database.

It should be noted that each module/unit in the embodiment of the present application may be used to implement all the technical solutions in the foregoing method embodiments, and the specific working process may refer to the corresponding process in the foregoing method embodiments, and details are not described herein again. .

In the above embodiments, the descriptions of the various embodiments are different, and the parts that are not detailed or described in a certain embodiment can be referred to the related descriptions of other embodiments.

Example 3

This embodiment provides one or more non-volatile readable storage media having computer readable instructions stored thereon. The one or more non-transitory readable storage mediums storing computer readable instructions, when executed by one or more processors, causing one or more processors to execute the cube files of embodiment 1. Create a method, to avoid duplication, no longer repeat here. Alternatively, when the computer readable instructions are executed by the processor, the functions of the modules/units in the device for creating the cube file in the embodiment 2 are implemented. To avoid repetition, details are not described herein again.

It will be understood that one or more non-volatile readable storage media storing computer readable instructions may comprise: any entity or device capable of carrying the computer readable instructions, a recording medium, a USB flash drive, a mobile hard drive, a magnetic Discs, optical discs, computer memories, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier signals, and telecommunications signals.

Example 4

FIG. 5 is a schematic diagram of a terminal according to an embodiment of the present disclosure, where the terminal includes but is not limited to a server and a mobile terminal. As shown in FIG. 5, the terminal 5 of this embodiment includes a processor 50, a memory 51, and computer readable instructions 52 stored in the memory 51 and executable on the processor 50. The processor 50 executes the computer readable instructions 52 to implement the steps in the foregoing method for creating a cube file, such as steps S101 to S104 shown in FIG. 1 and steps S201 to S206 in the embodiment of FIG. Steps S1041 to S1045 described in the embodiment of FIG. 3; or, when the processor 50 executes the computer readable instructions 52, the functions of the modules/units in the apparatus for creating a cube file are implemented, for example, FIG. The functions of the modules 41 to 46 shown.

The above-mentioned embodiments are only used to explain the technical solutions of the present application, and are not limited thereto; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that they can still implement the foregoing embodiments. The technical solutions described in the examples are modified or equivalently replaced with some of the technical features; and the modifications or substitutions do not deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in Within the scope of protection of this application.

Claims

A method for creating a cube file, the method for creating the method includes:

Obtaining a file index of the cube file to be created according to the creation instruction, and outputting an input window of the key information editing column including the cube file according to the file index;

Obtaining, by the entry window, a field value corresponding to the key information input by the creator;

The key information-based save instruction associates and stores the key information and its corresponding field value;

The key information and its corresponding field values are loaded into the target XML file to generate a cube file.
The method for creating a cube file according to claim 1, wherein the method for creating a file of the cube file to be created is obtained according to the creation instruction, and the method for creating the method further includes:

Parse the cube file created by the Schema-workbenth tool to get the text format and key information;

A target XML file is generated according to the text format, and the key information is recorded as an editable item on the entry window.
The method for creating a cube file according to claim 1, wherein the loading the key information and its corresponding field value into a target XML file, and generating a cube file comprises:

Obtaining a fact table in which the field value corresponding to the key information is located, and obtaining a database for verification according to the name of the fact table;

Generating a verification instruction based on the database;

Verifying, according to the verification instruction, whether the content in the target XML file is consistent with the table information recorded in the database;

If they are consistent, a cube file is generated based on the target XML file.
The method for creating a cube file according to claim 3, wherein the creating method further comprises:

If the content in the target XML file does not match the table information recorded in the database, the prompt information is output.
The method for creating a cube file according to any one of claims 1 to 4, wherein the entry window includes an Excel file;

In the Excel file, each key information is an editable item, including at least one edit bar.
A device for creating a cube file, characterized in that the device comprises:

An editing module, configured to acquire a file index of a cube file to be created according to the creation instruction, and output an input window of a key information editing column that includes the cube file according to the file index;

An obtaining module, configured to obtain, by using the input window, a field value corresponding to the key information input by the creator;

a storage module, configured to associate and store the key information and its corresponding field value based on a save instruction of the key information;

And a generating module, configured to load the key information and its corresponding field value into the target XML file to generate a cube file.
The device for creating a cube file according to claim 6, wherein the creating device further comprises:

A parsing module for parsing the cube file created by the Schema-workbenth tool to obtain a text format and key information;

And an index generating module, configured to generate a target XML file according to the text format, and record the key information as an editable item on the input window.
The device for creating a cube file according to claim 6, wherein the generating module further comprises:

a database obtaining unit, configured to obtain a fact table in which the field value corresponding to the key information is located, and obtain a database for verification according to the name of the fact table;

a verification unit, configured to generate a verification instruction based on the database, and verify, according to the verification instruction, whether the content in the target XML file is consistent with the table information recorded in the database;

a generating unit, configured to generate a cube file based on the target XML file if the content in the target XML file is consistent with the table information recorded in the database;
The device for creating a cube file according to claim 8, wherein the generating module further comprises:

The prompting unit is configured to output prompt information if the content in the target XML file is inconsistent with the table information recorded in the database.
The apparatus for creating a cube file according to any one of claims 6 to 9, wherein the entry window includes an Excel file;

In the Excel file, each key information is an editable item, including at least one edit bar.
One or more non-transitory readable storage mediums storing computer readable instructions, wherein when the computer readable instructions are executed by one or more processors, cause the one or more processors to execute The following steps:

Obtaining a file index of the cube file to be created according to the creation instruction, and outputting an input window of the key information editing column including the cube file according to the file index;

Obtaining, by the entry window, a field value corresponding to the key information input by the creator;

The key information-based save instruction associates and stores the key information and its corresponding field value;

The key information and its corresponding field values are loaded into the target XML file to generate a cube file.
The non-volatile readable storage medium according to claim 11, wherein, when the creation instruction is acquired, the computer readable instruction is obtained by acquiring a file index of the cube file to be created according to the creation instruction When the plurality of processors are executed, the one or more processors are further configured to perform the following steps:

Parse the cube file created by the Schema-workbenth tool to get the text format and key information;

A target XML file is generated according to the text format, and the key information is recorded as an editable item on the entry window.
The non-volatile readable storage medium according to claim 11, wherein said loading said key information and its corresponding field value into a target XML file, and generating a cube file comprises:

Obtaining a fact table in which the field value corresponding to the key information is located, and obtaining a database for verification according to the name of the fact table;

Generating a verification instruction based on the database;

Verifying, according to the verification instruction, whether the content in the target XML file is consistent with the table information recorded in the database;

If they are consistent, a cube file is generated based on the target XML file.
The non-volatile readable storage medium of claim 13 wherein said computer readable instructions are executed by one or more processors such that said one or more processors further perform the steps of:

If the content in the target XML file does not match the table information recorded in the database, the prompt information is output.
The non-volatile readable storage medium according to any one of claims 11 to 14, wherein the entry window includes an Excel file;

In the Excel file, each key information is an editable item, including at least one edit bar.
A terminal, the terminal comprising a memory, a processor, and computer readable instructions stored on the memory and executable on the processor, wherein the processor executes the computer readable instructions to implement the following steps:

Obtaining a file index of the cube file to be created according to the creation instruction, and outputting an input window of the key information editing column including the cube file according to the file index;

Obtaining, by the entry window, a field value corresponding to the key information input by the creator;

The key information-based save instruction associates and stores the key information and its corresponding field value;

The key information and its corresponding field values are loaded into the target XML file to generate a cube file.
The terminal according to claim 16, wherein, when the file creation index of the cube file to be created is acquired according to the creation instruction, the processor executes the computer readable instruction step:

Parse the cube file created by the Schema-workbenth tool to get the text format and key information;

A target XML file is generated according to the text format, and the key information is recorded as an editable item on the entry window.
The terminal according to claim 16, wherein said loading said key information and its corresponding field value into a target XML file, and generating a cube file comprises:

Obtaining a fact table in which the field value corresponding to the key information is located, and obtaining a database for verification according to the name of the fact table;

Generating a verification instruction based on the database;

Verifying, according to the verification instruction, whether the content in the target XML file is consistent with the table information recorded in the database;

If they are consistent, a cube file is generated based on the target XML file.
The terminal according to claim 18, wherein said processor further implements the following steps when said computer readable instructions are executed:

If the content in the target XML file does not match the table information recorded in the database, the prompt information is output.
The terminal according to any one of claims 16 to 19, wherein the entry window includes an Excel file;

In the Excel file, each key information is an editable item, including at least one edit bar.