CN107807954B - Visual modeling multidimensional analysis system and method thereof - Google Patents
Visual modeling multidimensional analysis system and method thereof Download PDFInfo
- Publication number
- CN107807954B CN107807954B CN201710901773.0A CN201710901773A CN107807954B CN 107807954 B CN107807954 B CN 107807954B CN 201710901773 A CN201710901773 A CN 201710901773A CN 107807954 B CN107807954 B CN 107807954B
- Authority
- CN
- China
- Prior art keywords
- analysis
- visual
- model
- modeling
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/81—Indexing, e.g. XML tags; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
- G06F16/838—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
- G06F16/86—Mapping to a database
Abstract
The invention relates to a visual modeling multidimensional analysis system and a method thereof, wherein the system comprises a visual modeling unit, a model analysis unit and a control unit, wherein the visual modeling unit is used for a user to define a multidimensional visual graphic element, multidimensional visual graphic element attributes, default public attributes of the model, configuration rules and control the configuration of the model visual graphic element for visual modeling; the mapping unit is used for converting and mapping the visual graphic elements and the analysis objects in the visual modeling unit and storing mapping results into a database; and the analysis unit is used for configuring the analysis template and the analysis display according to the data in the database, performing statement conversion and engine analysis on the analysis object, and rendering a view according to the analysis result. The invention saves the time cost for learning the realization technology of the dimension multi-engine and the configuration specification during modeling, improves the modeling efficiency and reduces the generation of errors.
Description
Technical Field
The invention relates to a multidimensional analysis system, in particular to a visual modeling multidimensional analysis system and a method thereof.
Background
XML is an extensible markup language, a subset of standard universal markup languages, and is a markup language for marking electronic documents to have a structure, and has good extensibility by means of XML, and thus, is widely used in a modeling process.
In the process of modeling by using xml code configuration, configuration personnel need to read configuration documents in detail and have a certain technical knowledge level, the configuration needs to comply with a certain specification structure, unnecessary configuration exists, errors are easy to generate, in a scene of a multidimensional model with multiple elements, complex association and complex hierarchy, the code pollution is serious, and codes with correct error modification can be generated, so that the code configuration needs to make a complex specification, the updating of the configuration specification needs to be popularized and learned again, the workload is huge for modifying the specification document, the learning cost of closely related configuration codes to the underlying technology is high, the configuration files have certain specification structures and cannot be taken out independently, the authority management on a single configuration item cannot be carried out, the model and the template are not managed in a modularized mode, and the configuration cannot be used as a template for universal presetting and personalized modification, the technology background configuration is adopted, and the business degree is low.
Therefore, it is necessary to design a visual modeling multidimensional analysis system, which saves the time cost for learning the implementation technology of the multidimensional and multidimensional engine and learning the configuration specification during modeling, improves the modeling efficiency, and reduces the generation of errors.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provides a visual modeling multi-dimensional analysis system and a method thereof.
In order to achieve the purpose, the invention adopts the following technical scheme: a visual modeling multidimensional analysis system, the system comprising:
the visual modeling unit is used for defining a multi-dimensional visual graphic element, attributes of the multi-dimensional visual graphic element, default public attributes of the model, configuration rules and controlling the configuration of the model visual graphic element by a user so as to perform visual modeling;
the mapping unit is used for converting and mapping the visual graphic element and the analysis object in the visual modeling unit and storing the mapping result into a database;
and the analysis unit is used for configuring the analysis template and the analysis display according to the data in the database, performing statement conversion and engine analysis on the analysis object, and rendering a view according to the analysis result.
The further technical scheme is as follows: the visual modeling unit comprises an element definition module, an element attribute definition module, a modeling space definition module, a modeling rule definition module and a modeling operation setting module;
the element definition module is used for defining basic multi-dimensional elements, database connection elements, database table elements, index elements and dimension elements, and defining at least one of the shape, the size, the color and the label of each element to form a visual graphic element;
the component attribute definition module is used for defining attributes of different components needing configuration and display modes of the attributes;
the modeling space definition module is used for defining default public attributes of the model and controlling the view element style to acquire a space meeting the requirements;
the modeling rule definition module is used for defining configuration rules of visual graphic elements in the model through code configuration regulations and a view element control mode so as to arrange the visual graphic elements;
the modeling operation setting module is used for controlling at least one of the position, the hierarchy, the transparency, the color and the shape of the visual graphic element.
The further technical scheme is as follows: the mapping unit comprises a model element attribute extraction module, an analysis object definition module, an attribute endowing module, an element mapping module and a conversion module;
the model element attribute extraction module is used for extracting the attributes of each visual graphic element in the model;
the analysis object definition module is used for defining an analysis object corresponding to the visual graphic element;
the attribute giving module is used for giving corresponding attributes to the analysis objects according to different types of attribute specifications of the analysis objects;
the element mapping module is used for mapping the visual graphic element attribute of the model to the attribute of the analysis object;
and the conversion module is used for converting the analysis object into a binary stream and persisting the binary stream into the database.
The further technical scheme is as follows: the analysis unit comprises an analysis template configuration module, an analysis display configuration module and a conversion analysis module;
the analysis template configuration module is used for formulating a template configuration view according to data in the database;
the analysis display configuration module is used for adding a cell merging button, a table style, a font style, a cell function emphasizing button, configuration style attributes and an emphasizing coordinate on the basis of the template configuration view;
and the conversion analysis module is used for loading an analysis object borne by the template, converting the analysis object into an analysis statement for analysis, outputting an analysis result, and rendering the analysis statement into the template configuration view according to a display table corresponding to the configuration drawing which is analyzed and displayed.
The further technical scheme is as follows: the system further comprises a management unit for managing the visual graphical elements of the model, the model and the analysis template.
The further technical scheme is as follows: the system also comprises a user unit which is used for acquiring user information from different channels and mapping the user information with the user authority.
The invention also provides a visual modeling multidimensional analysis method, which comprises the following steps:
creating a visual graphical element;
creating a model from the visual graphical elements;
converting and mapping the visual graphic elements in the model to obtain a mapping result, and storing the mapping result in a database;
and configuring an analysis template and an analysis display according to the data in the database, performing statement conversion and engine analysis on an analysis object, and rendering a view according to an analysis result.
The further technical scheme is as follows: the step of creating a model according to the visual graphic element comprises the following specific steps:
creating a space of a model;
initializing a basic view frame, and selecting the type of a model;
initializing a visual graphic element and arranging the visual graphic element;
utilizing the rule of the model to check and attach a common element, and combining the common element with the arranged visual graphic element to form the model;
the model is persisted into a database.
The further technical scheme is as follows: the method comprises the following steps of converting and mapping visual graphic elements in a model, acquiring a mapping result, and storing the mapping result in a database, wherein the steps comprise the following specific steps:
serializing the model;
extracting attributes of visual graphic elements in the model;
creating a corresponding analysis object, and endowing the analysis object with attributes according to rules;
mapping the attributes of the visual graphical element to the attributes of the analysis object;
the analysis object is converted into a binary stream and persisted into a database.
The further technical scheme is as follows: the method comprises the following steps of configuring an analysis template and an analysis display according to data in a database, performing statement conversion and engine analysis on an analysis object, and rendering a view according to an analysis result, and comprises the following specific steps:
reading the model;
creating an analysis template and acquiring a template configuration view;
configuring rules of the analysis template;
configuring a display rule of an analysis template;
converting an analysis object mapped by a visual graphic element in the model into an analysis statement for analysis, and recording the persistence of the analysis statement into a database;
and outputting an analysis result after analysis, and rendering to the template configuration view according to the analysis result and a display table corresponding to the configuration drawing displayed by the template.
Compared with the prior art, the invention has the beneficial effects that: the visual modeling multi-dimensional analysis system of the invention utilizes visual graphic elements to carry out visual modeling by arranging the visual modeling unit, the mapping unit and the analysis unit, provides a visual and concrete graphic interface which accords with the logical thinking of most non-technical personnel, the graphic space, the non-technical personnel understand the multidimensional model and the technical code implementation details are stripped, a great deal of learning cost is saved, if the function of the model needs to be modified, can be realized by the mapping of the mapping unit without consuming a great deal of communication time on the document specification with non-technical personnel, the modeling efficiency is improved through the analysis unit, the model completely meets the standard in zero error, the time cost for learning the implementation technology of the dimensional multi-engine and the configuration standard in modeling is saved, the modeling efficiency is improved, and the generation of errors is reduced.
The invention is further described below with reference to the accompanying drawings and specific embodiments.
Drawings
Fig. 1 is a block diagram of a visual modeling multidimensional analysis system according to an embodiment of the present invention;
fig. 2 is a block diagram of a visualization modeling unit according to an embodiment of the present invention;
fig. 3 is a block diagram of a mapping unit according to an embodiment of the present invention;
fig. 4 is a block diagram of an analysis unit according to an embodiment of the present invention;
FIG. 5 is a flowchart of a visual modeling multidimensional analysis method according to an embodiment of the present invention;
FIG. 6 is a flowchart of creating a visual graphical element according to an embodiment of the present invention;
FIG. 7 is a flowchart illustrating the transformation and mapping of visual graphical elements within a model according to an embodiment of the present invention;
fig. 8 is a flowchart for performing statement transformation and engine analysis on an analysis object and rendering a view according to an analysis result according to an embodiment of the present invention.
Detailed Description
In order to more fully understand the technical content of the present invention, the technical solution of the present invention will be further described and illustrated with reference to the following specific embodiments, but not limited thereto.
As shown in the specific embodiments of fig. 1 to 8, the visual modeling multidimensional analysis system provided in this embodiment can be applied to a modeling process and a multidimensional analysis process on modeled contents, so that time cost for learning a technology for implementing a multidimensional multi-engine and learning a configuration specification during modeling is saved, modeling efficiency is improved, and errors are reduced.
As shown in fig. 1, the present embodiment provides a visual modeling multidimensional analysis system, which includes:
the visual modeling unit 1 is used for defining a multi-dimensional visual graphic element, attributes of the multi-dimensional visual graphic element, default public attributes of a model, configuration rules and controlling the configuration of the visual graphic element of the model by a user for visual modeling;
the mapping unit 2 is used for converting and mapping the visual graphic elements and the analysis objects in the visual modeling unit 1 and storing mapping results into a database;
and the analysis unit 3 is used for configuring the analysis template and the analysis display according to the data in the database, performing statement conversion and engine analysis on the analysis object, and rendering a view according to the analysis result.
The visual modeling unit 1 has a visual modeling function, the model established by the visual modeling unit 1 realizes the mapping of the graphic state and the model object by using the visual technology, provides a visual and concrete graphic interface and graphic space which accord with the logical thinking of most non-technical personnel, realizes detail stripping of the non-technical personnel to the understanding of the multi-dimensional model and the technical code, and saves a large amount of learning cost. The modeling specification is directly limited to the use and position arrangement of the graphic original, and non-technical personnel do not need to care about complex specifications, so that the generation of errors is greatly reduced.
The mapping unit 2 is mainly used for mapping the visual graphic element, and if a developer needs to add a new multi-dimensional model function and configure, the developer only needs to develop the mapping of the corresponding configuration and the visual graphic element, that is, a large amount of communication time is not consumed on the document specification with a non-technician.
For the analysis unit 3, if the modification of the multidimensional analysis object or the modification of the analysis specification is involved, the graphic model may be left intact, and only the mapping relationship between the graphic model and the multidimensional analysis object and the structure of the multidimensional analysis object need to be modified and remapped once, so that the service layer and the technology bottom layer are perfectly isolated. The business layer is more fit for non-technical personnel, and developers can conveniently maintain the system. A loosely coupled architecture is made.
The visual graphic modeling is more fit with the logical thinking of non-technical personnel, graphic understanding and graphic memory are carried out on multi-dimensional analysis, and because the modeling view operation limits the modeling behavior, modeling personnel can quickly perceive errors and modify the errors, so that the modeling efficiency is improved, and the model completely conforms to the standard without errors.
In some embodiments, as shown in fig. 2, the above-mentioned visual modeling unit 1 includes an element definition module 11, an element attribute definition module 12, a modeling space definition module 13, a modeling rule definition module 14, and a modeling operation setting module 15.
And the element definition module 11 is used for defining basic multi-dimensional elements, database connection elements, database table elements, index elements and dimension elements, and defining at least one of the shape, the size, the color and the label of each element to form a visual graphic element.
The component attribute defining module 12 is used for defining attributes of different components which need to be configured and display modes of the attributes.
And the modeling space definition module 13 is used for defining default common attributes of the model and acquiring a space meeting requirements by controlling the style of the view elements.
And the modeling rule definition module 14 is used for defining configuration rules of the visual graphic elements in the model through code configuration rules and a view element control mode so as to arrange the visual graphic elements.
A modeling operation setting module 15 for controlling at least one of a position, a hierarchy, a transparency, a color, and a shape of the visual graphic element.
In particular, the component definition module 11 defines the shape, size, color and label of the visual view component to distinguish different components, and the drawing of the component is based on the graphics technology of html 5. The SVG label is mainly used.
The component attribute definition module 12 defines attributes of different components to be configured and display modes of the attributes, and implements a configuration view and a configuration management view. And specifying an attribute configuration rule, playing a role of prompting when the configuration view is displayed, verifying the configuration according to the configuration rule after the configuration is completed, and prompting configuration personnel to modify.
The modeling space definition module 13 defines default common attributes of the model, and realizes a space with a proper size, which can accommodate multi-dimensional visual graphic elements and adapt to the size of a screen by controlling the styles of the view elements.
The layout level of the visual graphic elements needs to be in accordance with the corresponding rules when modeling, so the modeling rule definition module 14 needs to define the rules, and the operation of part of the rules will not be effective.
In addition, the modeling operation setting module 15 implements an operation function by controlling the position, level, transparency, color, and shape of the view element, and specifically includes multi-dimensional element position arrangement, level relationship arrangement, and association relationship setting.
Further, in some embodiments, as shown in fig. 3, the mapping unit 2 includes a model component attribute extracting module 21, an analysis object defining module 22, an attribute assigning module 23, a component mapping module 24, and a converting module 25.
And the model element attribute extraction module 21 is used for extracting the attributes of each visual graphic element in the model.
An analysis object definition module 22 for defining an analysis object corresponding to a visual graphical element.
And the attribute assigning module 23 is configured to assign the attributes corresponding to the analysis object according to the different types of attribute specifications of the analysis object. The type of the specified attribute is at least one of a number, a character string, an object, a byte, and a boolean.
An element mapping module 24 for mapping the properties of the visual graphical elements of the model to the properties of the analysis object.
And the conversion module 25 is used for converting the analysis object into a binary stream and persisting the binary stream into the database.
And creating an analysis object corresponding to the visual graphic element through the mapping logic of the visual graphic element and the analysis object, and giving the analysis object corresponding attributes, thereby realizing some attribute conversion methods and reading setting methods.
For the above element mapping module 24 and the conversion module 25, the attributes of the visual graphic element belong to heterogeneous system attributes and are carried by json format character strings, and the mapping process mainly defines rules for converting the json character strings into corresponding types, corresponding formats and corresponding values of the analysis object, so as to facilitate mapping of the visual graphic element and the analysis object.
The mapping unit 2 is specifically configured to load a mapping rule first, extract json-format string attributes of the visual graphical element, create a corresponding analysis object, assign attributes to the analysis object according to the rule, call an object method conversion attribute according to the rule so that the attributes of the analysis object meet requirements, and perform corresponding attribute verification. After the analysis object is created, according to some basic information attributes of the visual graphic elements in the model, the binary system is persisted in a database so as to be used in the analysis at a later time.
Further, in some embodiments, the analysis unit 3 includes an analysis template configuration module 31, an analysis display configuration module 32, and a transformation analysis module 33.
An analysis template configuration module 31, configured to formulate a template configuration view according to data in the database;
and the analysis display configuration module 32 is used for adding a cell merging button, a table style, a font style, a cell function emphasizing button, a configuration style attribute and an emphasized coordinate on the basis of the template configuration view.
And the conversion analysis module 33 is configured to load an analysis object carried by the template, convert the analysis object into an analysis statement for analysis, output an analysis result, and render the analysis statement into the template configuration view according to a display table corresponding to the configuration drawing to be displayed through analysis.
For the analysis template configuration module 31, specifically, a template configuration view is made, a selection is provided by preloading multidimensional models, a row area, a column area and a filtering area are made after a corresponding multidimensional model is selected, and dimension elements are distributed to a designated area in a dragging manner; an index area is established, and index elements are distributed to the index area in a dragging mode to determine indexes needing to be analyzed; the method comprises the steps of making sorting, slicing, drilling up, drilling down, analyzing line numbers, removing levels, browsing a template and storing a template button, realizing various analysis functions, recording an analysis object ID of the multidimensional visual graphic element, and storing the analysis template and then persisting the analysis template into a database. Slicing, drilling up and drilling down can be configured into visual graphic elements for selection by a user, and flexible assembly is realized
The analysis display configuration module 32 adds a cell merge button, a table style, a font style, a cell function emphasis button, a configuration style attribute, and an emphasis coordinate on the basis of the template configuration view. And after the analysis template is changed, the analysis template is stored and is persisted into a database.
For the conversion analysis module 33, specifically, an open source analysis engine mondrain is used to load an analysis object carried by an analysis template, convert the analysis object into an analysis statement, record the analysis statement into a database for persistence, provide the analysis record to a developer maintenance system, start analysis after the analysis is successfully loaded, output an analysis result, render a display form corresponding to a display configuration drawing of the analysis template, and visually present the display form to a template configuration view for a user to view. The time cost for learning the implementation technology of the dimension multi-engine and learning the configuration specification during modeling is saved, and the time cost for an analysis system to learn from a new time and to modify the original configuration due to the modification of the modeling specification is also saved.
In addition, in some embodiments, the system further includes a management unit for managing the visual graphical elements of the model, and the analysis template. The management of visual graphic elements and the management of user templates are realized; the user can save the template of the multidimensional model for later use, or simply modify the template to be applied to other multidimensional analysis scenes, and the template can be shared by other users for common use. The management of the visual graphic elements is that the functions of retrieval, addition, modification, deletion, verification of basic attributes of the elements and release of the elements are given by making an element list view, a configuration view and an attached attribute adding view, and the functions are stored and persisted to a database; for the management of the model, a model list view, a configuration view and a public attribute adding view are made, functions of retrieval, addition, modification, deletion, public attribute verification and model release are given, and the modification function is triggered and transferred to the visual modeling unit 1 and is stored and persisted to a database; for the management of the analysis template, an analysis template list view is made, functions of retrieval, addition, modification, deletion and template release are given, and the functions are stored and persisted to a database.
Further, in some embodiments, the system further includes a user unit, configured to obtain user information from different channels and map the user information with user rights. The user unit uses the user authority as a core, and mapping is carried out on the user information acquired by different channels and the user authority, so that the user information acquisition logic and the user authentication logic are independently realized, the mapping of the unique identification number and the authority of the user is only maintained, and the user information is not required to be maintained. Different from the traditional channel-based user management, the method provides simple and efficient technical support for absorbing user resources to the maximum extent; the user unit specifically comprises three contents of user authentication, authentication channel management and user authority configuration, wherein the user authentication records basic information of a channel provided by a user, an interface for acquiring user information is specified for a user channel provider, and the user authentication interface is used for realizing authentication to acquire the user information; the authentication channel management realizes the registration and opening of a user channel by recording the basic information of a channel provided by a user, controls the validity of a channel user, and manages the basic information configuration of the channel for the use of authentication logic; the user authority configuration specifically defines an authority unique identification code, an authority name, an authority scope (namely, which functions and visual graphic elements are acted on) and authority validity for the authority configuration. And mapping the user authority configuration and the unique user identification number with the unique identification code of the authority to endow the corresponding authority to the user. It is achieved that visual graphical elements can be used for controlling the modeling process according to the user authority.
The visual modeling multi-dimensional analysis system utilizes visual graphic elements to carry out visual modeling by arranging the visual modeling unit 1, the mapping unit 2 and the analysis unit 3, provides a visual and concrete graphic interface which accords with the logical thinking of most non-technical personnel, the graphic space, the non-technical personnel understand the multidimensional model and the technical code implementation details are stripped, a great deal of learning cost is saved, if the function of the model needs to be modified, can be realized by the mapping of the mapping unit 2 without consuming a great deal of communication time on the document specification with non-technical personnel, the modeling efficiency is improved through the analysis unit 3, the model completely meets the standard in zero error, the time cost for learning the implementation technology of the dimension multi-engine and the configuration standard during modeling is saved, the modeling efficiency is improved, and the generation of errors is reduced.
As shown in fig. 5, the present embodiment further provides a multidimensional visualization modeling analysis method, including:
s1, creating a visual graphic element;
s2, creating a model according to the visual graphic elements;
s3, converting and mapping the visual graphic elements in the model to obtain a mapping result, and storing the mapping result in a database;
and S4, configuring the analysis template and the analysis display according to the data in the database, performing statement conversion and engine analysis on the analysis object, and rendering a view according to the analysis result.
For the above step S1, the step of creating a visual graphical element includes the following specific steps:
s11, creating a visual graphic element, and selecting the type of the visual graphic element;
s12, configuring the attribute of the visual graphic element according to the type;
s13, judging whether the attribute configuration meets the requirement;
s14, if not, modifying the attribute of the visual graphic element, and entering the next step, if yes, directly entering the next step;
and S15, saving the visual graphic element in the database.
Further, in some embodiments, the step of creating a model according to the visual graphic element in the step of S2 includes the following specific steps:
s21, creating a model space;
s22, initializing a basic view frame, and selecting the type of the model;
s23, initializing visual graphic elements and arranging the visual graphic elements;
s24, utilizing the rule of the model to verify and attach a common element, and combining the common element with the arranged visual graphic element to form the model;
and S25, persisting the model into the database.
The steps from S21 to S25 realize the mapping of the graphic state and the model object by using the visualization technology, provide a graphic interface which is intuitive and specifically accords with the logical thinking of most non-technical personnel, provide a graphic space, and separate the understanding of the non-technical personnel on the multi-dimensional model and the realization details of the technical code, thereby saving a great deal of learning cost. The modeling specification is directly limited to the use and position arrangement of the graphic original, and non-technical personnel do not need to care about complex specifications, so that the generation of errors is greatly reduced.
In addition, in some embodiments, the step of S3, converting and mapping the visual graphic element in the model, obtaining the mapping result, and storing the mapping result in the database, includes the following specific steps:
s31, serializing the model;
s32, extracting the attribute of the visual graphic element in the model;
s33, creating a corresponding analysis object, and giving the analysis object attributes according to rules;
s34, mapping the attribute of the visual graphic element to the attribute of the analysis object;
and S35, converting the analysis object into a binary stream, and storing the binary stream in a database in a persistent mode.
The attributes of the visual graphic elements belong to the attributes of heterogeneous systems and are borne by json format character strings, and the mapping process mainly defines rules for converting the json character strings into corresponding types, corresponding formats and corresponding values of analysis objects so as to facilitate the mapping of the visual graphic elements and the analysis objects.
Firstly loading a mapping rule, extracting json format character string attributes of a visual graphic element, creating a corresponding analysis object, endowing the analysis object with attributes according to the rule, calling an object method conversion attribute according to the rule to enable the attributes of the analysis object to meet requirements, and carrying out corresponding attribute verification. After the analysis object is created, according to some basic information attributes of the visual graphic elements in the model, the binary system is persisted in a database so as to be used in the analysis at a later time. If a developer needs to add a new multi-dimensional model function and configure, the developer only needs to develop the mapping of the corresponding configuration and the visual graphic element, namely, a large amount of communication time is not consumed on the document specification by a non-technical person.
Further, in some embodiments, the step of S4, configuring the analysis templates and the analysis displays according to the data in the database, performing statement transformation and engine analysis on the analysis objects, and rendering the view according to the analysis results includes the following specific steps:
s41, reading the model;
s42, creating an analysis template and acquiring a template configuration view;
s43, configuring the rule of the analysis template;
s44, configuring the display rule of the analysis template;
s45, converting the analysis object mapped by the visual graphic element in the model into an analysis statement for analysis, and recording the persistence of the analysis statement into a database;
and S46, outputting an analysis result after analysis, and rendering to the template configuration view according to the analysis result and the display table corresponding to the configuration drawing displayed by the template.
If the modification of the multidimensional analysis object or the modification of the analysis specification is involved, the graphic model can be kept intact, and only the mapping relation between the graphic model and the multidimensional analysis object needs to be modified, the structure of the multidimensional analysis object needs to be re-mapped once, and the service layer and the technical bottom layer are perfectly isolated. The business layer is more fit for non-technical personnel, and developers can conveniently maintain the system. A loosely coupled architecture is made.
Loading an analysis object carried by an analysis template by using an open source analysis engine mondrain, converting the analysis object into an analysis statement, recording the analysis statement and persisting the analysis statement into a database, providing an analysis record to a developer maintenance system, starting analysis after the loading is successful, rendering a display form corresponding to a display configuration drawing of the analysis template to a template configuration view after an analysis result is output, and visually presenting the display form to a user for viewing. The time cost for learning the implementation technology of the dimension multi-engine and learning the configuration specification during modeling is saved, and the time cost for an analysis system to learn from a new time and to modify the original configuration due to the modification of the modeling specification is also saved.
For example, when the method is applied to financial statement analysis, business personnel visually establish an analysis model corresponding to a statement, then establish different analysis templates according to the analysis model aiming at different business analysis requirements, and through engine analysis, the business personnel can see the multidimensional statement corresponding to the business.
The method comprises the following specific steps: establishing a model, defining a plurality of index elements (manpower expenditure, activity expenditure, site expenditure, contract income), defining a plurality of dimension elements (year, month, city, company department), defining a data source connecting element, defining a target database element, defining a target data table element, dragging and arranging a position hierarchy of the dimension elements, and storing the model; dragging index elements (manpower expenditure, contract income) to an analysis index bar, dragging dimension elements (years, months) to an analysis dimension bar, and checking specific years, months, configuring a filtering condition with dimensions (city, guangzhou), or configuring dimension slices, sorting, displaying the number of strips, and other analysis behaviors; and forming an analysis result according to the analysis template, and forming a report form according to the display configuration of the analysis template, so that business personnel can visually browse the personalized multidimensional form after analysis.
According to the visual modeling multidimensional analysis method, visual modeling is carried out by utilizing the visual graphic element, a graphic interface which is visual and specifically accords with most of logic thinking of non-technical personnel is provided, the graphic space is provided, the understanding of the non-technical personnel on the multidimensional model and the details of technical code implementation are stripped, a large amount of learning cost is saved, if the function of the model needs to be modified, the mapping implementation of the visual graphic element and an analysis object can be utilized, a large amount of communication time does not need to be consumed on document specification by the non-technical personnel, the modeling efficiency is improved by analyzing the analysis object, the model zero error completely accords with the specification, the time cost for learning the implementation technology of the dimensional multi-engine and the configuration specification is saved during modeling, the modeling efficiency is improved, and the generation of errors is reduced.
The technical contents of the present invention are further illustrated by the examples only for the convenience of the reader, but the embodiments of the present invention are not limited thereto, and any technical extension or re-creation based on the present invention is protected by the present invention. The protection scope of the invention is subject to the claims.
Claims (8)
1. A visual modeling multidimensional analysis system, the system comprising:
the visual modeling unit is used for defining a multi-dimensional visual graphic element, attributes of the multi-dimensional visual graphic element, default public attributes of the model, configuration rules and controlling the configuration of the model visual graphic element by a user so as to perform visual modeling;
the mapping unit is used for converting and mapping the visual graphic element and the analysis object in the visual modeling unit and storing the mapping result into a database;
the analysis unit is used for configuring an analysis template and an analysis display according to data in the database, performing statement conversion and engine analysis on an analysis object, and rendering a view according to an analysis result;
the visual modeling unit comprises an element definition module, an element attribute definition module, a modeling space definition module, a modeling rule definition module and a modeling operation setting module;
the element definition module is used for defining basic multi-dimensional elements, database connection elements, database table elements, index elements and dimension elements, and defining at least one of the shape, the size, the color and the label of each element to form a visual graphic element;
the component attribute definition module is used for defining attributes of different components needing configuration and display modes of the attributes;
the modeling space definition module is used for defining default public attributes of the model and controlling the view element style to acquire a space meeting the requirements;
the modeling rule definition module is used for defining configuration rules of visual graphic elements in the model through code configuration regulations and a view element control mode so as to arrange the visual graphic elements;
the modeling operation setting module is used for controlling at least one of the position, the hierarchy, the transparency, the color and the shape of the visual graphic element.
2. The visual modeling multidimensional analysis system of claim 1, wherein the mapping unit comprises a model element attribute extraction module, an analysis object definition module, an attribute assignment module, an element mapping module, and a conversion module;
the model element attribute extraction module is used for extracting the attributes of each visual graphic element in the model;
the analysis object definition module is used for defining an analysis object corresponding to the visual graphic element;
the attribute giving module is used for giving corresponding attributes to the analysis objects according to different types of attribute specifications of the analysis objects;
the element mapping module is used for mapping the visual graphic element attribute of the model to the attribute of the analysis object;
and the conversion module is used for converting the analysis object into a binary stream and persisting the binary stream into the database.
3. The visual modeling multidimensional analysis system of any one of claims 1 to 2, wherein the analysis unit comprises an analysis template configuration module, an analysis presentation configuration module, and a transformation analysis module;
the analysis template configuration module is used for formulating a template configuration view according to data in the database;
the analysis display configuration module is used for adding a cell merging button, a table style, a font style, a cell function emphasizing button, configuration style attributes and an emphasizing coordinate on the basis of the template configuration view;
and the conversion analysis module is used for loading an analysis object borne by the template, converting the analysis object into an analysis statement for analysis, outputting an analysis result, and rendering the analysis statement into the template configuration view according to a display table corresponding to the configuration drawing which is analyzed and displayed.
4. The visual modeling multidimensional analysis system of claim 3, further comprising a management unit for managing visual graphical elements of the model, and the analysis templates.
5. The visual modeling multidimensional analysis system of claim 4, further comprising a user unit for obtaining user information from different channels and mapping the user information to user permissions.
6. A method for multidimensional visual modeling, the method comprising:
creating a visual graphical element;
creating a model from the visual graphical elements;
converting and mapping the visual graphic elements in the model to obtain a mapping result, and storing the mapping result in a database;
configuring an analysis template and an analysis display according to data in a database, performing statement conversion and engine analysis on an analysis object, and rendering a view according to an analysis result;
the step of creating a model according to the visual graphic element comprises the following specific steps:
creating a space of a model;
initializing a basic view frame, and selecting the type of a model;
initializing a visual graphic element and arranging the visual graphic element;
utilizing the rule of the model to check and attach a common element, and combining the common element with the arranged visual graphic element to form the model;
the model is persisted into a database.
7. The multidimensional analysis method for visual modeling according to claim 6, wherein the step of converting and mapping the visual graphic elements in the model to obtain the mapping result and storing the mapping result in the database comprises the following specific steps:
serializing the model;
extracting attributes of visual graphic elements in the model;
creating a corresponding analysis object, and endowing the analysis object with attributes according to rules;
mapping the attributes of the visual graphical element to the attributes of the analysis object;
the analysis object is converted into a binary stream and persisted into a database.
8. The multidimensional analysis method for visual modeling according to any one of claims 6 to 7, wherein the steps of configuring analysis templates and analysis displays according to data in a database, performing statement transformation and engine analysis on analysis objects, and rendering views according to analysis results comprise the following specific steps:
reading the model;
creating an analysis template and acquiring a template configuration view;
configuring rules of the analysis template;
configuring a display rule of an analysis template;
converting an analysis object mapped by a visual graphic element in the model into an analysis statement for analysis, and recording the persistence of the analysis statement into a database;
and outputting an analysis result after analysis, and rendering to the template configuration view according to the analysis result and a display table corresponding to the configuration drawing displayed by the template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710901773.0A CN107807954B (en) | 2017-09-28 | 2017-09-28 | Visual modeling multidimensional analysis system and method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710901773.0A CN107807954B (en) | 2017-09-28 | 2017-09-28 | Visual modeling multidimensional analysis system and method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107807954A CN107807954A (en) | 2018-03-16 |
| CN107807954B true CN107807954B (en) | 2021-08-17 |
Family
ID=61584155
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710901773.0A Active CN107807954B (en) | 2017-09-28 | 2017-09-28 | Visual modeling multidimensional analysis system and method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107807954B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109523318A (en) * | 2018-11-16 | 2019-03-26 | 杭州市商务委员会（杭州市粮食局） | The analysis platform of electronic commerce data visual modeling transboundary |
| CN109582837A (en) * | 2018-11-30 | 2019-04-05 | 长城计算机软件与系统有限公司 | A kind of visualized data processing method based on cloud and system |
| CN110059267A (en) * | 2019-03-01 | 2019-07-26 | 平安科技（深圳）有限公司 | Methods of exhibiting, device, computer equipment and the storage medium of data analysis result |
| CN110489612A (en) * | 2019-08-26 | 2019-11-22 | 秒针信息技术有限公司 | A kind of the multi objective monitoring method and device of information |
| CN110688109A (en) * | 2019-10-09 | 2020-01-14 | 凯德技术长沙股份有限公司 | Model editing system and creation method thereof |
| CN111427867B (en) * | 2020-03-30 | 2023-10-20 | 杭州华望系统科技有限公司 | Model persistence method based on hybrid storage |
| CN111736821B (en) * | 2020-06-28 | 2024-01-09 | 中国电子产品可靠性与环境试验研究所（（工业和信息化部电子第五研究所）（中国赛宝实验室）） | Visual modeling analysis method, system, computer device and readable storage medium |
| CN114595231B (en) * | 2022-03-15 | 2024-02-27 | 苏州峰之鼎信息科技有限公司 | Database table generation method and device, electronic equipment and storage medium |
| CN114741080A (en) * | 2022-04-24 | 2022-07-12 | 北京格睿德思信息科技有限公司 | Big data display method based on artificial intelligence |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101271475A (en) * | 2008-04-02 | 2008-09-24 | 北京邮电大学 | Commercial intelligent system |
| CN102708126A (en) * | 2011-02-28 | 2012-10-03 | 微软公司 | Data visualization design and view systems and methods |
| CN104317559A (en) * | 2014-08-26 | 2015-01-28 | 国家电网公司 | Visual modeling platform based on GMF |
| CN105183968A (en) * | 2015-08-28 | 2015-12-23 | 汉诺·凯霍宁 | Visual modeling method for arch structure |
| CN105677680A (en) * | 2014-11-20 | 2016-06-15 | 国家电网公司 | Networked synchronization and conversion method for geographical wiring diagrams |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9870629B2 (en) * | 2008-06-20 | 2018-01-16 | New Bis Safe Luxco S.À R.L | Methods, apparatus and systems for data visualization and related applications |
-
2017
- 2017-09-28 CN CN201710901773.0A patent/CN107807954B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101271475A (en) * | 2008-04-02 | 2008-09-24 | 北京邮电大学 | Commercial intelligent system |
| CN102708126A (en) * | 2011-02-28 | 2012-10-03 | 微软公司 | Data visualization design and view systems and methods |
| CN104317559A (en) * | 2014-08-26 | 2015-01-28 | 国家电网公司 | Visual modeling platform based on GMF |
| CN105677680A (en) * | 2014-11-20 | 2016-06-15 | 国家电网公司 | Networked synchronization and conversion method for geographical wiring diagrams |
| CN105183968A (en) * | 2015-08-28 | 2015-12-23 | 汉诺·凯霍宁 | Visual modeling method for arch structure |
Non-Patent Citations (1)
| Title |
|---|
| 虚拟实验的场景建模和可视化技术研究;刘凤云;《中国优秀硕士学位论文全文数据库 信息科技辑》;20120415(第4期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107807954A (en) | 2018-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107807954B (en) | Visual modeling multidimensional analysis system and method thereof | |
| CN114035773B (en) | Configuration-based low-code form development method, system and device | |
| CN104881275B (en) | A kind of electronic report forms generation method and device | |
| CN107886439A (en) | Insurance products development approach, device, equipment and computer-readable recording medium | |
| CN104035772A (en) | Static analysis based source code multi-versionfunction call relation difference identification method | |
| CN103778107A (en) | Method and platform for quickly and dynamically generating form based on EXCEL | |
| CN110991157A (en) | Engineering quality evaluation system design method based on electronic file credible technology | |
| CN115061721A (en) | Report generation method and device, computer equipment and storage medium | |
| CN101675415B (en) | Program pattern analyzer, pattern appearance status information production method, pattern information generating device, and program | |
| US20150052157A1 (en) | Data transfer content selection | |
| CN113435171B (en) | Interpretation execution system of data statistical logic of code-free data filling | |
| CN105630747A (en) | Inspection report specialization system and method applied to special device industry | |
| CN111596899A (en) | Database migration method, system, equipment and storage medium based on Java development | |
| CN110609989A (en) | Operation method for rapidly generating information form by adopting predefined layout component and application | |
| CN111190880A (en) | Database detection method and device and computer readable storage medium | |
| CN107766519B (en) | Method for visually configuring data structure | |
| CN113641719A (en) | Data processing method, data processing device, computer and storage medium | |
| KR101022716B1 (en) | System for generating automatically electronic document and method thereof | |
| CN102043769A (en) | Method and device for editing documents | |
| CN103699520A (en) | Font processing method for maintaining e-document layout | |
| KR20210071519A (en) | Method and Apparatus for Constructing Library construction for standardization of drawing creation and drawing creation using the Library | |
| CN116028062A (en) | Target code generation method, NPU instruction display method and device | |
| CN110941629A (en) | Metadata processing method, device, equipment and computer readable storage medium | |
| KR20200091561A (en) | Method and system for automating customs declaration and error detection process | |
| CN113687827B (en) | Data list generation method, device and equipment based on widget and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |