Lightweight pseudo OLAP display implemented by wild path

Source: Internet
Author: User

 

Some time ago, I spent some time building something I called Lightweight pseudo OLAP. Of course, the implementation method is not worth mentioning, even some terms used in the UI are used to fool people who do not understand them. Do not take them seriously. The front-end displays extjs + fusioncharts free to see the effect. (because the picture is large and the layout is required, click the image to view the image in the new window ):

 

The initial interface is concise, and an MDI subform is implemented on the web.

 

Expand the "query condition" area on the right, select the corresponding start and end dates, and click the "query" button. The query result chart is displayed in the blank area in the middle of the form.

 

Click "chart data" in the toolbar. chart data is displayed in the form of a two-dimensional table in the lower part of the window.

 

You can drag the handle in the lower right corner of the chart to adjust the chart size.

 

You can analyze data records based on different numeric fields by using menu items under the "aggregation type" menu, such as generating charts using "record count.

 

The menu items of "aggregation type" are automatically generated, and configuration options are stored in the database.

 

After the "aggregation type" is changed to "total fee", the displayed chart data changes.

 

The data record contains some simple data structures. For example, there are only four types of inspection: Organization self-check, Security Supervision Department inspection, leadership inspection, and professional group inspection, only seven major categories are available: mining, mining, machine, transportation, communication, ground test, and others. The system can generate stacked charts based on these simple data structures, including Stacked bar charts, stacked bar charts, and stacked area charts.

 

Stack charts stored in the database can also be configured.

 

In the new MDI child form that appears, the column stacked chart subdivided by "Check Major" is displayed.

 

The stacked chart interface also has corresponding toolbar buttons, such as "chart type ".

 

 

Switching a columnar stacked chart to a stripe stacked chart shows better results.

 

Because different chart types have different meanings, the "chart type" drop-down menu can be used to convert between a column chart, a line chart, and a pie chart.

 

When there are many data items to be displayed in a chart, the chart width may be insufficient. The data items on the X axis of the chart overlap, the drop-down menu item of the "chart width" toolbar button is used to adjust the chart width.

 

Same as above. If there are too many data items, you can use the menu item under the "display number" toolbar button to limit the number of data items displayed.

 

"String truncation" is also used to solve the problem of overlapping data item names in week X. The "Save layout" option can save the width and number of display items of the current chart, the next time you enter this module, the current chart width, number of entries, and other options are used to display the chart.

 

On a specific object (a project in a chart), click the left button to bring up the menu shown in, on this menu, you can view the detailed data of the Chart project, perform drill-down operations, and create a time trend chart.

 

"Drill-down" means that the current data structure is subdivided. The system can segment the data infinitely down based on the custom category type until the user's expected data is found.

 

Drilling of project categories: for example, the number of records for "Cui mining comprehensive mining 4" is 615, and the distribution of "project categories" is: Management defects (363) on-site environment (57), non-injury incidents (37), and hidden dangers (158 ).

 

"Drill-down" can be performed without limit. For example, for the path "Cui mining comprehensive mining 4"-"Managing defects", you can continue drilling down in other categories, however, the drilled category "project category" cannot be reused, so it is grayed out.

 

For any data item, you can generate a time line chart at different time levels, such as day, week, month, quarter, and year.

 

For example, the daily distribution of 615 pieces of data in "Cui mining comprehensive mining 4" is as follows. The time span is too large, and the characters on the X axis overlap, but the time trend is quite clear.

 

Adjust the width of a table.

 

Use the "time span" toolbar to switch the display result of a time level of "Week.

 

At this point, the analysis function of this chart has been introduced. Of course, most of the sections are textures and there are too few text descriptions. In addition to the specific business relationship, some people may not quite understand what I want to do, well, I can also introduce and promote extjs and fusioncharts free. Although I didn't introduce their specific usage methods, I have at least a concept for what I can do. The so-called lightweight pseudo OLAP is purely a waste of words. Although some of them mean this, we can see that this analysis module does not use multiple data sets as the data source, the direct use of business data is doomed to be only a lightweight thing. In addition, "aggregation category", "stacked chart category", and even "drill-down" are all configurable by the user, which ensures the applicability of different services.

 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.