The topic of today's blog is: parameter linkage solution.
Environment: Data Warehouse + OLAP (cube) + Reporting Service. Effect: multiple parameters (1, 2 ,......) Achieve interaction.
First, let's talk about the principle. A data warehouse consists of fact tables and dimensions. I understand that fact tables are actually a table composed of multiple dimensions related to a topic and the values of these dim
future of OLAP can be used in the field of what:1. Market and Sales Analysis (Marketing2. E-Commerce analysis (Clickstream analyst)3. Marketing based on historical data (database marketing)4. Budget (budgeting)5. Financial reporting and integration (Financial reporting and consolidation)6. Management report (Management repor
and create databases for the user's purpose.
What is an OLAP report tool?
In the report market, there is a strange phenomenon: the technical staff of the IT department is the department staff most unfamiliar with the use of report tools in all departments of the enterprise, but the report data comes from the IT department. The IT department often uses the OLAP
for OLAP and dynamic reports written in Java/J2EE. it combines static reports (based on jasperreports), a swing tables for OLAP analysis, and charts (based on jfreechart ). it reads from external data sources as SQL, Excel, XML, and others, and produces export outputs as PDF, XML, and application specific files for later off-line visualization of reports.
8. freereportbuilder
Freereportbuilder is a Jav
follow the new layout to recalculate the data.
Supports fast generation of Web page diagrams via HTML 5.
Hierarchical navigation and hierarchical reporting can be generated.
Support timed tasks, can write batch processing, timed to perform some data loading, processing, backup and other operations.
Lower TCO (total cost of ownership).
provides Web Reporting Services.
Get Address: H
Report tool is to solve the problem of data rendering, and the mobile phone is a convenient data rendering carrier, then the report tool should obviously provide mobile app?In fact, reporting tools do not provide the mobile app directly. More strict saying: Not only should not have, moreover cannot have!650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M00/8E/96/wKiom1jGP3_QVdPxAAKvmX6FwSs366.png-wh_5
1. Basic functions of reporting toolsReporting tools typically provide functionality:
Multiple data sources are supported, and data sources can be configured.
Script-based style definitions, typically XML-enabled, can be modified flexibly and typically provide a style editor. Generally support the definition of print-based style, support the concept of report head, tail page, group and so on.
with any database and only requires a JDBC driver.Program.
6. jmagallanesJmagallanes is an open-source OLAP and dynamic report application developed using Java/J2EE. Jmagallanes combines static reports (based on jasperreports), swing charts tables (for OLAP analysis), and charts (based on jfreechart ). It can read data from multiple data sources (such as SQL, Excel, XML, and others) and generate multiple
relevant information, evaluates the effectiveness of research and development, service innovation, staff ability and so on to ensure the smooth implementation of the enterprise strategy. Reporting toolsSample tools: FineReportDemand ScenariosWith traditional systems, we can easily collect data similar to the following:650) this.width=650; "Src=" http://dl2.iteye.com/upload/attachment/0116/0390/ 24f3fdfa-2e
In the big data era, data is not only massive, but also in various forms and diversified. For Report tools, data must be obtained, computed, and displayed from a variety of data sources. However, most reporting tools are not well adapted to diverse data sources.
Common Report data sources include:
1. Various relational databases: Oracle, DB2, sqlserver, Informix,
capital. My opinion is: it is more appropriate to develop Chinese-style reports using domestic report tools. If you have any funds, you should focus on the product functions. V. Domestic report tools
In an environment where foreign reporting tools are basically available for free, domestic
.iteye.com/upload/attachment/0115/7040/ 5ac35d11-5749-3335-8919-4a728d1f1f23.png "style=" border:0px; "/>3.2 Modify shortcut key settingsDesigner built-in JS Auto-complete shortcut keys for ctrl+space, but the computer is different, set the shortcut keys are different, the default shortcut keys may have been occupied, at this time, you need to modify the shortcut, double-click the Auto-complete shortcut key:ctrl+space, Use the keyboard to work through the required shortcuts, for example, to cha
following methods:3.1 Start Auto-complete functionAuto-completion is not performed by default in the designer, click File > Options > Editor settings, tick the check box before default to perform this action, such as:3.2 Modify shortcut key settingsThe designer built-in JS Auto-complete shortcut keys for Ctrl+space, but the computer is different, set the shortcut keys are different, the default shortcut keys may have been occupied, at this time, you need to modify the shortcut, double-click the
, the use of the following methods:3.1 Start auto-complete functionAuto-completion is not performed by default in the designer, click File > Options > Editor settings, tick the check box before default to perform this action, such as:3.2 Modifying shortcut key settingsThe designer built-in JS Auto-complete shortcut keys for Ctrl+space, but the computer is different, set the shortcut keys are different, the default shortcut keys may have been occupied, at this time, you need to modify the shortcu
Article Title: Introduction to Solaris basic audit and reporting tools. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
BART is a file tracking tool at the file system level. The BART tool enables you to quickly, easily, and reliably obtain information about software com
supportedNs_export_excelformula= error code \:1110 Export Exel does not support this formulaNs_export_excelhtml= Error code \:1111 exporting Excel does not support partial tags in htmlNs_export_wordpagesize= error code \:1114 Export Word does not support different page settings under multiple sheetNs_mail_config= error code \:1204 message configuration parameter is incorrectns_print_flashpapersetting= error code \:1118 Flash printing does not support passing page settings to the printerNs_print
supportedNs_export_excelformula= error code \:1110 Export Exel does not support this formulaNs_export_excelhtml= Error code \:1111 exporting Excel does not support partial tags in htmlNs_export_wordpagesize= error code \:1114 Export Word does not support different page settings under multiple sheetNs_mail_config= error code \:1204 message configuration parameter is incorrectns_print_flashpapersetting= error code \:1118 Flash printing does not support passing page settings to the printerNs_print
in the report dataset first, and then from the server dataset, and return an array of tabledata column names.Example:Tabledatafields ("Country") equals [name, capital, continent, area, populationTabledatesTabledatas (): Returns the report dataset and server data set name. ]Example:The server datasets are: DS1,DS2,DS3; The report dataset has DSR1,DSR2.Tabledatas () equals [DSR1,DSR2,DS1,DS2,DS3].The Tabledatas (0) returns the server dataset name; Tabledatas (1) Returns the name of the report dat
write object under CURLGP.2.4.1 Reference WriteYou can use ContentPane.curLGP.write to get the object in the JS script of the CPT template.If the report is embedded in an IFRAME in the Web page, get the Write object outside the IFRAME as follows:var contentpane = document.getElementById (' Reportframe '). ContentWindow.contentPane.curLGP.write;2.5 formForm Preview or parameter interface, there is a Form object.2.5.1 referencing a formIn the CPT template's JS script, you can use This.options.for
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.