WO2019205347A1 - 报表模块创建方法、装置、计算机装置及存储介质 - Google Patents

报表模块创建方法、装置、计算机装置及存储介质 Download PDF

Info

Publication number
WO2019205347A1
WO2019205347A1 PCT/CN2018/099778 CN2018099778W WO2019205347A1 WO 2019205347 A1 WO2019205347 A1 WO 2019205347A1 CN 2018099778 W CN2018099778 W CN 2018099778W WO 2019205347 A1 WO2019205347 A1 WO 2019205347A1
Authority
WO
WIPO (PCT)
Prior art keywords
storage
refresh
report
created
application
Prior art date
Application number
PCT/CN2018/099778
Other languages
English (en)
French (fr)
Inventor
杨勇
宋剑锋
钟宇料
王佛清
Original Assignee
平安科技（深圳）有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 平安科技（深圳）有限公司 filed Critical 平安科技（深圳）有限公司
Publication of WO2019205347A1 publication Critical patent/WO2019205347A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/604—Tools and structures for managing or administering access control systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
    • G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices

Definitions

  • the present application relates to the field of data mining technologies, and in particular, to a method, a device, a computer device, and a storage medium for creating a report module.
  • BI analysis tools also known as BI tools
  • the BI tool is a tool that effectively integrates the system data applied in the enterprise and provides reports quickly and accurately. It can help users understand the required enterprise information and help users make business decisions.
  • Common BI reporting systems are Cognos, OBIEE, BO, etc. At present, when a new report module is added to the BI tool, a large amount of manual configuration is required, for example, data entry for user class permission is performed in the database. This makes it time consuming and inefficient to create report modules in BI tools.
  • the application provides a method for creating a report module, the method comprising:
  • the report directory of the to-be-created report is created in the corresponding user interaction interface of the application, so that the user accesses the to-be-created report through the report directory according to the entered user class permission.
  • the application further provides a report module creation device, the device comprising:
  • the permission entry module is configured to receive a user class permission entry instruction, and enter a user class permission of the to-be-created report according to the user class permission information included in the user class permission entry instruction;
  • a first creating module configured to access a refresh storage, and a refresh directory of the to-be-created report is created in the refresh storage, where the refresh directory is used to store a file related to the report refresh to be created;
  • a second creation module configured to access an application storage corresponding to the refresh storage, and create a new soft link in the application storage corresponding to the refresh storage, where the soft link is used to point to a refresh directory of the report to be created;
  • the third creating module is configured to create a report directory of the to-be-created report in the corresponding user interaction interface of the application, so that the user accesses the to-be-created report through the report directory according to the entered user class permission.
  • the application further provides a computer device comprising a memory and a processor, the memory for storing at least one instruction, the processor for executing the at least one instruction to implement the report described in any embodiment Module creation method.
  • the present application also provides a non-volatile readable storage medium, wherein the non-volatile readable storage medium stores at least one instruction, which is implemented in any embodiment when executed by a processor The method for creating a report module.
  • the application enters a user class permission input instruction, and enters the user class permission of the to-be-created report according to the user class permission information included in the user class permission entry instruction; accessing the refresh storage, in the refresh storage Creating a refreshing directory of the to-be-created report, where the refreshing directory is used to store a file related to the refreshing of the to-be-created report; accessing the application storage corresponding to the refreshing storage, and newly creating an application storage corresponding to the refreshing storage a soft link, the soft link is used to point to the refresh directory of the report to be created; the report directory of the report to be created is newly created in the corresponding user interaction interface of the application store, so that the user passes the user class permission according to the entered user class
  • the report directory accesses the report to be created.
  • the user class permission entry is performed according to the user class permission input instruction, and the refresh directory is created according to the automatic access refresh storage, and the application store is automatically accessed to create a soft link, and finally the report directory of the report to be created is newly created in the user interaction interface corresponding to the application store. , so that users can access the report directory of the report to be created according to the permissions that have been entered.
  • the configuration task of the report module from the server and the storage to the client is completed, the report module is created, and a large number of manual operations are not required by the user during the creation process, which greatly improves the creation efficiency of the report module.
  • FIG. 1 is a flowchart of a method for creating a report module according to an embodiment of the present application
  • FIG. 2 is a functional block diagram of a report module creation apparatus according to an embodiment of the present application.
  • FIG. 3 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of a method for creating a report module according to the present application.
  • FIG. 1 is a flowchart of a method for creating a report module according to an embodiment of the present application. The order of the steps in the flowchart may be changed according to different requirements, and some steps may be omitted.
  • the method described in the present application can be applied to the creation of a report module in a BI tool. For example, create a report module in Cognos.
  • a report is a functional module that displays information that has been discovered or predicted in the business process of a company in the form of a chart or data for the operator to understand the business situation of the company. For example, in the functional module of the report, the sales of personal life care, home care, food and beverage products in Brazil, China and India are shown graphically.
  • the permissions can be used to control the reports that can be viewed by people of different roles.
  • the financial statements that the finance director can see are statement A, statement B, statement C, and statement D.
  • the financial statement that another ordinary employee of the finance department can see is financial statement A.
  • financial statement B does not have the authority to view financial statement C and financial statement D.
  • the above user class authority information may include which type of user has which rights.
  • the above report to be created is the report module to be created.
  • the user class permission entry instruction may be a permission entry instruction in the form of a sql script statement, and is used for user class permission entry.
  • the type of user is defined by the sql script statement, and each type of user is given certain permissions.
  • user types include senior supervisor class, intermediate supervisor class, and general employee class.
  • the report that the user with the permission can view is the report M with the attribute m, the report N with the attribute n, the report X with the attribute x, and the report Y with the attribute y; when the user It belongs to the intermediate supervisor class.
  • the report that users with such permissions can view is report M with attribute m and report N with attribute n.
  • the report that users with such permission can view is only Report M with attribute m.
  • the method of the present application further includes: acquiring the personnel structure information of the application body; creating a user class authority according to the personnel structure information, triggering the user class permission input instruction .
  • steps in this embodiment may be performed before step S10.
  • the above application body refers to a unit body that implements the BI tool.
  • the application body is a company.
  • the personnel structure information of the application subject may include information such as which departments are included in the application body, and the personnel composition of each department.
  • the above-mentioned creation of the user class authority according to the personnel structure information may specifically be: determining different management level according to the personnel structure, thereby assigning different user class rights.
  • different user class rights can also be assigned according to their work functions.
  • each management level can assign different user class rights according to the authority.
  • the user class permission is quickly determined, and then the user class permission is entered.
  • the user class permission is entered.
  • a large-scale company it usually has the characteristics of many people and complicated structure. Through this embodiment, the efficiency of a large-scale company in the entry of user rights can be greatly improved.
  • the storage may also be referred to as Network Attached Storage (NAS).
  • NAS Network Attached Storage
  • the above refresh storage may be storage for a model refresh or storage in a server for refreshing.
  • the refresh directory includes but is not limited to: a model subdirectory (also referred to as a model folder), a refresh file subdirectory (also referred to as a refresh folder), and a log subdirectory (also referred to as a log folder).
  • the subdirectory to be released also known as the folder to be published).
  • the model sub-directory is used to store the new model, which is used to define how the data is organized and what the structure of the data is.
  • the file subdirectory is refreshed and used to store the file generated when the model is refreshed. That is, the refresh directory can be used as the execution location when the model is refreshed.
  • a log subdirectory for storing logs during the refresh process is provided.
  • the subdirectory to be published is used to store the data cube file generated by the report refresh.
  • the data cube file is also known as the Cube file.
  • the new model can be stored in the model subdirectory, and then refreshed in the refresh directory, and the refreshed data cube file is saved to the subdirectory to be published for use in the report.
  • the user can view the log file through the file saved in the log subdirectory.
  • the refresh storage includes at least two storage areas
  • the refresh directory for creating the report to be created in the refresh storage in the step S20 includes:
  • the foregoing refresh storage includes at least two storage areas, that is, the refresh storage includes a separate at least two memories, or the refresh storage (for one memory) includes a plurality of partitioned storage areas.
  • the above-mentioned application body refers to a unit body that implements the BI tool.
  • the application body is a company.
  • the service classification information of the application subject may be a service classification or a product classification of a unit entity that implements the BI tool.
  • a group company has three subsidiaries that operate different businesses, and each subsidiary corresponds to one storage area to obtain the correspondence between each service category and the storage area included in the refresh storage.
  • a company corresponds to AA storage
  • b company corresponds to BB storage
  • c company corresponds to CC storage
  • new model subdirectory, refresh file subdirectory, log subdirectory on the CC storage And the sub-directory to be released is used for the reporting service of company c.
  • the correspondence between the service category and the storage area may be preset.
  • a corresponding directory can be created for each service category in the application scenario of multiple service categories for report refresh. Moreover, with the application, the corresponding service category can be automatically divided and the corresponding refresh directory is automatically created, thereby improving the efficiency of the creation of the report module.
  • the obtaining the correspondence between each service category and the storage area included in the refresh storage includes:
  • the historical data of the foregoing service category is the business data generated by the service category in the past period of time.
  • the storage area corresponding to each service category is determined according to the historical service data of each service category and the storage capacity of each storage area.
  • the storage capacity of a certain storage area is greater than or equal to the historical service data of a certain service category, It is determined that the storage area corresponds to storing historical data of the service category.
  • the storage area corresponding to each service category is determined according to the historical business data from large to small.
  • the corresponding relationship between the service module and the refresh storage obtained by the embodiment is more in line with the actual service requirement, and the problem that the report cannot be refreshed due to insufficient space for refreshing the storage during the process of refreshing the report is avoided, and the report running after the report module is created is improved. stability.
  • the obtaining the correspondence between each service category and the storage area included in the refresh storage includes:
  • the service attributes of the service category may include, but are not limited to, the service size of the service category, the operation time of the service module, and the like.
  • the business size of the business category may include the size of the person in the business category, operating profit, product type, and the like.
  • the refresh storage is divided according to the service attributes of the service category, and a storage area having a sufficient storage capacity can be allocated for each service type. The problem of unable to refresh due to insufficient space for refreshing the storage during the report refresh process is avoided, and the stability of the report running after the report module is created is improved.
  • the above application storage may be a storage for a report application or a storage for an application.
  • the refresh storage and the application storage may be in the same storage medium or may be in different storage media.
  • the application storage acquires the data cube from the corresponding refresh storage at the time of execution.
  • the above soft link can also be called a symbolic link.
  • a soft link is a link file, that is, a link file pointing to an address.
  • the soft link is used to point to the refresh directory of the report to be created.
  • the soft link refers to the newly created refresh directory in the refresh storage in step S20, that is, the soft link is newly created in the refresh storage corresponding to the application storage.
  • the link file for the refresh directory Therefore, the newly created refresh directory in the refresh store corresponding to the application store can be accessed through the newly created soft link.
  • the application storage may also include at least two application storage areas corresponding thereto.
  • the accessing the application storage corresponding to the refresh storage, and creating a new soft link in the application storage corresponding to the refresh storage includes:
  • the application storage area corresponding to each storage area of the refresh storage is polled, and a soft link is created on each application storage area.
  • a soft link is created on the application storage area corresponding to each storage area of the refreshed storage to point to the subdirectory to be distributed, and a data cube file generated after the refresh can be obtained.
  • S40 Create a report directory of the to-be-created report in the corresponding user interaction interface of the application, so that the user accesses the to-be-created report through the report directory according to the entered user class permission.
  • the user interaction interface is a client interface operated by a user who views the report (for example, a supervisor of the finance department) when using the report module of the BI tool, and is also an interface of the client corresponding to the application storage.
  • Creating a report directory of the report to be created on the user interface allows the user to directly access the report function of the BI tool through the report directory, and then view the report. Specifically, after the creation of the report module is completed through steps S10 to S40, the user can access the report with the permission according to the user class permission that has been entered.
  • the refresh data of the backend server (or the server and the storage) is refreshed to obtain the report data, and then displayed on the user interaction interface, thereby providing the report service for the user.
  • the method for creating a report module receives the user class permission input instruction, and enters the user class permission of the to-be-created report according to the user class permission information included in the user class permission entry instruction; accesses the refresh storage, and creates a new office in the refresh storage.
  • the refreshing directory is configured to store a file related to the refreshing of the to-be-created report; accessing an application storage corresponding to the refreshing storage, and creating a new soft link in the application storage corresponding to the refreshing storage
  • the soft link is used to point to the refresh directory of the report to be created; the report directory of the report to be created is newly created in the corresponding user interaction interface of the application store, so that the user passes the The report directory accesses the report to be created.
  • the user class permission entry is performed according to the user class permission input instruction, and the refresh directory is created according to the automatic access refresh storage, and the application store is automatically accessed to create a soft link, and finally the report directory of the report to be created is newly created in the user interaction interface corresponding to the application store. , so that users can access the report directory of the report to be created according to the permissions that have been entered.
  • the configuration task of the report module from the server and the storage to the client is completed, the report module is created, and a large number of manual operations are not required by the user during the creation process, which greatly improves the creation efficiency of the report module.
  • FIG. 2 is a functional block diagram of a report module creation apparatus according to an embodiment of the present application.
  • the report module creation device includes a rights entry module 210, a first creation module 220, a second creation module 230, and a third creation module 240.
  • a module as referred to herein refers to a series of computer readable instruction segments that can be executed by a processor of a computer device and that are capable of performing a fixed function, which are stored in a memory of the computer device.
  • the functions of the respective modules will be described in detail in the subsequent embodiments.
  • the permission entry module 210 is configured to receive a user class permission entry instruction, and enter a user class permission of the to-be-created report according to the user class permission information included in the user class permission entry instruction.
  • the apparatus described herein can be used to create a report module in a BI tool. For example, create a report module in Cognos.
  • a report is a functional module that displays information that has been discovered or predicted in the business process of a company in the form of a chart or data for the operator to understand the business situation of the company. For example, in the functional module of the report, the sales of personal life care, home care, food and beverage products in Brazil, China and India are shown graphically.
  • the permissions can be used to control the reports that can be viewed by people of different roles.
  • the financial statements that the finance director can see are statement A, statement B, statement C, and statement D.
  • the financial statement that another ordinary employee of the finance department can see is financial statement A.
  • financial statement B does not have the authority to view financial statement C and financial statement D.
  • the above user class authority information may include which type of user has which rights.
  • the above report to be created is the report module to be created.
  • the user class permission entry instruction may be a permission entry instruction in the form of a sql script statement, and is used for user class permission entry.
  • the type of user is defined by the sql script statement, and each type of user is given certain permissions.
  • user types include senior supervisor class, intermediate supervisor class, and general employee class.
  • the report that the user with the permission can view is the report M with the attribute m, the report N with the attribute n, the report X with the attribute x, and the report Y with the attribute y; when the user It belongs to the intermediate supervisor class.
  • the report that users with such permissions can view is report M with attribute m and report N with attribute n.
  • the report that users with such permission can view is only Report M with attribute m.
  • the apparatus described in this application further includes an obtaining module and a triggering module.
  • the obtaining module is configured to obtain the personnel structure information of the application body.
  • the triggering module is configured to create a user class permission according to the personnel structure information, and trigger the user class permission entry instruction.
  • the acquisition module and the trigger module can be executed before the permission entry module.
  • the above application body refers to a unit body that implements the BI tool.
  • the application body is a company.
  • the personnel structure information of the application subject may include information such as which departments are included in the application body, and the personnel composition of each department.
  • the above-mentioned creation of the user class authority according to the personnel structure information may specifically be: determining different management level according to the personnel structure, thereby assigning different user class rights.
  • different user class rights can also be assigned according to their work functions.
  • each management level can assign different user class rights according to the authority.
  • the user class permission is quickly determined, and then the user class permission is entered.
  • the user class permission is entered.
  • a large-scale company it usually has the characteristics of many people and complicated structure. Through this embodiment, the efficiency of a large-scale company in the entry of user rights can be greatly improved.
  • the first creating module 220 is configured to access the refresh storage, and create a refresh directory of the to-be-created report in the refresh storage, where the refresh directory is used to store a file related to the report refresh to be created.
  • the storage may also be referred to as Network Attached Storage (NAS).
  • NAS Network Attached Storage
  • the above refresh storage may be storage for a model refresh or storage in a server for refreshing.
  • the refresh directory includes but is not limited to: a model subdirectory (also referred to as a model folder), a refresh file subdirectory (also referred to as a refresh folder), and a log subdirectory (also referred to as a log folder).
  • the subdirectory to be released also known as the folder to be published).
  • the model sub-directory is used to store the new model, which is used to define how the data is organized and what the structure of the data is.
  • the subdirectory is refreshed to store the file generated when the model is refreshed, that is, the refresh directory can be used as the execution location when the model is refreshed.
  • a log subdirectory for storing logs during the refresh process is provided.
  • the subdirectory to be published is used to store the data cube file generated by the report refresh.
  • the data cube file is also known as the Cube file.
  • the new model can be stored in the model subdirectory, and then refreshed in the refresh directory, and the refreshed data cube file is saved to the subdirectory to be published for use in the report.
  • the user can view the log file through the file saved in the log subdirectory.
  • the refresh storage includes at least two storage areas
  • the first creation module 220 may include a first acquisition unit, a second acquisition unit, and a new unit.
  • the first obtaining unit is configured to obtain the service classification information of the application entity, and obtain the service category included in the application body, where the application body is the entity that applies the report to be created.
  • a second acquiring unit configured to acquire a correspondence between each service category and a storage area included in the refresh storage.
  • a new unit is configured to access the refresh storage, and the refresh directory of the to-be-created report is newly created in the storage area corresponding to each service category according to the corresponding relationship.
  • the foregoing refresh storage includes at least two storage areas, that is, the refresh storage includes a separate at least two memories, or the refresh storage (for one memory) includes a plurality of partitioned storage areas.
  • the above-mentioned application body refers to a unit body that implements the BI tool.
  • the application body is a company.
  • the service classification information of the application subject may be a service classification or a product classification of a unit entity that implements the BI tool.
  • a group company has three subsidiaries that operate different businesses, and each subsidiary corresponds to one storage area to obtain the correspondence between each service category and the storage area included in the refresh storage. If a company corresponds to AA storage, b company corresponds to BB storage, c company corresponds to CC storage, then create new model subdirectory, refresh file subdirectory, log subdirectory, and subdirectory to be published for a company's report service on AA storage.
  • the correspondence between the service category and the storage area may be preset.
  • a corresponding directory can be created for each service category in the application scenario of multiple service categories for report refresh. Moreover, with the application, the corresponding service category can be automatically divided and the corresponding refresh directory is automatically created, thereby improving the efficiency of the creation of the report module.
  • the second acquiring unit is specifically configured to:
  • the historical data of the foregoing service category is the business data generated by the service category in the past period of time.
  • the storage area corresponding to each service category is determined according to the historical service data of each service category and the storage capacity of each storage area.
  • the storage capacity of a certain storage area is greater than or equal to the historical service data of a certain service category, It is determined that the storage area corresponds to storing historical data of the service category.
  • the storage area corresponding to each service category is determined according to the historical business data from large to small.
  • the corresponding relationship between the service module and the refresh storage obtained by the embodiment is more in line with the actual service requirement, and the problem that the report cannot be refreshed due to insufficient space for refreshing the storage during the process of refreshing the report is avoided, and the report running after the report module is created is improved. stability.
  • the second acquiring unit is specifically configured to:
  • the service attributes of the service category may include, but are not limited to, the service size of the service category, the operation time of the service module, and the like.
  • the business size of the business category may include the size of the person in the business category, operating profit, product type, and the like.
  • the refresh storage is divided according to the service attributes of the service category, and a storage area having a sufficient storage capacity can be allocated for each service type. The problem of unable to refresh due to insufficient space for refreshing the storage during the report refresh process is avoided, and the stability of the report running after the report module is created is improved.
  • the second creation module 230 is configured to access an application storage corresponding to the refresh storage, and create a new soft link in the application storage corresponding to the refresh storage, where the soft link is used to point to a refresh directory of the report to be created.
  • the above application storage may be a storage for a report application or a storage for an application.
  • the refresh storage and the application storage may be the same storage medium or may be respectively in different storage media.
  • the application storage acquires the data cube from the corresponding refresh storage at the time of execution.
  • the above soft link can also be called a symbolic link.
  • a soft link is a link file, that is, a link file pointing to an address.
  • the soft link is used to point to the refresh directory of the report to be created.
  • the soft link refers to the newly created refresh directory in the refresh storage in step S20, that is, the soft link is newly created in the refresh storage corresponding to the application storage.
  • the link file for the refresh directory Therefore, the newly created refresh directory in the refresh store corresponding to the application store can be accessed through the newly created soft link.
  • the application storage may also include at least two application storage areas corresponding thereto.
  • the second creating module 230 is specifically configured to:
  • the polling refreshes the application storage area corresponding to each storage area stored, and creates a soft link on each application storage area.
  • a soft link is created on the application storage area corresponding to each storage area of the refreshed storage to point to the subdirectory to be distributed, and a data cube file generated after the refresh can be obtained.
  • the third creating module 240 is configured to create a report directory of the to-be-created report in the corresponding user interaction interface of the application, so that the user accesses the to-be-created report through the report directory according to the entered user class permission.
  • the user interaction interface is a client interface operated by a user who views the report (for example, a supervisor of the finance department) when using the report module of the BI tool, and is also an interface of the client corresponding to the application storage.
  • Creating a report directory of the report to be created on the user interface allows the user to directly access the report function of the BI tool through the report directory, and then view the report. Specifically, after the creation of the report module is completed by the above module, the user can access the report with the permission according to the user class permission that has been entered.
  • the refresh data of the backend server (or the server and the storage) is refreshed to obtain the report data, and then displayed on the user interaction interface, thereby providing the report service for the user.
  • the report module creation device receives the user class permission input instruction through the permission entry module, and enters the user class permission of the to-be-created report according to the user class permission information included in the user class permission entry instruction; the first creation module accesses the refresh storage, And creating, in the refresh storage, a refresh directory of the to-be-created report, where the refresh directory is used to store a file related to the report refresh to be created; and the second creation module accesses an application store corresponding to the refresh storage, where The refreshing stores a new soft link in the corresponding application store, where the soft link is used to point to the refresh directory of the report to be created, and the third creating module creates a new report to be created in the corresponding user interaction interface of the application store.
  • the report directory is configured to enable the user to access the report to be created through the report directory according to the user class permissions that have been entered.
  • the user class permission entry is performed according to the user class permission input instruction
  • the refresh directory is created according to the automatic access refresh storage
  • the application store is automatically accessed to create a soft link
  • the report directory of the report to be created is newly created in the user interaction interface corresponding to the application store.
  • the above-described integrated modules and units implemented in the form of software function modules can be stored in a non-volatile readable storage medium.
  • the software function module described above is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) or a processor to perform the methods described in various embodiments of the present application. Part of the steps.
  • FIG. 3 is a schematic structural diagram of a computer apparatus according to a preferred embodiment of a method for creating a report module in the present application.
  • the computer device comprises at least one transmitting device 31, at least one memory 32, at least one processor 33, at least one receiving device 34 and at least one communication bus.
  • the communication bus is used to implement connection communication between these components.
  • the computer device is a device capable of automatically performing numerical calculation and/or information processing according to an instruction set or stored in advance, and the hardware thereof includes but is not limited to a microprocessor and an application specific integrated circuit (ASIC). , Field-Programmable Gate Array (FPGA), Digital Signal Processor (DSP), embedded devices, etc.
  • the computer device may also include a network device and/or a user device.
  • the network device includes, but is not limited to, a single network server, a server group composed of multiple network servers, or a cloud computing-based cloud composed of a large number of hosts or network servers, where the cloud computing is distributed computing.
  • a super virtual computer consisting of a group of loosely coupled computers.
  • the computer device may be, but is not limited to, any electronic product that can interact with a user through a keyboard, a touch pad, or a voice control device.
  • the network in which the computer device is located includes, but is not limited to, the Internet, a wide area network, a metropolitan area network, a local area network, a virtual private network (VPN), and the like.
  • the Internet includes, but is not limited to, the Internet, a wide area network, a metropolitan area network, a local area network, a virtual private network (VPN), and the like.
  • VPN virtual private network
  • the receiving device 34 and the transmitting device 31 may be wired transmission ports, or may be wireless devices, for example, including antenna devices, for performing data communication with other devices.
  • the memory 32 is used to store program code.
  • the memory 32 may be a circuit having a storage function, such as a RAM (Random-Access Memory), a FIFO (First In First Out), or the like, which has no physical form in the integrated circuit.
  • the memory 32 may also be a memory having a physical form, such as a memory stick, a TF card (Trans-flash Card), a smart media card, a secure digital card, a flash memory card.
  • Storage devices such as (flash card) and the like.
  • the processor 33 can include one or more microprocessors, digital processors.
  • the processor 33 can call program code stored in the memory 32 to perform related functions.
  • the various units described in FIG. 3 are program code stored in the memory 32 and executed by the processor 33 to implement a report module creation method.
  • the processor 33 also known as a central processing unit (CPU), is a very large-scale integrated circuit, which is a computing core (Core) and a control unit (Control Unit).
  • modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment.
  • each functional module in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.
  • the above integrated unit can be implemented in the form of hardware or in the form of hardware plus software function modules.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • Business, Economics & Management (AREA)
  • General Health & Medical Sciences (AREA)
  • General Engineering & Computer Science (AREA)
  • Bioethics (AREA)
  • Software Systems (AREA)
  • Computer Security & Cryptography (AREA)
  • Computer Hardware Design (AREA)
  • Human Resources & Organizations (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Strategic Management (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Marketing (AREA)
  • Data Mining & Analysis (AREA)
  • Artificial Intelligence (AREA)
  • Databases & Information Systems (AREA)
  • Automation & Control Theory (AREA)
  • Economics (AREA)
  • Computational Linguistics (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Storage Device Security (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本申请提供一种报表模块创建方法，包括：接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。本申请还公开了一种报表模块创建装置、计算机装置和存储介质。本申请可以提高创建报表模块的效率。

Description

报表模块创建方法、装置、计算机装置及存储介质
本申请要求于2018年04月23日提交中国专利局，申请号为201810367355.2发明名称为“报表模块创建方法、装置、计算机装置及存储介质”的中国专利申请的优先权，其全部内容通过引用结合在本申请中。
技术领域
本申请涉及数据挖掘技术领域，尤其涉及一种报表模块创建方法、装置、计算机装置及存储介质。
背景技术
商业智能(Business Intelligence,BI)分析工具也称为BI工具，是一种用于数据挖掘的软件。BI工具是一种将企业中应用的各系统数据进行有效的整合，快速准确地提供报表的工具，可以帮助使用者了解所需的企业信息以及帮助使用者做出经营决策。常见的BI报表系统有Cognos，OBIEE，BO等。目前，在BI工具新增报表模块时，需要大量的手动配置，例如，在资料库进行用户类权限数据录入等。这使得在BI工具中创建报表模块时耗时耗力，且效率不高。
发明内容
鉴于以上内容，有必要提供一种报表模块创建方法、装置、计算机装置及存储介质，能提高创建报表模块的效率。
本申请提供一种报表模块创建方法，所述方法包括：
接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；
访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；
访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；
在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
本申请还提供一种报表模块创建装置，所述装置包括：
权限录入模块，用于接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；
第一创建模块，用于访问刷新存储，在所述刷新存储内新建所述待创建 报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；
第二创建模块，用于访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；
第三创建模块，用于在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
本申请还提供一种计算机装置，所述计算机装置包括存储器及处理器，所述存储器用于存储至少一个指令，所述处理器用于执行所述至少一个指令以实现任意实施例中所述的报表模块创建方法。
本申请还提供一种非易失性可读存储介质，其特征在于，所述非易失性可读存储介质存储有至少一个指令，所述至少一个指令被处理器执行时实现任意实施例中所述的报表模块创建方法。
由以上技术方案看出，本申请通过接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。由于根据用户类权限录入指令进行用户类权限录入，并且根据自动访问刷新存储进而创建刷新目录，以及自动访问应用存储进而创建软链接，最后在应用存储对应的用户交互界面新建待创建报表的报表目录，使用户可以根据已录入的权限对待创建报表的报表目录进行访问。从而完成了从服务器、存储到客户端的报表模块的配置任务，实现了报表模块创建，并且在创建过程中无需用户进行大量手工作业，极大的提高了报表模块的创建效率。
附图说明
为了更清楚地说明本申请实施例或现有技术中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本申请的实施例，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据提供的附图获得其他的附图。
图1是本申请实施例提供的一种报表模块创建方法的流程图；
图2是本申请实施例提供的报表模块创建装置的功能模块图；
图3是本申请实现报表模块创建方法的较佳实施例的计算机装置的结构示意图。
具体实施方式
下面将结合本申请实施例中的附图，对本申请实施例中的技术方案进行清楚、完整地描述，显然，所描述的实施例仅仅是本申请一部分实施例，而不是全部的实施例。基于本申请中的实施例，本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例，都属于本申请保护的范围。
为使本申请的上述目的、特征和优点能够更加明显易懂，下面结合附图和具体实施方式对本申请作进一步详细的说明。
如图1所示，图1为本申请实施例提供的一种报表模块创建方法的流程图。根据不同的需求，该流程图中步骤的顺序可以改变，某些步骤可以省略。
S10，接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限。
本申请所述的方法可应用于BI工具中报表模块的创建。例如，在Cognos中进行报表模块的创建。
报表是一种通过图表或者数据形式展现企业的经营过程中已发现或可预测的信息，以供经营者了解企业的经营情况的功能模块。例如，在报表这一功能模块中以图表显示个人生活护理，居家护理，食品和饮料这三类产品在巴西、中国以及印度三个国家的销售情况。
同时，不同的公司或者同一个公司的不同部门在应用BI报表系统时，可以根据实际需要创建不同的模型，以及展现不同的报表。因此，在BI工具中，通过权限来管控不同角色的人所能查看的报表。例如，在某一公司的财务部门中，财务主管可以看到的财务报表为报表A、报表B、报表C以及报表D，该财务部门的另一普通职员可以看到的财务报表为财务表A，以及财务报表B，并不具有查看财务报表C以及财务报表D的权限。
因此，上述用户类权限信息可包括哪种类型的用户具有哪些权限。上述待创建报表，是将要创建的报表模块。
具体的，上述用户类权限录入指令可以是sql脚本语句形式的权限录入指令，用于进行用户类权限录入。例如，在Cognos资料库中，通过sql脚本语句定义用户的类型，并对每个类型的用户赋予一定的权限。
例如，用户类型包括高级主管类、中级主管类、普通职员类。当用户属于高级主管类时，具有该类权限的用户可以查看的报表是属性为m的报表M，属性为n的报表N，属性为x的报表X，以及属性为y的报表Y；当用户属于中级主管类，具有该类权限的用户可以查看的报表为属性为m的报表M，以及属性为n的报表N，当用户属于普通职员类，具有该类权限的用户可以查看的报表仅为属性为m的报表M。
通过根据用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限，可以使报表创建后不同类别的用户可以根据其所属的权限查看不同的报表。并且，无需手动例如，提高了录入的效率，缩短了创建报表模块的时间。
进一步地，在本申请另一实施例中，本申请所述的方法还包括：获取所 述应用主体的人员结构信息；根据所述人员结构信息创建用户类权限，触发所述用户类权限录入指令。
本实施例中的步骤可以在步骤S10之前执行。
上述应用主体是指实施该BI工具的单位主体。例如，应用主体为某一公司。
上述应用主体的人员结构信息可以包括应用主体包含哪些部门，每个部门的人员构成等信息。
上述根据人员结构信息创建用户类权限具体可以是：根据人员结构确定不同的管理层级，从而分配不同的用户类权限。同时，根据同一管理层级的人员，根据其工作职能，也可以分配不同的用户类权限。
例如，对于总经理、副总经理、财务部来说，属于3个管理层级，每个管理层级可以按照权限由大至小分配不同的用户类权限。
又比如，对于财务部、销售部、市场部、人力资源部、工程部、生产部这几个部门的人员来说，可以分配不同的用户类权限，使得不同部门的人可以看到与所属部门相关的信息。则，财务部的主管根据其分配的权限看到财务相关的信息，销售部的主管根据其分配的权限看到销售相关的信息，市场部的主管根据其分配的权限看到与市场相关的信息。
通过本实施例，在创建报表模块时，快速的确定用户类权限，进而进行用户类权限录入。对于规模较大的公司，通常具有人员多，结构复杂的特点，通过本实施例可以极大提升规模较大的公司在用户类权限录入时的效率。
S20，访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件。
其中，存储也可称为网络附属存储(Network Attached Storage，NAS)。在实际应用中，上述刷新存储，可以是用于模型刷新的存储器或用于刷新的服务器中的存储。
可选的，刷新目录包括但不限于：模型子目录(也可称为模型文件夹)，刷新文件子目录(也可称为刷新文件夹)、日志子目录(也可称为日志文件夹)、待发布子目录(也可称为待发布文件夹)。
其中，模型子目录，用于存储新建模型，该模型用于定义数据如何组织，数据的结构是怎样的。
刷新文件子目录，用于存储模型刷新时产生的文件，即刷新目录可以作为模型刷新时的执行位置。
日志子目录，用于存储刷新过程中的日志。
待发布子目录，用于存储报表刷新生成的数据立方体文件。其中，数据立方体文件又称为Cube文件。
因此，在创建好报表模块以后，可以在模型子目录中存储新建模型，再在刷新目录中进刷新，将刷新好的数据立方体文件保存至待发布子目录中，以供报表使用。同时，若刷新过程中遇到异常，用户可以通过日志子目录中保存的文件查看日志文件。
进一步地，在本申请另一实施例中，所述刷新存储包括至少两个储存区域，所述步骤S20中在所述刷新存储内新建所述待创建报表的刷新目录包括：
(1)获取应用主体的业务分类信息，得到所述应用主体包含的业务类别，其中，所述应用主体为应用所述待创建报表的主体；
(2)获取每种业务类别与所述刷新存储包含的存储区域的对应关系；
(3)根据所述对应关系在每种业务类别对应的存储区域内新建所述待创建报表的刷新目录。
其中，上述刷新存储包括至少两个存储区域是指，刷新存储包括单独的至少两个存储器，或者是刷新存储(为一个存储器)包含已分区的多个存储区。
如前文所述，上述应用主体是指实施该BI工具的单位主体。例如，应用主体为某一公司。
上述应用主体的业务分类信息可以是实施该BI工具的单位主体的业务分类或者产品分类。
例如，某集团公司有3个子公司分别经营不同的业务，每个子公司分别对应一个存储区域则可以获取每种业务类别与刷新存储包含的存储区域的对应关系。若a公司对应AA存储，b公司对应BB存储，c公司对应CC存储，则在AA存储上新建模型子目录、刷新文件子目录、日志子目录，以及待发布子目录用于a公司的报表服务；在BB存储上新建模型子目录、刷新子文件目录、日志子目录，以及待发布子目录用于b公司的报表服务；在CC存储上新建模型子目录、刷新文件子目录、日志子目录，以及待发布子目录用于c公司的报表服务。
其中，上述业务类别与存存储区域的对应关系可以为预先设置的。
通过本实施例，可以在多种业务类别的应用场景中，为每种业务类别创建对应的目录用于报表刷新。并且，通过本申请，可以自动划分对应的业务类别并自动创建对应的刷新目录，从而提高了报表模块创建的效率。
进一步地，在本申请另一实施例中，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
获取每种业务类别的历史业务数据和所述刷新存储包含的每个存储区域的存储容量；根据所述每种业务类别的历史业务数据和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
其中，上述业务类别的历史数据是该业务类别在过去一段时间内产生的业务数据。
根据每种业务类别的历史业务数据和每个存储区域的存储容量确定每种业务类别对应的存储区域，可以是，当某一存储区域的存储容量大于等于某种业务类别的历史业务数据时，确定该存储区域对应存储该业务类别的历史数据。同时，在具体实施时，按照历史业务数据的由大至小来确定每种业务类别所对应的存储区域。
例如，获取a公司在过去一年产生的业务数据。当业务数据较多时，分 配的存储区域的容量也较大，当业务数据较少时，分配的存储区域的容量也较小。
通过本实施例获取到的业务模块与刷新存储的对应关系更符合实际业务需求，避免了在报表刷新过程中因为刷新存储的空间不足导致的无法刷新的问题，提高了报表模块创建后报表运行的稳定性。
进一步地，在本申请另一实施例中，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
获取每种业务类别的业务属性信息和所述刷新存储包含的每个存储区域的存储容量；根据所述每种业务类别的业务属性信息和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
其中，业务类别的业务属性可以包括但不限于：业务类别的业务规模，业务模块的经营时间等。
业务类别的业务规模可以包括该业务类别的人员规模、营业利润、产品种类等。
由于业务类别的业务属性可以侧面反映该业务的报表需求类型，以及每种业务的报表量的大小。因此，在本实施例中，根据业务类别的业务属性来划分刷新存储，可以为每种业务类型分配存储容量足够的存储区域。避免了在报表刷新过程中因为刷新存储的空间不足导致的无法刷新的问题，提高了报表模块创建后报表运行的稳定性。
S30，访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录。
其中，上述应用存储，可以是用于报表应用的存储器或用于应用的服务器中的存储。
在具体实现时，刷新存储与应用存储可以是同一个存储介质内也可以是分别在不同的存储介质中。
刷新存储与应用存储存在一定的对应关系，即应用存储在执行时从所对应的刷新存储中获取数据立方体。
上述软链接(soft link)也可称为符号链接(symbolic link)，软链接是一个链接文件，即指向某一地址的链接文件。上述软链接用于指向所述待创建报表的刷新目录，具体是指，软链接是指向在步骤S20中的刷新存储内新建的刷新目录，即该软链接是与应用存储对应的刷新存储中新建的刷新目录的链接文件。因此，通过新建的软链接可以访问与应用存储对应的刷新存储中新建的刷新目录。
可以理解的是，在多种业务类型的场景中，当刷新存储包括至少两个存储区域时，应用存储也可以包含至少两个应用存储区域与之对应。
可选的，在本申请其他实施例中，所述访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，包括：
轮询所述刷新存储的每个存储区域对应的应用存储区域，在每个应用存储区域上创建软链接。
例如，在刷新存储的每个存储区域所对应的应用存储区域上创建软链接指向待发布子目录，可以获取刷新后生成好的数据立方体文件。
通过本实施例，可以支持多种业务类型情况下的报表搭建。
S40，在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
上述用户交互界面是查看报表的用户(例如财务部的主管等)使用BI工具的报表模块时所操作的客户端的界面，也是应用存储对应的客户端的界面。
在用户交互界面新建待创建报表的报表目录可以使用户通过该报表目录直接访问BI工具的报表功能，进而查看报表。具体的，通过步骤S10至步骤40完成报表模块的创建之后，用户可以根据已录入的用户类权限访问具有权限的报表。
当用户从用户交互界面查看报表时，通过后端服务器(或服务器及存储)的刷新存储进行刷新得到报表数据，进而再在用户交互界面显示，从而为用户提供报表服务。
本申请提供的报表模块创建方法接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。由于根据用户类权限录入指令进行用户类权限录入，并且根据自动访问刷新存储进而创建刷新目录，以及自动访问应用存储进而创建软链接，最后在应用存储对应的用户交互界面新建待创建报表的报表目录，使用户可以根据已录入的权限对待创建报表的报表目录进行访问。从而完成了从服务器、存储到客户端的报表模块的配置任务，实现了报表模块创建，并且在创建过程中无需用户进行大量手工作业，极大的提高了报表模块的创建效率。
如图2所示，图2为本申请实施例提供的报表模块创建装置的功能模块图。所述报表模块创建装置包括权限录入模块210、第一创建模块220、第二创建模块230和第三创建模块240。本申请所称的模块是指一种能够被计算机装置的处理器所执行并且能够完成固定功能的一系列计算机可读指令段，其存储在计算机装置的存储器中。在本实施例中，关于各模块的功能将在后续的实施例中详述。
权限录入模块210，用于接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限。
本申请所述的装置可用于BI工具中报表模块的创建。例如，在Cognos中进行报表模块的创建。
报表是一种通过图表或者数据形式展现企业的经营过程中已发现或可预测的信息，以供经营者了解企业的经营情况的功能模块。例如，在报表这一功能模块中以图表显示个人生活护理，居家护理，食品和饮料这三类产品在巴西、中国以及印度三个国家的销售情况。
同时，不同的公司或者同一个公司的不同部门在应用BI报表系统时，可以根据实际需要创建不同的模型，以及展现不同的报表。因此，在BI工具中，通过权限来管控不同角色的人所能查看的报表。例如，在某一公司的财务部门中，财务主管可以看到的财务报表为报表A、报表B、报表C以及报表D，该财务部门的另一普通职员可以看到的财务报表为财务表A，以及财务报表B，并不具有查看财务报表C以及财务报表D的权限。
因此，上述用户类权限信息可包括哪种类型的用户具有哪些权限。上述待创建报表，是将要创建的报表模块。
具体的，上述用户类权限录入指令可以是sql脚本语句形式的权限录入指令，用于进行用户类权限录入。例如，在Cognos资料库中，通过sql脚本语句定义用户的类型，并对每个类型的用户赋予一定的权限。
例如，用户类型包括高级主管类、中级主管类、普通职员类。当用户属于高级主管类时，具有该类权限的用户可以查看的报表是属性为m的报表M，属性为n的报表N，属性为x的报表X，以及属性为y的报表Y；当用户属于中级主管类，具有该类权限的用户可以查看的报表为属性为m的报表M，以及属性为n的报表N，当用户属于普通职员类，具有该类权限的用户可以查看的报表仅为属性为m的报表M。
通过根据用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限，可以使报表创建后不同类别的用户可以根据其所属的权限查看不同的报表。并且，无需手动例如，提高了录入的效率，缩短了创建报表模块的时间。
进一步地，在本申请另一实施例中，本申请所述的装置还包括获取模块和触发模块。
获取模块，用于获取所述应用主体的人员结构信息。
触发模块，用于根据所述人员结构信息创建用户类权限，触发所述用户类权限录入指令。
获取模块和触发模块可以在权限录入模块之前执行。
上述应用主体是指实施该BI工具的单位主体。例如，应用主体为某一公司。
上述应用主体的人员结构信息可以包括应用主体包含哪些部门，每个部门的人员构成等信息。
上述根据人员结构信息创建用户类权限具体可以是：根据人员结构确定不同的管理层级，从而分配不同的用户类权限。同时，根据同一管理层级的 人员，根据其工作职能，也可以分配不同的用户类权限。
例如，对于总经理、副总经理、财务部来说，属于3个管理层级，每个管理层级可以按照权限由大至小分配不同的用户类权限。
又比如，对于财务部、销售部、市场部、人力资源部、工程部、生产部这几个部门的人员来说，可以分配不同的用户类权限，使得不同部门的人可以看到与所属部门相关的信息。则，财务部的主管根据其分配的权限看到财务相关的信息，销售部的主管根据其分配的权限看到销售相关的信息，市场部的主管根据其分配的权限看到与市场相关的信息。
通过本实施例，在创建报表模块时，快速的确定用户类权限，进而进行用户类权限录入。对于规模较大的公司，通常具有人员多，结构复杂的特点，通过本实施例可以极大提升规模较大的公司在用户类权限录入时的效率。
第一创建模块220，用于访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件。
其中，存储也可称为网络附属存储(Network Attached Storage，NAS)。在实际应用中，上述刷新存储，可以是用于模型刷新的存储器或用于刷新的服务器中的存储。
可选的，刷新目录包括但不限于：模型子目录(也可称为模型文件夹)，刷新文件子目录(也可称为刷新文件夹)、日志子目录(也可称为日志文件夹)、待发布子目录(也可称为待发布文件夹)。
其中，模型子目录，用于存储新建模型，该模型用于定义数据如何组织，数据的结构是怎样的。
刷新子目录，用于存储模型刷新时产生的文件，即刷新目录可以作为模型刷新时的执行位置。
日志子目录，用于存储刷新过程中的日志。
待发布子目录，用于存储报表刷新生成的数据立方体文件。其中，数据立方体文件又称为Cube文件。
因此，在创建好报表模块以后，可以在模型子目录中存储新建模型，再在刷新目录中进刷新，将刷新好的数据立方体文件保存至待发布子目录中，以供报表使用。同时，若刷新过程中遇到异常，用户可以通过日志子目录中保存的文件查看日志文件。
进一步地，在本申请另一实施例中，所述刷新存储包括至少两个储存区域，所述第一创建模块220可包括第一获取单元、第二获取单元和新建单元。
第一获取单元，用于获取应用主体的业务分类信息，得到所述应用主体包含的业务类别，其中，所述应用主体为应用所述待创建报表的主体。
第二获取单元，用于获取每种业务类别与所述刷新存储包含的存储区域的对应关系。
新建单元，用于访问刷新存储，根据所述对应关系在每种业务类别对应的存储区域内新建所述待创建报表的刷新目录。
其中，上述刷新存储包括至少两个存储区域是指，刷新存储包括单独的至少两个存储器，或者是刷新存储(为一个存储器)包含已分区的多个存储区。
如前文所述，上述应用主体是指实施该BI工具的单位主体。例如，应用主体为某一公司。
上述应用主体的业务分类信息可以是实施该BI工具的单位主体的业务分类或者产品分类。
例如，某集团公司有3个子公司分别经营不同的业务，每个子公司分别对应一个存储区域则可以获取每种业务类别与刷新存储包含的存储区域的对应关系。若a公司对应AA存储，b公司对应BB存储，c公司对应CC存储，则在AA存储上新建模型子目录、刷新文件子目录、日志子目录，以及待发布子目录用于a公司的报表服务；在BB存储上新建模型子目录、刷新文件子目录、日志子目录，以及待发布子目录用于b公司的报表服务；在CC存储上新建模型子目录、刷新文件子目录、日志子目录，以及待发布子目录用于c公司的报表服务。
其中，上述业务类别与存存储区域的对应关系可以为预先设置的。
通过本实施例，可以在多种业务类别的应用场景中，为每种业务类别创建对应的目录用于报表刷新。并且，通过本申请，可以自动划分对应的业务类别并自动创建对应的刷新目录，从而提高了报表模块创建的效率。
进一步地，在本申请另一实施例中，所述第二获取单元具体用于：
获取每种业务类别的历史业务数据和所述刷新存储包含的每个存储区域的存储容量；根据所述每种业务类别的历史业务数据和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
其中，上述业务类别的历史数据是该业务类别在过去一段时间内产生的业务数据。
根据每种业务类别的历史业务数据和每个存储区域的存储容量确定每种业务类别对应的存储区域，可以是，当某一存储区域的存储容量大于等于某种业务类别的历史业务数据时，确定该存储区域对应存储该业务类别的历史数据。同时，在具体实施时，按照历史业务数据的由大至小来确定每种业务类别所对应的存储区域。
例如，获取a公司在过去一年产生的业务数据。当业务数据较多时，分配的存储区域的容量也较大，当业务数据较少时，分配的存储区域的容量也较小。
通过本实施例获取到的业务模块与刷新存储的对应关系更符合实际业务需求，避免了在报表刷新过程中因为刷新存储的空间不足导致的无法刷新的问题，提高了报表模块创建后报表运行的稳定性。
进一步地，在本申请另一实施例中，所述第二获取单元具体用于：
获取每种业务类别的业务属性信息和所述刷新存储包含的每个存储区域的存储容量；根据所述每种业务类别的业务属性信息和所述每个存储区域的 存储容量确定每种业务类别对应的存储区域。
其中，业务类别的业务属性可以包括但不限于：业务类别的业务规模，业务模块的经营时间等。
业务类别的业务规模可以包括该业务类别的人员规模、营业利润、产品种类等。
由于业务类别的业务属性可以侧面反映该业务的报表需求类型，以及每种业务的报表量的大小。因此，在本实施例中，根据业务类别的业务属性来划分刷新存储，可以为每种业务类型分配存储容量足够的存储区域。避免了在报表刷新过程中因为刷新存储的空间不足导致的无法刷新的问题，提高了报表模块创建后报表运行的稳定性。
第二创建模块230，用于访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录。
其中，上述应用存储，可以是用于报表应用的存储器或用于应用的服务器中的存储。
在具体实现时，刷新存储与应用存储可以是同一个存储介质也可以是分别在不同的存储介质中。
刷新存储与应用存储存在一定的对应关系，即应用存储在执行时从所对应的刷新存储中获取数据立方体。
上述软链接(soft link)也可称为符号链接(symbolic link)，软链接是一个链接文件，即指向某一地址的链接文件。上述软链接用于指向所述待创建报表的刷新目录，具体是指，软链接是指向在步骤S20中的刷新存储内新建的刷新目录，即该软链接是与应用存储对应的刷新存储中新建的刷新目录的链接文件。因此，通过新建的软链接可以访问与应用存储对应的刷新存储中新建的刷新目录。
可以理解的是，在多种业务类型的场景中，当存在刷新存储包括至少两个存储区域时，应用存储也可以包含至少两个应用存储区域与之对应。
可选的，在本申请其他实施例中，所述第二创建模块230具体用于：
轮询刷新存储的每个存储区域对应的应用存储区域，在每个应用存储区域上创建软链接。
例如，在刷新存储的每个存储区域所对应的应用存储区域上创建软链接指向待发布子目录，可以获取刷新后生成好的数据立方体文件。
通过本实施例，可以支持多种业务类型情况下的报表搭建。
第三创建模块240，用于在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
上述用户交互界面是查看报表的用户(例如财务部的主管等)使用BI工具的报表模块时所操作的客户端的界面，也是应用存储对应的客户端的界面。
在用户交互界面新建待创建报表的报表目录可以使用户通过该报表目录直接访问BI工具的报表功能，进而查看报表。具体的，通过以上模块完成报表模块的创建之后，用户可以根据已录入的用户类权限访问具有权限的报表。
当用户从用户交互界面查看报表时，通过后端服务器(或服务器及存储)的刷新存储进行刷新得到报表数据，进而再在用户交互界面显示，从而为用户提供报表服务。
本申请提供的报表模块创建装置通过权限录入模块接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；第一创建模块访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；第二创建模块访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；第三创建模块在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。由于根据用户类权限录入指令进行用户类权限录入，并且根据自动访问刷新存储进而创建刷新目录，以及自动访问应用存储进而创建软链接，最后在应用存储对应的用户交互界面新建待创建报表的报表目录，使用户可以根据已录入的权限对待创建报表的报表目录进行访问。从而完成了从服务器、存储到客户端的报表模块的配置任务，实现了报表模块创建，并且在创建过程中无需用户进行大量手工作业，极大的提高了报表模块的创建效率。
上述以软件功能模块的形式实现的集成的模块和单元，可以存储在一个非易失性可读取存储介质中。上述软件功能模块存储在一个存储介质中，包括若干指令用以使得一台计算机设备(可以是个人计算机，服务器，或者网络设备等)或处理器(processor)执行本申请各个实施例所述方法的部分步骤。
如图3所示，图3是本申请实现报表模块创建方法的较佳实施例的计算机装置的结构示意图。所述计算机装置包括至少一个发送装置31、至少一个存储器32、至少一个处理器33、至少一个接收装置34以及至少一个通信总线。其中，所述通信总线用于实现这些组件之间的连接通信。
所述计算机装置是一种能够按照事先设定或存储的指令，自动进行数值计算和/或信息处理的设备，其硬件包括但不限于微处理器、专用集成电路(Application Specific Integrated Circuit，ASIC)、可编程门阵列(Field－Programmable Gate Array，FPGA)、数字处理器(Digital Signal Processor，DSP)、嵌入式设备等。所述计算机装置还可包括网络设备和/或用户设备。其中，所述网络设备包括但不限于单个网络服务器、多个网络服务器组成的服务器组或基于云计算(Cloud Computing)的由大量主机或网络服务器构成的云，其中，云计算是分布式计算的一种，由一群松散耦合的计算机集组成的一个超级虚 拟计算机。
所述计算机装置可以是，但不限于任何一种可与用户通过键盘、触摸板或声控设备等方式进行人机交互的电子产品。
所述计算机装置所处的网络包括，但不限于互联网、广域网、城域网、局域网、虚拟专用网络(Virtual Private Network，VPN)等。
其中，所述接收装置34和所述发送装置31可以是有线发送端口，也可以为无线设备，例如包括天线装置，用于与其他设备进行数据通信。
所述存储器32用于存储程序代码。所述存储器32可以是集成电路中没有实物形式的具有存储功能的电路，如RAM(Random-Access Memory，随机存取存储器)、FIFO(First In First Out，)等。或者，所述存储器32也可以是具有实物形式的存储器，如内存条、TF卡(Trans-flash Card)、智能媒体卡(smart media card)、安全数字卡(secure digital card)、快闪存储器卡(flash card)等储存设备等等。
所述处理器33可以包括一个或者多个微处理器、数字处理器。所述处理器33可调用存储器32中存储的程序代码以执行相关的功能。例如，图3中所述的各个单元是存储在所述存储器32中的程序代码，并由所述处理器33所执行，以实现一种报表模块创建方法。所述处理器33又称中央处理器(CPU，Central Processing Unit)，是一块超大规模的集成电路，是运算核心(Core)和控制核心(Control Unit)。
在本申请所提供的几个实施例中，应该理解到，所揭露的系统，装置和方法，可以通过其它的方式实现。例如，以上所描述的装置实施例仅仅是示意性的，例如，所述模块的划分，仅仅为一种逻辑功能划分，实际实现时可以有另外的划分方式。
所述作为分离部件说明的模块可以是或者也可以不是物理上分开的，作为模块显示的部件可以是或者也可以不是物理单元，即可以位于一个地方，或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部模块来实现本实施例方案的目的。
另外，在本申请各个实施例中的各功能模块可以集成在一个处理单元中，也可以是各个单元单独物理存在，也可以两个或两个以上单元集成在一个单元中。上述集成的单元既可以采用硬件的形式实现，也可以采用硬件加软件功能模块的形式实现。
对于本领域技术人员而言，显然本申请不限于上述示范性实施例的细节，而且在不背离本申请的精神或基本特征的情况下，能够以其他的具体形式实现本申请。因此，无论从哪一点来看，均应将实施例看作是示范性的，而且是非限制性的，本申请的范围由所附权利要求而不是上述说明限定，因此旨在将落在权利要求的等同要件的含义和范围内的所有变化涵括在本申请内。不应将权利要求中的任何附关联图标记视为限制所涉及的权利要求。此外，显然“包括”一词不排除其他单元或步骤，单数不排除复数。系统权利要求中陈述的多个单元或装置也可以由一个单元或装置通过软件或者硬件来实现。 第二等词语用来表示名称，而并不表示任何特定的顺序。
最后应说明的是，以上实施例仅用以说明本申请的技术方案而非限制，尽管参照较佳实施例对本申请进行了详细说明，本领域的普通技术人员应当理解，可以对本申请的技术方案进行修改或等同替换，而不脱离本申请技术方案的精神和范围。

Claims (20)

  1. 一种报表模块创建方法，其特征在于，所述方法包括：
    接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；
    访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；
    访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；
    在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
  2. 如权利要求1所述的方法，其特征在于，所述刷新存储包括至少两个储存区域，所述在所述刷新存储内新建所述待创建报表的刷新目录包括：
    获取应用主体的业务分类信息，得到所述应用主体包含的业务类别，其中，所述应用主体为应用所述待创建报表的主体；
    获取每种业务类别与所述刷新存储包含的存储区域的对应关系；
    根据所述对应关系在每种业务类别对应的存储区域内新建所述待创建报表的刷新目录。
  3. 如权利要求2所述的方法，其特征在于，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
    获取每种业务类别的历史业务数据和所述刷新存储包含的每个存储区域的存储容量；
    根据所述每种业务类别的历史业务数据和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
  4. 如权利要求2所述的方法，其特征在于，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
    获取每种业务类别的业务属性信息和所述刷新存储包含的每个存储区域的存储容量；
    根据所述每种业务类别的业务属性信息和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
  5. 如权利要求2至4中任一项所述的方法，其特征在于，所述方法还包括：
    获取所述应用主体的人员结构信息；
    根据所述人员结构信息创建用户类权限，触发所述用户类权限录入指令。
  6. 如权利要求1至4中任一项所述的方法，其特征在于，所述访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接包括：
    轮询所述刷新存储的每个存储区域对应的应用存储区域，在每个应用存 储区域上创建软链接。
  7. 如权利要求1至4中任一项所述的方法，其特征在于，所述刷新目录包括：模型子目录、刷新文件子目录、日志子目录、待发布子目录。
  8. 一种报表模块创建装置，其特征在于，所述装置包括：
    权限录入模块，用于接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；
    第一创建模块，用于访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；
    第二创建模块，用于访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；
    第三创建模块，用于在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
  9. 一种计算机装置，其特征在于，所述计算机装置包括存储器及处理器，所述存储器用于存储至少一个指令，所述处理器用于执行所述至少一个指令以实现以下步骤：
    接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；
    访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；
    访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；
    在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
  10. 如权利要求9所述的计算机装置，其特征在于，所述刷新存储包括至少两个储存区域，所述在所述刷新存储内新建所述待创建报表的刷新目录包括：
    获取应用主体的业务分类信息，得到所述应用主体包含的业务类别，其中，所述应用主体为应用所述待创建报表的主体；
    获取每种业务类别与所述刷新存储包含的存储区域的对应关系；
    根据所述对应关系在每种业务类别对应的存储区域内新建所述待创建报表的刷新目录。
  11. 如权利要求10所述的计算机装置，其特征在于，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
    获取每种业务类别的历史业务数据和所述刷新存储包含的每个存储区域的存储容量；
    根据所述每种业务类别的历史业务数据和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
  12. 如权利要求10所述的计算机装置，其特征在于，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
    获取每种业务类别的业务属性信息和所述刷新存储包含的每个存储区域的存储容量；
    根据所述每种业务类别的业务属性信息和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
  13. 如权利要求10至12中任一项所述的计算机装置，其特征在于，所述处理器用于执行所述至少一个指令以实现以下步骤：
    获取所述应用主体的人员结构信息；
    根据所述人员结构信息创建用户类权限，触发所述用户类权限录入指令。
  14. 如权利要求9至12中任一项所述的计算机装置，其特征在于，所述访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接包括：
    轮询所述刷新存储的每个存储区域对应的应用存储区域，在每个应用存储区域上创建软链接。
  15. 一种非易失性可读存储介质，其上存储有计算机指令，其特征在于，所述计算机指令被处理器执行时实现以下步骤：
    接收用户类权限录入指令，根据所述用户类权限录入指令包含的用户类权限信息录入待创建报表的用户类权限；
    访问刷新存储，在所述刷新存储内新建所述待创建报表的刷新目录，所述刷新目录用于存储与所述待创建报表刷新相关的文件；
    访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接，所述软链接用于指向所述待创建报表的刷新目录；
    在所述应用存储对应的用户交互界面新建所述待创建报表的报表目录，以使用户根据已录入的用户类权限通过所述报表目录访问所述待创建报表。
  16. 如权利要求15所述的存储介质，其特征在于，所述刷新存储包括至少两个储存区域，所述在所述刷新存储内新建所述待创建报表的刷新目录包括：
    获取应用主体的业务分类信息，得到所述应用主体包含的业务类别，其中，所述应用主体为应用所述待创建报表的主体；
    获取每种业务类别与所述刷新存储包含的存储区域的对应关系；
    根据所述对应关系在每种业务类别对应的存储区域内新建所述待创建报表的刷新目录。
  17. 如权利要求16所述的存储介质，其特征在于，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
    获取每种业务类别的历史业务数据和所述刷新存储包含的每个存储区域的存储容量；
    根据所述每种业务类别的历史业务数据和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
  18. 如权利要求16所述的存储介质，其特征在于，所述获取每种业务类别与所述刷新存储包含的存储区域的对应关系包括：
    获取每种业务类别的业务属性信息和所述刷新存储包含的每个存储区域的存储容量；
    根据所述每种业务类别的业务属性信息和所述每个存储区域的存储容量确定每种业务类别对应的存储区域。
  19. 如权利要求16至18中任一项所述的存储介质，其特征在于，所述计算机指令被处理器执行时实现以下步骤：
    获取所述应用主体的人员结构信息；
    根据所述人员结构信息创建用户类权限，触发所述用户类权限录入指令。
  20. 如权利要求15至18中任一项所述的存储介质，其特征在于，所述访问与所述刷新存储对应的应用存储，在所述刷新存储对应的应用存储内新建软链接包括：
    轮询所述刷新存储的每个存储区域对应的应用存储区域，在每个应用存储区域上创建软链接。
PCT/CN2018/099778 2018-04-23 2018-08-10 报表模块创建方法、装置、计算机装置及存储介质 WO2019205347A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810367355.2A CN108681674B (zh) 2018-04-23 2018-04-23 报表模块创建方法、装置、计算机装置及存储介质
CN201810367355.2 2018-04-23

Publications (1)

Publication Number Publication Date
WO2019205347A1 true WO2019205347A1 (zh) 2019-10-31

Family

ID=63802231

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/099778 WO2019205347A1 (zh) 2018-04-23 2018-08-10 报表模块创建方法、装置、计算机装置及存储介质

Country Status (2)

Country Link
CN (1) CN108681674B (zh)
WO (1) WO2019205347A1 (zh)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112667638A (zh) * 2020-12-31 2021-04-16 新奥数能科技有限公司 动态报表生成方法、装置、终端设备及可读存储介质

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109492058A (zh) * 2018-11-13 2019-03-19 中国联合网络通信集团有限公司 业务报表的推送方法及装置
CN110347974B (zh) * 2019-05-30 2023-06-23 深圳市鼎为通信有限公司 数据处理方法、装置、计算机设备和存储介质
CN110618990B (zh) * 2019-08-15 2024-04-30 中国平安财产保险股份有限公司 清单报表设置方法、系统及清单报表获取方法
CN111859882A (zh) * 2020-07-30 2020-10-30 深圳市元征科技股份有限公司 一种报表生成的方法、系统、设备及可读存储介质

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101216817A (zh) * 2007-12-29 2008-07-09 中国建设银行股份有限公司 一种异构报表整合及集中管理的装置和系统
CN102467547A (zh) * 2010-11-16 2012-05-23 金蝶软件（中国）有限公司 历史数据存储方法及装置
US20140289803A1 (en) * 2013-03-22 2014-09-25 Ranjan Sharma Cdr filtering for virtual operators
CN106095504A (zh) * 2016-06-13 2016-11-09 青岛海信移动通信技术股份有限公司 预置应用加载方法和移动终端

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7546633B2 (en) * 2002-10-25 2009-06-09 Microsoft Corporation Role-based authorization management framework
US20060161862A1 (en) * 2005-01-20 2006-07-20 Microsoft Corporation Enabling users to create and use a directory of document links from within a file menu of an application
CN102810094A (zh) * 2011-05-31 2012-12-05 中兴通讯股份有限公司 报表生成方法及装置
CN106095341A (zh) * 2016-06-14 2016-11-09 乐视控股（北京）有限公司 对象管理方法和对象管理系统
CN107451109B (zh) * 2017-07-05 2022-01-04 北京京东尚科信息技术有限公司 报表生成方法及系统

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101216817A (zh) * 2007-12-29 2008-07-09 中国建设银行股份有限公司 一种异构报表整合及集中管理的装置和系统
CN102467547A (zh) * 2010-11-16 2012-05-23 金蝶软件（中国）有限公司 历史数据存储方法及装置
US20140289803A1 (en) * 2013-03-22 2014-09-25 Ranjan Sharma Cdr filtering for virtual operators
CN106095504A (zh) * 2016-06-13 2016-11-09 青岛海信移动通信技术股份有限公司 预置应用加载方法和移动终端

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112667638A (zh) * 2020-12-31 2021-04-16 新奥数能科技有限公司 动态报表生成方法、装置、终端设备及可读存储介质

Also Published As

Publication number Publication date
CN108681674B (zh) 2022-02-01
CN108681674A (zh) 2018-10-19

Similar Documents

Publication Publication Date Title
WO2019205347A1 (zh) 报表模块创建方法、装置、计算机装置及存储介质
US9454558B2 (en) Managing an index of a table of a database
US11829385B2 (en) Systems, methods, and devices for generation of analytical data reports using dynamically generated queries of a structured tabular cube
US10002170B2 (en) Managing a table of a database
US10824614B2 (en) Custom query parameters in a database system
US11481642B2 (en) Professional services demand fulfillment framework using machine learning
US20120054146A1 (en) Systems and methods for tracking and reporting provenance of data used in a massively distributed analytics cloud
US10083061B2 (en) Cloud embedded process tenant system for big data processing
US20150032873A1 (en) Activity analysis for monitoring and updating a personal profile
DE102013206354A1 (de) Adaptive Bewertung der Objektrelevanz auf der Grundlage dynamischer Benutzereigenschaften
US9672231B2 (en) Concurrent access for hierarchical data storage
US20190124107A1 (en) Security management for data systems
US20150154606A1 (en) System, method, and software for enterprise-wide complaint aggregation
US11436359B2 (en) System and method for managing permissions of users for a single data type column-oriented data structure
CN112100183B (zh) 基于标签管理的报表查询系统、装置及方法
US10057108B2 (en) Systems, devices, and methods for exchanging and processing data measures and objects
US20170228450A1 (en) Analytics Enablement for Engineering Records
WO2020243231A1 (en) Secure authorization provisioning using variant profiles
US20140143278A1 (en) Application programming interface layers for analytical applications
US11226884B2 (en) Database monitoring using shared infrastructure
US11093876B2 (en) System and methods employed for accountability of an asset
US11675814B2 (en) Ad hoc data exploration tool
US20200167717A1 (en) Systems and methods for outputting resource allocation records
Kryvda THE ROLE OF DATABASE MANAGEMENT SYSTEMS IN PROCESSING OF ECONOMIC INFORMATION
CN117390653A (zh) 一种基于oc-erp系统的权限管理方法、系统、电子设备及介质

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18916129

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 18.02.2021)

122 Ep: pct application non-entry in european phase

Ref document number: 18916129

Country of ref document: EP

Kind code of ref document: A1