Shulou(Shulou.com)06/01 Report--

How to move the drag-and-drop analysis function of Excel to WEB, many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can get something.

It must be no stranger to mention Excel, especially the data toushi table in it. For situations that require aggregation analysis, it can be completed by ticking and selecting according to the original data, which is very cool to use.

So, wouldn't it be perfect if the features that are so easy to operate can be moved to WEB and embedded in my application? So easy! Comrade Lei Feng will teach you to do this right away.

The protagonist enters the stage-- moisturize the multi-dimensional analysis of the report!

Let's first use Excel files as data sources to share with you the application cases of multidimensional analysis. You are welcome to watch enthusiastically and gracefully complain:

The Excel file is as follows:

This format is very common, the first line is the title, followed by rows of data.

Whether the Excel data file is on the server or locally, drying the multidimensional analysis interface can help you get it done easily! Don't say much, just look at the steps:

Open the multi-dimensional analysis interface of the dry report:

Click the data File button in the menu, pop up the Open data File window, and select the data file.

For local files, you can click the [Open Local] button to find and use the data files saved anywhere locally.

For server files, you can click the "Open Server File" button to open all data files located in the directory specified by the server. This directory path needs to be specified by adding JS API to "[demo Application Root] / raqsoft/guide/jsp/olap.jsp", as shown in the following figure.

Once the data file is selected, the dataset is created, and the most important step in multidimensional analysis is ok.

Next is the time for business people to gallop freely, drag headers and indicators in complex conditions at will, and check whatever they want and calculate what they want. What can be done in the data toushi table, our WEB application can also do it. Haha, is it better to jump from a standalone application to the Web environment?

In addition to the above-mentioned method of importing data files through the page menu, there is a simpler use, as long as the data files to be analyzed are passed in URL. For example, put data.xls in the "[Web application root directory]\ WEB-INF\ files\ fileData\" directory, and add the file name directly after visiting the analysis page. Such as: \ raqsoft\ guide\ jsp\ olap.jsp?dataFile= [Web application root]\ WEB-INF\ files\ fileData\ data.xls.

Greed, greed! After learning how to do multi-dimensional analysis of files in a dry WEB application, do you want to know how to integrate it into your own application system?

Very simple, the standard java development three-piece suite, jar package, xml configuration file, and jsp tag description file tld.

The homework to be done in advance includes setting up the basic environment according to the "Quick Integration" section of the dry report V2018 Analysis tutorial before further integrating multi-dimensional analysis.

Multidimensional analysis is a drag-and-drop interface displayed using the tag tag. The olap.jsp,tag tags provided in the product for demonstration are roughly as follows:

The embedded page is even more simple and easy to operate, and it will directly list all the indicators in xls, and the record will be displayed in front of you without concealment.

For ease of use, after adding Tag tags, our analysis page will provide a menu bar by default, but if you feel that the menu bar is a little out of place with your page style, it doesn't matter, the solution has already helped you figure it out!

You can hide our default menu bar and add our menu bar buttons to your own style page.

The method of hiding is so simple that it can be done with one script:

GuideConf.showToolBar = 'no'; / / whether to display the upper toolbar. Default is yes

Haha, did you find that the menu bar has disappeared?

In order to customize the buttons for these functions, we specially provide the JS method directly to the user. Your buttons can directly call the following methods:

Save: analyseApi.saveOlap (); Open: analyseApi.openOlap (); horizontal tiling: analyseApi.resetReportWindow (1); Vertical tiling: analyseApi.resetReportWindow (2); overlapping display: analyseApi.resetReportWindow (3); dataset: analyseApi.manageDataSet ()

How to use it:

open

A little bit deeper, one of the parameters in the above tag is dfxFile, and dfx is the program script file for the aggregator. This shows that the calculation of file multidimensional analysis depends on the dry aggregator. After passing the data file as a parameter to the system's own readFiles.dfx,dfx calculation through url, the result set will be displayed on the analysis page as a dataset of multidimensional analysis, and then users can drag and query the dataset fields at will. Of course, worry, this part of the aggregator function is free!

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.