CN103177308A - Intelligent decision-making support system for project management - Google Patents
Intelligent decision-making support system for project management Download PDFInfo
- Publication number
- CN103177308A CN103177308A CN2011104307956A CN201110430795A CN103177308A CN 103177308 A CN103177308 A CN 103177308A CN 2011104307956 A CN2011104307956 A CN 2011104307956A CN 201110430795 A CN201110430795 A CN 201110430795A CN 103177308 A CN103177308 A CN 103177308A
- Authority
- CN
- China
- Prior art keywords
- data
- level
- project
- module
- processing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides an intelligent decision-making support system for project management and aims at helping a management layer to make enterprise decisions well and learn the operation situation of an enterprise timely. The intelligent decision-making support system can timely and accurately finish querying, journaling and analysis of required information through simple and intuitive operation and acquainted business languages, and assists users to make scientific decisions.
Description
Technical field
The application relates to information management technique, particularly relates to a kind of intelligent decision support system of project management.
Background technology
Business intelligence is called for short BI (Business Intelligence), refers to make data become available information by collection, management, analysis and conversion to data, thereby obtains necessary clairvoyance and comprehension, better aid decision making and guidance action.It is can help the user to own service operation make the instrument of correct wise decision-making; Utilize the data enhancement of enterprise's accumulation to the understanding of service conditions, help the user to make timely, correct judgement in service management and development, then adopt wise action.
Early stage in business intelligence development, along with IT application in enterprise, ERP (Enterprise Resource Planning particularly, Enterprise Resources Plan) popularization and application, application and transacter for enterprise's structure, help enterprise progressively to realize the integration of internal, external whole resource, realized effective utilization of Enterprise Resource.
Traditional E RP is online transaction processing system, and application and affairs have contained following several business functions: financial management, supply chain management, human resource management, purchasing management, production management, stock control, sales management, customer relation management etc.ERP is the operation of finishing service function.ERP does high efficiency real-time operation processing to raw data, produces a large amount of real-time target datas, and the Planning and controlling of construction that carries out business with target data is the basic function of ERP.The Planning and controlling of construction process of ERP finishes, and has a large amount of process datas to be deposited in system.Therefore, from the viewpoint of data utilization, the data that ERP system retains are not fully utilized except " for future reference ", " tracking ".And the potentiality that ERP system is larger are not brought into play, and the data volume that increases rapidly even also becomes the heavy burden of system.
From the Life cycle of data, the data in ERP system are being put down in writing the life track of enterprise and are being implied " secret " of enterprise, but ERP does not have means to identify it.Therefore enterprise has only reclaimed a part to ERP to investment, and the data shape of ERP system accumulation is as a gold mine of not developed, and ERP itself does not have the means of excavation, becomes the sorry greatly of traditional E RP.
In addition, the ERP database lacks the effective tissue to historical data: if the data owner of ERP is real-time, lacks the accumulation of historical data and be convenient to analyze the resulting structure of access.From the analyzing and processing process, analyze the working time that generally needs the multilist operation, grows, carry out analysis and the reasoning of decision-making if directly utilize existing data in the database of ERP operation system, the efficient of ERP system OLTP will be affected, and cause busy network data transmission, difficult especially when the direct access history data of needs.
Many defectives based on above ERP system need to provide a kind of intelligent decision support system, make better business decision to help administration and supervision authorities, better understand more in time the operation situation of this enterprise.
Summary of the invention
The application provides a kind of intelligent decision support system of project management, makes better business decision to help administration and supervision authorities, better understands more in time the operation situation of this enterprise.
In order to address the above problem, the application discloses a kind of intelligent decision support system of project management, comprising:
Ground floor DBMS abstraction module is used for processing from the corporate level project data of multisystem extraction various dimensions;
Second layer DBMS abstraction module is used for processing from the regional-level project data of multisystem extraction various dimensions;
The 3rd hierarchical data abstraction module is used for processing from the department level project data of multisystem extraction various dimensions;
The 4th hierarchical data abstraction module is used for processing from the project level project data of multisystem extraction various dimensions;
The first level represents module, and the data of company level after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The second level represents module, and the regional-level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The 3rd level represents module, and the department level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The 4th level represents module, and the project level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
Wherein, each level represents module and comprises following submodule:
The first dimension represents submodule, is used for from the time cycle dimension, and the data after processing are represented form with chart intuitively;
The second dimension represents submodule, is used for from the time cycle dimension, and the data after processing are represented form with chart intuitively;
Third dimension degree represents submodule, is used for from single index dimension, and the data after processing are represented form with chart intuitively.
Preferably, each level represents module and also comprises following submodule:
Computer platform represents submodule, and the data that are used for after processing on all kinds of computer platforms represent form with chart intuitively;
Mobile platform represents submodule, and the various business decision data-pushings that are used for generating on computing machine are to mobile device, represents form with chart intuitively and is presented on mobile device.
Preferably, described system also comprises: compatible modules, be used for carrying out compatibility with various heterogeneous systems, and described heterogeneous system comprises project management system and financial system.
Preferably, described system also comprises: the intelligence inquire module, be used for according to actual business requirement, and the definition query object also retrieves the data that need from database, the cleaning and filtering conversions of while complete paired data in query script etc. obtain the data that the user finally needs.
Preferably, described system also comprises: the dynamic statement module, be used for the Query Result with described intelligence inquire module generation, and be generated as various forms of forms, and various figures are edited and be converted into to report entry.
Preferably, described system also comprises: fixing Reports module, be used for the independent form of making, and fixedly the row, column title of form is fixed, and in form, each cell data is by independently formula definition generation.
Preferably, described system also comprises: the on-line analytical processing module, be used for according to service needed, extract the related service data from database, and the data of extracting are carried out the analysis of different angles, different depth, finally form the multidimensional bordereaux, and according to the objective law of data in form, trend in the discovery data provides the decision-making foundation of science with abnormal to the decision maker.
Preferably, described on-line analytical processing module comprises cube and multidimensional form, and wherein said cube is preserved business data with hierarchical structure, can generate a plurality of light Study documents based on a cube; Described on-line analytical processing module gathers fast the business datum of different levels, and the mode of data with the multidimensional form is shown by creating cube.
Preferably, described system also comprises: data typing module, and for all functions and the data input function that integrate business intelligence, with the complete cover data typing of single platform, verification, inquiry, analysis and statistics.
Preferably, described system also comprises: the data pumping out system, be used for by query-defined data warehouse object table, and utilize query function to make data and extract, generate calculated field, translation type and data cleansing, and pump by data and be loaded into data warehouse.
Compared with prior art, the application comprises following advantage:
The intelligent decision support system that the application provides can use the service language of oneself being familiar with by the operation of simple, intuitive, completes in time, exactly inquiry, form, the analysis of information needed, and assisted user is made more scientific decision-making.
Description of drawings
Fig. 1 is the management hierarchy schematic diagram of driving cabin in the embodiment of the present application;
Fig. 2 is the concrete example schematic diagram of driving cabin management hierarchy in the embodiment of the present application;
Fig. 3 is that the panel board of driving cabin in the embodiment of the present application is showed schematic diagram;
Fig. 4 is the histograms show schematic diagram of driving cabin in the embodiment of the present application;
Fig. 5 is the histograms show schematic diagram with summation curve of driving cabin in the embodiment of the present application;
Fig. 6 is that the pie chart of driving cabin in the embodiment of the present application is showed schematic diagram;
Fig. 7 is driving cabin schematic diagram of company level in the embodiment of the present application;
Fig. 8 is the regional-level driving cabin schematic diagram of single index dimension in the embodiment of the present application;
Fig. 9 is single index dimension department level driving cabin schematic diagram in the embodiment of the present application;
Figure 10 is single index dimension project level driving cabin schematic diagram in the embodiment of the present application;
Figure 11 is that in the embodiment of the present application, time cycle dimension driving cabin shows schematic diagram;
Figure 12 is indicator of costs driving cabin schematic diagram in the embodiment of the present application;
Figure 13 shows the schematic diagram of intelligent decision support system on mobile device in the embodiment of the present application;
Figure 14 is the general structure schematic diagram of the described intelligent decision support system of the embodiment of the present application.
Embodiment
For above-mentioned purpose, the feature and advantage that make the application can become apparent more, below in conjunction with the drawings and specific embodiments, the application is described in further detail.
Decision support system (DSS) (decision support system is called for short dss) is that aid decision making person passes through data, model and knowledge, carries out the computer application system of semi-structured or non-structural decision with man-machine interaction mode.It is the advanced information management system that management information system (mis) produces to higher one-level development.It calls various information resources and analysis tool for the decision maker provides problem analysis, sets up model, the environment of Simulation and Decision process and scheme, and aid decision making person improves level of decision-making and quality.
The intelligent decision support system of the project management that the application provides help for:
Whether the top policy maker of enterprise: present enterprise and get a profit this year, where present the figures in the expression of value of the linen, as an equivalent, and consequently, as a thing that is value of company in market be;
The middle administrative staff of enterprise: check constantly the achievement of selling group, analyze the sales situation of each sales region;
Business personnel: check constantly every kind of product, each regional sales analysis result;
The manager of information departments: really realize easily enterprise IT project;
IT personnel: get twice the result with half the effort, realize the strongest function with minimum code.
In a word, described intelligent decision support system can use the service language of oneself being familiar with by the operation of simple, intuitive, completes in time, exactly inquiry, form, the analysis of information needed, and assisted user is made more scientific decision-making.
The Core Feature of described intelligent decision support system comprises following aspect:
1) the fixedly form (seamless integrated with Excel) that designs for complex statistics type form especially;
2) Word Report can make form with the environment of Microsoft Word, and advantage is dynamic weekly, monthly magazine and annual report for convenience of, a large amount of completed Microsoft Word forms of fast transition;
3) original creation data copying platforms (ISP), expanded the online data such as the data typing that business intelligence does not have, backstage verifying function, graded examination and approval, workflow management and made a report on function;
4) class Brio EIS Dashboard Manager, user can adopt the fourth generation language exploitation, and advantage is the programming amount of minimizing more than 90%, and can grasp rapidly, understand integral status, can reach the effect that a glance is taken a panoramic view of the situation;
5) the Ultra Speed ETL of class Datastage, the collection of support mass data in the data structure of high complexity, integrated and conversion, advantage is than Microsoft DTS translation data fast 10 times, faster more than 8 times than Oracle JDBC in backstage circulation peek, than peek fast 100 times of interface with former Excel;
6) the interaction display platform of Flash pattern uses simple click type interface importing Excel data and formula, and interactive visualization analysis, chart, image, financial statement and business counter etc. are provided;
7) class SAS forecast analysis data mining capability, 39 kinds of powerful analysis mining algorithms comprise BPTree, DMTree, K-Means, Logistic etc.;
8) class Crystal Report dynamic statement, advantage are that the service-oriented personnel need not programme more than 90% in making form;
9) class Visual SoBIce Safe exploitation is controlled and the version management function;
10) utilize VB or self-defining function to support the JavaScript programming to expand required function, and can be integrated in the systems such as J2EE .net, VB, Deplhi;
11) any Web website of development environment support access is realized the login authentication of any Web, and no matter the service of using any backstage to provide in form, script is .net or Java backstage;
12) more than 1800 api interface is for integration in the future provides powerful general design;
13) high-precision bar code printing technology is supported more than the 20 kind of bar codes such as Code39, Code128, and the multiple two-dimension codes such as QRCode, PDF417 can generating product label quick according to database;
14) distinctive Expression formula function can customize out the statistical function of asking related coefficient, standard deviation, Fisher etc. complicated, is useful in the place that statistics bureau, examination office etc. needs the complex mathematical statistics;
15) dynamic statement is supported VML polar plot and the various dot charts such as GIF, JPG, BMP, supports multi-layer transparent stack output, easily makes to contain the not form of the vector dot matrix symbol of determined number, position, type.
Based on above Core Feature, described intelligent decision support system has following characteristics:
1) the object concept of innovation
System may need all users the element that operates, comprises data source, table, field, condition, parameter, formula, function, inquiry, form etc., through refinement, encapsulation, name, become can manage separately, reuse, the object of flexible combination.This completely new concept of object has been established solid foundation for building various application, greatly improves information utilization.
2) careful Object Management group
System provides the Object Management group mechanism of a cover science, and (as parameter, condition, formula etc.) management automatically classifies object; And support User Defined Object Management group rule, and realize the automatic management of object, greatly user-friendly.Can carry out each object---version is recalled: can look back the construction process of object, and each version of conservation object, each version all can arbitrarily call when needed.
Authorize: object is carried out Embedded safety management, control the user to the operating right of object.
Derive from: by modification, the combination to object, derivative new object.
3) object is used flexibly
Object is realized reusing to copy or to quote dual mode.Object can copy, and the modification of former object is not affected the result that copies; Also can quote, realize that single-point upgrades---revise a place, upgrade all.By drag and drop, the object in different operating district is carried out flexible combination, the user can build rapidly the multiple application such as inquiry, form.
4) the object subregion of science
The partition management concept of system is placed object by different shared range partitions, be respectively equipped with the workspace of the different levels such as work at present district, individual shared region, system's shared region, object can be successively or cross-layer submit to, store classifiedly.The user both can be submitted to individual shared region with the object in work at present district, facilitated other application, improved personal work efficient; Also the object of work at present district, individual shared region can be submitted to system's shared region, share achievement with other people, realize the knowledge accumulation of team.
5) Extraordinary customization platform
The user can be according to needs or the hobby of oneself, and the language of custom-built system, screen background, window layout, menu, toolbar etc. are built the most comfortable workbench, reaches to cause best visual effect.
6) the integrated application of external hanging type
The pure modular construction of described system makes it have sufficient extensibility, can be integrated in plug-in mode with other business application system.The user needn't revise operation system and programming, can easily realize the seamless link of native system and existing business system, greatly improves the service efficiency of application system, and the report capability of Hoisting System.
7) the online operating process of switching
System provides two kinds, the integrated interface operating process of TipWizard and the All In One of hommization.But interactive operation between the two, the online switching selected for the user provides operation flexibly.
8) abundant Report Form Design and kind
List, crosstab, master-salve table, segmentation statistics, Top N, link form, fixing form ... and tens of kinds of editors and Graph Options, more have pair data grouping, sequence, rank, gather, filter, warn, parameter, ask ratio, refresh, drill through, the function too numerous to enumerate such as section, make system become the trustworthy report making of user and data analysis expert.
9) formula that successively goes forward one by one drills through
For by object through the compound and complicated formulas that generates repeatedly, occur when wrong at its operation result, the user can progressively go deep into, and traces to source, for user's debugging and misarrangement brings great convenience.
10) rigorous security control
The object of system's shared region and catalogue all can be carried out security control by the system manager, support role definition, can license to user or user group.In addition, also provide the security control of database to record level, for the user provides more careful, data access security solution more flexibly.
11) multilingual environment
The multi-platform language support of system can arbitrarily be switched the operator in different language environments, system provides simplified form of Chinese Character, Chinese-traditional, English ... wait the multilingual platform, and in future, system can continue to increase abundanter speech selection.
12) diversified file output
No matter be inquiry, form, Study document, all with mutual importing or derivation, also may be output as the multiple file layouts such as PDF, TXT, HTML, EXCEL.
13) across the heterogeneous data source support
System supports the database that all OLE DB and ODBC drive, and has the NativeDriver of special exploitation to connect specific database.System also supports to access simultaneously two or more databases.
Based on above content, the below describes the intelligent decision support system of described project management in detail.
At first, system gathers by project, department, section layer by layer mainly from the PMIS extracted data, represents form abundant, and the applying enterprise management decision-making needs.
The project driving cabin has been built by system take project as core, extract the project data of various dimensions and process from multisystem, represents form with chart intuitively, and the unified driving cabin of Analysis on Project Management, decision-making is provided for enterprise management level and project management department.
The project driving cabin comprises: the contents such as project overview, project cost analysis, operation control data analysis, project milestone, the project chronicle of events, project photo, project news, project form commonly used.
The management hierarchy of driving cabin can be with reference to shown in Figure 1, and management hierarchy is divided into level Four from top to bottom: of company level, regional-level, department level, project level.Fig. 2 is a kind of concrete example of driving cabin management hierarchy.
The project level data are elementary cells of driving cabin management.Four other divisions of level not only represent institutional level, also represent project data attaching relation from bottom to top.
Relation between each rank: plan target decomposes from top to bottom step by step, and actual executing data gathers from bottom to top step by step.
Driving cabin management hierarchy defining principle: should according to the company organization that defines in system, by tree structure definition driving cabin level, and can adjust flexibly as required the attaching relation of subordinate's level.
The organize content of driving cabin comprises:
1) four row's business indicators
Described four row's business indicators comprise: project contracting volume, projects amount list, project go out bill of lading, collect, newly sign a contract volume and the contract amount that comes into force.
Wherein, the project contracting volume goes out the two-part aggregate value of the bill of lading amount of money for the single amount of money of projects amount and the project that the owner confirms.
2) project cost index
Project rate of profit in the project cost quarterly report and project total cost show in the cost driving cabin as the project cost index.Cost driving cabin data are added up take project as base unit.
The project rate of profit comprises: target liability statement rate of profit, implementation period be rate of profit now.
Project cost comprises: target liability statement total cost, implementation period cost.
3) contract account index
Add up the contract account by classification modes such as section, department, project, year, contract type, amount of money scopes, all kinds of indexs of therefrom extracting.
The form that represents of driving cabin comprises:
1) graphic exhibition type
Panel board: pointer indication actual value accounts for the number percent of planned value.It is 0%, 25%, 50%, 75%, 100% that scale is set, and actual value exceeds 100% rear increment by 25% increases scale, until greater than actual value.Specifically can be with reference to example shown in Figure 3.
Histogram: show planned value, the actual value of measurement period, or add up planned value, accumulative total actual value.The left side ordinate is the histogram numerical scale.Specifically can be with reference to example shown in Figure 4
Histogram with summation curve: increase summation curve on the histogram basis.The left side ordinate is the histogram numerical scale.The right side ordinate is the summation curve numerical scale.Specifically can be with reference to example shown in Figure 5.
Pie chart: colored sector region shows grouping numerical value and accounts for the number percent of total amount.Specifically can be with reference to example shown in Figure 6.
2) four row's business indicator driving cabins
Four row's business indicator driving cabins are divided into four ranks and three dimensions, and that four ranks refer to is of company level, regional-level, department level, project level, and three dimensions refer to time cycle dimension, organizational structure's dimension and single index dimension.Three dimensions are used respectively three kinds of showing interfaces, the displaying interface phase of same dimension different stage like but data area is different.
2.1) organizational structure's dimension
● of company level
Driving cabin schematic diagram of company level as shown in Figure 7.
The data mining link is as follows:
Click panel board or histogram and open the next stage driving cabin of single index dimension.
Click the sector region of pie chart and open corresponding next stage institutional framework dimension driving cabin.
● regional-level
Data basedly have project under its command and screen when front panel region, the interface is with of company level identical, and the data that difference is pie chart are divided into groups by intrinsic region subunit.
● department level
Data based current department has project under its command and screens, and the interface is with of company level identical, and difference is that the data of pie chart divide into groups by the subordinate of this department project.
● project level
Show current project data, the interface is with of company level identical, and difference is that the data of pie chart are divided into the quantities list and go out two groups of bills of lading.
2.2) single index dimension
The dimension that single index dimension refers to the project contracting volume, collects, the volume of newly signing a contract, four indexs of contract amount that come into force are showed separately represents with histogrammic form.
Figure below is take project contracting volume index as example:
Fig. 8 is regional-level driving cabin schematic diagram;
Fig. 9 is department level driving cabin schematic diagram;
Figure 10 is project level driving cabin schematic diagram.
2.3) the time cycle dimension
Time cycle dimension driving cabin shows four rows according to the distribution situation in a year, and monthly grouping shows planned value and the actual value of four data.
Data based of company level, regional-level, the department level of driving cabin, project level have project under its command and screen, and the rank difference shows that data are different.Each rank driving cabin interface phase is same, as shown in figure 11.
3) indicator of costs driving cabin
Represent existing these indicators of costs of rate of profit of target liability statement rate of profit, implementation period with represented as histograms.
As shown in figure 12, the histogram ordinate is number percent.Histogrammic red post represents target liability statement rate of profit, and its numerical value immobilizes.Green post represents existing rate of profit of implementation period, changes with the data variation of cost quarterly report.
Based on above content, described intelligent decision system comprises with lower module:
Ground floor DBMS abstraction module is used for processing from the corporate level project data of multisystem extraction various dimensions;
Second layer DBMS abstraction module is used for processing from the regional-level project data of multisystem extraction various dimensions;
The 3rd hierarchical data abstraction module is used for processing from the department level project data of multisystem extraction various dimensions;
The 4th hierarchical data abstraction module is used for processing from the project level project data of multisystem extraction various dimensions;
The first level represents module, and the data of company level after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The second level represents module, and the regional-level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The 3rd level represents module, and the department level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The 4th level represents module, and the project level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
Wherein, each level represents module and comprises following submodule:
The first dimension represents submodule, is used for from the time cycle dimension, and the data after processing are represented form with chart intuitively;
The second dimension represents submodule, is used for from the time cycle dimension, and the data after processing are represented form with chart intuitively;
Third dimension degree represents submodule, is used for from single index dimension, and the data after processing are represented form with chart intuitively.
In addition, described intelligent decision support system has solved the large difficult problem of projects data statistics amount in the project management process, and can give warning in advance for main project, and controls project cost at any time.
And described intelligent decision support system can also represent business decision driving cabin more attractive in appearance whenever and wherever possible on iPhone, iPad mobile platform.System specially for iPhone, iPad platform development the mobile edition driving cabin, the various business decision data-pushings that generate on computing machine to mobile device, during the mobile device interconnection network, are presented at the mobile device screen with multiple graph mode, as shown in figure 13.The support software of graphical element, better effects if.
Accordingly, each level represents module and also comprises following submodule:
Computer platform represents submodule, and the data that are used for after processing on all kinds of computer platforms represent form with chart intuitively;
Mobile platform represents submodule, and the various business decision data-pushings that are used for generating on computing machine are to mobile device, represents form with chart intuitively and is presented on mobile device.
Mobile device can use the mode interconnection networks such as 2G, 3G, WiFi, has greatly improved the convenient easy-to-use performance of decision support system (DSS), provides decision support for administration and supervision authorities timely.
In conjunction with modern means of communication, utilize mobile terminal, no matter realize company manager in where by mobile office, still can control anywhere or anytime the management state of enterprise.Avoid due to the region reason, and can not in time control enterprise management condition, in time decision-making; Enterprise's key index can in time be reminded and feedback, Real Time Monitoring by mobile device.
And described intelligent decision support system also comprises compatible modules, and the support of this compatible modules conducts interviews to the database under isomerous environment (heterogeneous database system), supports common multitype database.For example, but the database of the PMIS of Connected Corp. of system, finance (NC of UFSOFT) systems, PMIS is the oracle database under the WINDOWS environment, financial system is the oracle database under linux system.
Wherein, described heterogeneous database system is the set of a plurality of Database Systems of being correlated with, and can realize sharing and transparent access of data, and each Database Systems itself just existed before adding heterogeneous database system, had the DMBS of oneself.Each ingredient of heterogeneous database has the autonomy of self, and when realizing data sharing, each Database Systems is still possessed oneself application characteristic, integrity control and security and controlled.
The target of heterogeneous database system is realize the merging of data message resource, hardware device resources and human resources between disparate databases and share.Wherein crucial is exactly a bit take the local data bank pattern as the basis, sets up data pattern or the overall external view of the overall situation.This global schema is particularly important for setting up senior decision support system (DSS).
Based on above content, the below further illustrates the various functions that described intelligent decision support system is supported, and the corresponding function module that comprises.
1, intelligence inquire
The intelligence inquire module of described intelligent decision support system can be according to actual business requirement, the definition query object also retrieves the data that need from database, the cleaning and filtering conversions of while complete paired data in query script etc. obtain the data that the user finally needs.
The design aim of intelligence inquire is the data query that allows the business personnel that is ignorant of the IT technology can be freely need in the middle of finishing service easily, and whole inquiring structuring process need not programming.
Intelligence inquire has following features:
1) but based on data source, information field, SQL statement, the inquiry that has generated, file, Excel and database storage various ways inquire about, need not programming;
2) inquiry can be simultaneously across a plurality of data sources such as Oracle, SQL, DB2, Informix, the RDBMS such as Progress, Sybase; (in general this function is fit to have with IT or information portion the librarian use of database using right, and business personnel normally essential information territory (or service view) does inquiry)
3) support script edit in inquiry;
4) visual edit querying condition, the condition editing process uses natural language;
5) the data query result comprise search, filtrator, input parameter, lifting sequence etc.;
6) the data layout setting of Query Result;
7) but Query Result interface its interface of flexible design art designing, the user is DIY fully;
8) the query argument function is set, different parameters refreshes different pieces of information, and simultaneously parameter interface can self-definition design, can satisfy the design at all query arguments interface;
9) have powerful alarm function, can send early warning e-mail, windowsmessage based on predetermined condition, start the alarm functions such as other system, and the running log of warning, facilitate the user to check;
10) be provided with stand alone printer, Query Result is derived when printing and can not be out of shape;
11) Query Result may be output as the common formats such as Microsoft Excel, Pdf, Html and Txt;
12) can call other ActiveX control in the Web interface, for example WinFax, WindowsMedia Player etc., strengthened displaying and systemic-function greatly, far is more than the envelop of function of general inquiry.
The mode that builds intelligence inquire has:
1) set up inquiry based on the intelligence inquire constructor;
2) set up inquiry based on query language SQL;
3) import data from text and set up inquiry;
4) import data from the Excel file and set up inquiry;
5) the based on database storing process is set up inquiry;
6) inquire about based on inquiring structuring.
2, dynamic statement
The dynamic statement module of described intelligent decision support system is the Query Result that intelligence inquire (IQuery) is generated, and is reflected as various forms of forms, as standard scale, master-salve table etc., and can edit and be converted into various figures to report entry.Dynamic statement adopts typesetting item principle to make form, greatly improves the efficient of report making, compares with crystal report, and dynamic statement is more flexible, and is more efficient, more can be fit to the user and use.
Dynamic statement mainly is suitable for making the rambling form of typesetting, particularly for industries such as ERP, HR, POS, different enterprises are all by every means different to the requirement of form, and according to the design concept of dynamic statement, can help the user to make the form of various different styles.
The characteristics of dynamic statement are as follows:
1) statement form is formulated flexible: adopt global unique form " typesetting item " design concept, by the typesetting item is carried out different setup of attributes, just can easily make the form of various different-formats;
2) Report Form Design flexible interface, can self-definition design the size of interface paper;
3) can insert the chart of various patterns in form;
4) allow the user with compile script, seamlessly obtain additional function, to satisfy growing demand;
5) use the mechanism of pulling and drag and drop menu to make form by all interfaces;
6) full object reuse administrative skill can be upgraded by single-point, and time and the cost of safeguarding form are saved greatly.
3, fixing form
Fixedly Reports module is the powerful independent report making assembly that described intelligent decision support system provides, and fixedly Report Form Design location is the embedded instrument of EXCEL, therefore its look ﹠ feel, operating process are all accomplished the perfect adaptation with EXCEL.
Fixedly the design of form has been received the requirement source of domestic and international mass data statistical report form and has been made flow process, and the user only needs the Data Source of clear and definite form, can complete quickly and easily by fixing form the making of whole statement form, report data.
What is meant by " fixing ", namely the row, column title of form is fixed, and in form, each cell data is by independently formula definition generation.Fixedly form is being different from dynamic statement aspect statement form, data peek and form computing." gauge outfit design " can help the user to complete loaded down with trivial details statement form definition, and " form gathers " can make the user complete time-consuming form collection work, and " newly-built formula " can help the user to complete complicated data peek process.
Fixedly form is suitable for making that ranks are fixed and computing is complicated, and each cell comprises the complex statistics form of a SQL peek, is mainly used at present the industries such as social security, public security, medical insurance, real estate, the tax.Also be suitable for making the EXCEL form, that is to say can be indiscriminately ad. as one wishes at EXCEL inediting form the user of EXCEL inediting report data for those hope.Because fixedly form itself is exactly an EXCEL file, fixedly form has mainly used the convenient and swift property of peek to add the convenience that the form of Excel is drawn, and both combine and make the client can indiscriminately ad. as one wishes make report data.
Fixedly the characteristics of form are as follows:
1) with the perfect adaptation of Excel: both kept all functions of Excel, and added again the distinctive peek function of the international BI of middle work simultaneously;
2) its look ﹠ feel and operating process are all seamless integrated with Excel, can with formula, inquiry, parameter, text, etc. the direct drag and drop of object to Excel; Also fixing form directly can be saved as the Excel file;
3) gauge outfit design easily: row, column gauge outfit (can design N level, not establish the upper limit) and oblique line gauge outfit and the header that turns round all can generate automatically by shirtsleeve operation;
4) because fixedly form itself to enter be an Excel file, be fully undistorted so form exports to EXCEL;
5) because embed Excel, fixedly form is slightly slow so open, and needs to wait for several seconds and just can open a form;
6) due to the restriction of Excel itself, can only show at most 60,000 multirow records, so when data all needed to show over 60,000 multirows, suggestion adopted dynamic statement to make.
4, easily analyze (OLAP)
Easily analyze (OLAP-Online Analysis Processing, on-line analytical processing) be a kind of technology of obtaining, analyzing data, refer to according to service needed, extract the related service data from database, and the data of extracting are carried out the analysis of different angles, different depth, finally form the multidimensional bordereaux, and according to the objective law of data in form, trend in the discovery data provides the decision-making foundation of science with abnormal to the decision maker.This function realizes by two modules---cube and multidimensional form.
Cube is a kind of analytical model of preserving business data with hierarchical structure.By creating cube, easily analytic system can gather the business datum of different levels fast, and the mode of data with the multidimensional form shown; Can generate a plurality of light Study documents based on a cube.The user can check fast, neatly data, analyze data like this.Easily analytic system creates self-defined cubical function except providing, and also provides and has browsed the cubical function of Microsoft.
The cube functional characteristics is as follows:
1) based on data source, information field, inquiry file build peacekeeping and measure;
2) build the level dimension;
3) level of self-defined its expansion of time dimension energy such as year, season, the moon, day, week, year week etc.;
4) increase filtercondition in cube;
5) digital display format is measured in setting.
The multidimensional form mainly is fit to make the statement form no requirement (NR), and data analysis and excavation there is the form of suitable requirement, that is to say if the user thinks to go from different perspectives at any time to understand the index of correlation value, and these desired values are analyzed with diverse ways, that just may use the multidimensional form.The multidimensional form is suitable for company leader's layer and browses and analyze data.
5, data typing (ISP)
The ISP full name is intelligent form platform (Intelligent Spreadsheet Platfom), integrates all functions and the data input function of business intelligence, with the complete cover data typing of single platform, verification, inquiry, analysis, statistics.ISP has expanded data typing, verifying function that business intelligence does not have, has extended the original definition content of business intelligence.
ISP is based on researching and developing on the business intelligence platform base, is mainly many piles of forms facing every day for enterprises and institutions and a large amount of data and handling implement the most easily is provided, and has more solution for the bottleneck that runs in Excel especially.
The functional characteristics of ISP is as follows:
1) the most efficient: as to break through Excel and do not allow many people to operate simultaneously the restriction of a form, can support 20 people with same form of period operation;
2) the most perfect: as to have business intelligence all functions and data input function;
3) easily training: due to the Report Form Design function that has encapsulated powerful secondary development function and multiple advanced person, so non-IT technician equally can easy manipulation;
4) easy care: due to without any need for IT professional knowledge, therefore general business personnel just can safeguard voluntarily;
5) cost is low: the cycle is short, maintenance is short, efficient is high, valency is not high ...;
6) support multilist to upgrade (same inquiry relates to a plurality of tables, and each table all need arrange identity column).
6, decision information system (EIS)
EIS (decision information system) be a kind of up-to-date, by the system of button with regard to executable Query Database.Because inquiry and various report file that can will be associated by EIS be placed on same interface and browse and analyze, and are also keeping association between each form, so EIS makes visit to end user information convenient.
The functional characteristics of EIS is as follows:
1) diversified data results is illustrated in a platform;
2) powerful analytic function transmits critical data for the decision maker;
3) the EIS displaying that need not programme and complete complexity;
4) multiple chart display form is supported cake chart, scattergram, histogram, 3D figure etc.;
5) support whole EIS is showed that the interface exports as picture;
6) Brio.Enterprise 6.0 EIS of enterprise are based on the foundation of JavaScript development language, and JavaScript does not have the Debug function; The application's EIS is based on the development language foundation of the 4th generation, and the Debug function is arranged;
7) Brio.Enterprise 6.0 EIS of enterprise will set up form with 200 development languages, and the application's EIS only just completes the interactive form of Web with 20.
7, data pumping out system (ETL)
ETL is the process of an extraction that realizes data, conversion, loading.
The application's ETL is exactly by query-defined data warehouse object table, utilize the power of inquiry to make data and extract (Extraction) (from different data sources peeks, across the data source peek), generate calculated field (self-defined computational item), translation type and data cleansing (Transformation), and pump by data and be loaded into data warehouse (Load).Simple data cleansing (eliminating invalid data) can define in querying condition, and complicated can do by the built-in VB script of inquiry.
8, function and operational character
In this application, function can be used as the object of a Reusability, be used in information field, inquiry, dynamic statement, fixedly form, etc. in module (can certainly manual input function).The application provides many kinds of function, and the common mathematical function (comprising MS ACCESS, MS Excel, MS SQL Server and Oracle etc.) of foreground function, inquiry column operations function and various databases is arranged.
Can be used for the database that operational character in condition and expression formula depends on the user.Operational character is the local SQL operational symbol that is translated into natural language.In the building process of condition, expression formula and function, the user is except can be manual the input operation symbol, can also use the operational character that provides of system.
9, document template
Object in the application's document template can be reused by the user, especially for the object that secondary development is arranged, if place it in object template, just do not need like this to repeat to write the secondary development code.Simultaneously, this function can extend to will be commonly used form or inquiry etc. processes as template, each so only need slightly to make an amendment in template when doing form get final product.
In sum, described intelligent decision support system is complete commercial intelligence resolution, so it has the normal process of BO, realizes finally that by four levels shown in Figure 14 the user is in the demand aspect the data processing.Wherein, Figure 14 is the general structure schematic diagram of the described intelligent decision support system of the embodiment of the present application.
The intelligent decision support system of above a kind of project management that the application is provided, be described in detail, used specific case herein the application's principle and embodiment are set forth, the explanation of above embodiment just is used for helping to understand the application's method and core concept thereof; Simultaneously, for one of ordinary skill in the art, the thought according to the application all will change in specific embodiments and applications, and in sum, this description should not be construed as the restriction to the application.
Claims (10)
1. the intelligent decision support system of a project management, is characterized in that, comprising:
Ground floor DBMS abstraction module is used for processing from the corporate level project data of multisystem extraction various dimensions;
Second layer DBMS abstraction module is used for processing from the regional-level project data of multisystem extraction various dimensions;
The 3rd hierarchical data abstraction module is used for processing from the department level project data of multisystem extraction various dimensions;
The 4th hierarchical data abstraction module is used for processing from the project level project data of multisystem extraction various dimensions;
The first level represents module, and the data of company level after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The second level represents module, and the regional-level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The 3rd level represents module, and the department level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
The 4th level represents module, and the project level data after being used for processing represent form with chart intuitively, for enterprise management level and project management department provide Analysis on Project Management and decision-making;
Wherein, each level represents module and comprises following submodule:
The first dimension represents submodule, is used for from the time cycle dimension, and the data after processing are represented form with chart intuitively;
The second dimension represents submodule, is used for from the time cycle dimension, and the data after processing are represented form with chart intuitively;
Third dimension degree represents submodule, is used for from single index dimension, and the data after processing are represented form with chart intuitively.
2. system according to claim 1, is characterized in that, each level represents module and also comprises following submodule:
Computer platform represents submodule, and the data that are used for after processing on all kinds of computer platforms represent form with chart intuitively;
Mobile platform represents submodule, and the various business decision data-pushings that are used for generating on computing machine are to mobile device, represents form with chart intuitively and is presented on mobile device.
3. system according to claim 1, is characterized in that, also comprises:
Compatible modules is used for carrying out compatibility with various heterogeneous systems, and described heterogeneous system comprises project management system and financial system.
4. system according to claim 1, is characterized in that, also comprises:
The intelligence inquire module is used for according to actual business requirement, and the definition query object also retrieves the data that need from database, and the cleaning and filtering conversion of while complete paired data in query script etc. obtain the data that the user finally needs.
5. system according to claim 4, is characterized in that, also comprises:
The dynamic statement module is used for the Query Result with described intelligence inquire module generation, is generated as various forms of forms, and various figures are edited and be converted into to report entry.
6. system according to claim 1, is characterized in that, also comprises:
Fixedly Reports module, be used for the independent form of making, and fixedly the row, column title of form is fixed, and in form, each cell data is by independently formula definition generation.
7. system according to claim 1, is characterized in that, also comprises:
The on-line analytical processing module, be used for according to service needed, extract the related service data from database, and the data of extracting are carried out the analysis of different angles, different depth, the final multidimensional bordereaux that forms, and according to the objective law of data in form, find trend in data and abnormal, the decision-making foundation of science is provided to the decision maker.
8. system according to claim 7 is characterized in that:
Described on-line analytical processing module comprises cube and multidimensional form, and wherein said cube is preserved business data with hierarchical structure, can generate a plurality of light Study documents based on a cube;
Described on-line analytical processing module gathers fast the business datum of different levels, and the mode of data with the multidimensional form is shown by creating cube.
9. system according to claim 1, is characterized in that, also comprises:
Data typing module is for all functions and the data input function that integrate business intelligence, with the complete cover data typing of single platform, verification, inquiry, analysis and statistics.
10. system according to claim 1, is characterized in that, also comprises:
The data pumping out system is used for by query-defined data warehouse object table, utilizes query function to make data and extracts, generates calculated field, translation type and data cleansing, and pump by data and be loaded into data warehouse.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104307956A CN103177308A (en) | 2011-12-20 | 2011-12-20 | Intelligent decision-making support system for project management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011104307956A CN103177308A (en) | 2011-12-20 | 2011-12-20 | Intelligent decision-making support system for project management |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103177308A true CN103177308A (en) | 2013-06-26 |
Family
ID=48637147
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011104307956A Pending CN103177308A (en) | 2011-12-20 | 2011-12-20 | Intelligent decision-making support system for project management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103177308A (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104299105A (en) * | 2014-11-02 | 2015-01-21 | 中国科学院软件研究所 | Credit data management system supporting complex enterprise environment and credit data management method |
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| CN104715348A (en) * | 2015-03-18 | 2015-06-17 | 北京殷塞信息技术有限公司 | Intelligent analysis method and system for general business |
| CN104766161A (en) * | 2015-03-20 | 2015-07-08 | 昆明能讯科技有限责任公司 | Large-size screen decision analysis cockpit |
| CN105117819A (en) * | 2015-07-28 | 2015-12-02 | 国网山东省电力公司济南供电公司 | Power grid enterprise management and training system |
| CN105243167A (en) * | 2015-11-10 | 2016-01-13 | 中国建设银行股份有限公司 | Data processing method and device |
| CN105677628A (en) * | 2015-12-30 | 2016-06-15 | 深圳联友科技有限公司 | Method and device for generating dynamic report form |
| CN106372190A (en) * | 2016-08-31 | 2017-02-01 | 华北电力大学（保定） | Method and device for querying OLAP (on-line analytical processing) in real time |
| CN106548322A (en) * | 2016-09-29 | 2017-03-29 | 中工国际工程股份有限公司 | Project examination system |
| CN108416533A (en) * | 2018-03-23 | 2018-08-17 | 中国十七冶集团有限公司 | A kind of project management data management system and its method based on business intelligence |
| CN110414802A (en) * | 2019-07-08 | 2019-11-05 | 南京华盾电力信息安全测评有限公司 | Conglomerate Analysis of Policy Making flight deck system |
| WO2020019495A1 (en) * | 2018-07-27 | 2020-01-30 | 平安科技（深圳）有限公司 | Information display method and device, computer device, and readable storage medium |
| CN111400414A (en) * | 2020-03-12 | 2020-07-10 | 杭州城市大数据运营有限公司 | Decision-making method and system based on standardized enterprise data and electronic equipment |
| CN111881663A (en) * | 2020-08-06 | 2020-11-03 | 牟吉伶 | Table format bid information pushing method |
| CN113126849A (en) * | 2021-04-07 | 2021-07-16 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
| CN113627865A (en) * | 2020-05-07 | 2021-11-09 | 景德镇陶瓷大学 | Enterprise management analysis system for business administration |
| CN116542638A (en) * | 2023-07-07 | 2023-08-04 | 中国核工业二三建设有限公司 | Decision support system and method for nuclear power installation |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006260112A (en) * | 2005-03-16 | 2006-09-28 | Ricoh Co Ltd | Project management system, project management method, program and storage medium |
| CN102141997A (en) * | 2010-02-02 | 2011-08-03 | 三星电子（中国）研发中心 | Intelligent decision support system and intelligent decision method thereof |
-
2011
- 2011-12-20 CN CN2011104307956A patent/CN103177308A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006260112A (en) * | 2005-03-16 | 2006-09-28 | Ricoh Co Ltd | Project management system, project management method, program and storage medium |
| CN102141997A (en) * | 2010-02-02 | 2011-08-03 | 三星电子（中国）研发中心 | Intelligent decision support system and intelligent decision method thereof |
Non-Patent Citations (2)
| Title |
|---|
| 汪萌: "基于数据挖掘的水电项目决策支持系统的研究", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
| 蔡康 等: "《IP宽带业务与运营》", 29 February 2004, 人民邮电出版社 * |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104299105A (en) * | 2014-11-02 | 2015-01-21 | 中国科学院软件研究所 | Credit data management system supporting complex enterprise environment and credit data management method |
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| CN104715348A (en) * | 2015-03-18 | 2015-06-17 | 北京殷塞信息技术有限公司 | Intelligent analysis method and system for general business |
| CN104715348B (en) * | 2015-03-18 | 2017-11-28 | 北京殷塞信息技术有限公司 | Complex business intelligent analysis method and system |
| CN104766161A (en) * | 2015-03-20 | 2015-07-08 | 昆明能讯科技有限责任公司 | Large-size screen decision analysis cockpit |
| CN105117819A (en) * | 2015-07-28 | 2015-12-02 | 国网山东省电力公司济南供电公司 | Power grid enterprise management and training system |
| CN105243167B (en) * | 2015-11-10 | 2019-01-29 | 中国建设银行股份有限公司 | A kind of data processing method and device |
| CN105243167A (en) * | 2015-11-10 | 2016-01-13 | 中国建设银行股份有限公司 | Data processing method and device |
| CN105677628A (en) * | 2015-12-30 | 2016-06-15 | 深圳联友科技有限公司 | Method and device for generating dynamic report form |
| CN106372190A (en) * | 2016-08-31 | 2017-02-01 | 华北电力大学（保定） | Method and device for querying OLAP (on-line analytical processing) in real time |
| CN106548322A (en) * | 2016-09-29 | 2017-03-29 | 中工国际工程股份有限公司 | Project examination system |
| CN108416533A (en) * | 2018-03-23 | 2018-08-17 | 中国十七冶集团有限公司 | A kind of project management data management system and its method based on business intelligence |
| WO2020019495A1 (en) * | 2018-07-27 | 2020-01-30 | 平安科技（深圳）有限公司 | Information display method and device, computer device, and readable storage medium |
| CN110414802A (en) * | 2019-07-08 | 2019-11-05 | 南京华盾电力信息安全测评有限公司 | Conglomerate Analysis of Policy Making flight deck system |
| CN111400414A (en) * | 2020-03-12 | 2020-07-10 | 杭州城市大数据运营有限公司 | Decision-making method and system based on standardized enterprise data and electronic equipment |
| CN111400414B (en) * | 2020-03-12 | 2023-12-22 | 杭州城市大数据运营有限公司 | Decision method and system based on standardized enterprise data and electronic equipment |
| CN113627865A (en) * | 2020-05-07 | 2021-11-09 | 景德镇陶瓷大学 | Enterprise management analysis system for business administration |
| CN111881663A (en) * | 2020-08-06 | 2020-11-03 | 牟吉伶 | Table format bid information pushing method |
| CN113126849A (en) * | 2021-04-07 | 2021-07-16 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
| CN113126849B (en) * | 2021-04-07 | 2022-06-07 | 帆软软件有限公司 | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
| CN116542638A (en) * | 2023-07-07 | 2023-08-04 | 中国核工业二三建设有限公司 | Decision support system and method for nuclear power installation |
| CN116542638B (en) * | 2023-07-07 | 2023-10-20 | 中国核工业二三建设有限公司 | Decision support system and method for nuclear power installation |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103177308A (en) | Intelligent decision-making support system for project management | |
| JP6857689B2 (en) | Data retrieval devices, programs, and recording media | |
| CN101084494B (en) | Method and device for managing workflow in computer environment | |
| CN105447122B (en) | A kind of implementation method that archives economy can be independently created based on multilist association | |
| CN100580662C (en) | Heterogeneous report form integration and centralized management device and system | |
| CN102841938B (en) | Method and system for generating parameterized report | |
| US7966356B2 (en) | Apparatus and methods for displaying and determining dependency relationships among subsystems in a computer software system | |
| CN106296378A (en) | Intelligence finance cloud platform system based on XBRL, construction method and service implementation method | |
| EP2058733A2 (en) | Multi-tier interface for management of operational structured data | |
| MXPA05012291A (en) | Complex data access. | |
| US20060020608A1 (en) | Cube update tool | |
| CN110414802A (en) | Conglomerate Analysis of Policy Making flight deck system | |
| CN103116827A (en) | Rural power grid engineering control system | |
| Sheta et al. | The technology of using a data warehouse to support decision-making in health care | |
| CN105706084A (en) | Metadata automated system | |
| CN104199648B (en) | A kind of General Mobile information system adaptation method and device | |
| CN202433952U (en) | General network reporting system | |
| CN106228439A (en) | A kind of financial data management method and system | |
| Fouché et al. | Foundations of SQL server 2008 R2 business intelligence | |
| Dunlop | Beginning Big Data with Power BI and Excel 2013: Big Data Processing and Analysis Using PowerBI in Excel 2013 | |
| Harinath et al. | Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX | |
| Shen et al. | Research on application of computer technology in the optimization of department information system | |
| Janus et al. | Pro SQL Server 2008 Analysis Services | |
| Ruvolo | Business Intelligence: concepts and application-Implementation of an Intelligent Planning through software Board | |
| Malinowski | GeoBI Architecture Based on Free Software: Experience and |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130626 |
|
| RJ01 | Rejection of invention patent application after publication |