Editing Report Queries

InetSoft's reporting software makes data binding seamless with sophisticated tools for editing report queries. View the example below to learn more about the Style Intelligence solution.

This section illustrates how to modify an existing data binding. The ‘Data Query’ interface can be used to edit the data binding of an element. Right-click on an element and choose ‘Data Query’.

  1. Open the ‘Ad Hoc’ report (choose ‘MA’ and submit). Right-click on the ‘Count of Orders by State’ element, and select ‘Data Query’.
  2. Move the ‘Order.Num’ field from ‘Summary Columns’ to ‘Detail Columns’ by dragging it.
  3. Click ‘OK’. The modified report now shows the list of orders within each state.
#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

About InetSoft's Data Block Technology

"The open standards aspect is very important to us since it allows our customers to integrate our technology more easily and leverage assets they already have, in terms of hardware and software and IT skills. So based on this BI platform, our software delivers a host of front-end BI tools including visualization tools, enterprise reporting, monitoring dashboards, and analysis. Those functions were based on a very powerful patent-pending technology we call Data Block.

This Data Block technology is really made up of a back-end data mashup engine and a caching middle layer. There is a front-end we call the worksheet, which is a Web-based, spreadsheet-like user interface that a power user can easily use to combine and transform data blocks. The data blocks are typically started at the atomic data block level. That is typically created by an IT or a BI specialist. They choose these data blocks and performance tune those data blocks.

Then the power users can use those building blocks to build more complex, but more useful structures for answering the questions they have on hand. And all the data blocks you build, in turn become building blocks themselves. You can build on this architecture, building very sophisticated structures which you can use to answer a wide range of unanticipatible questions. " - Luke Liang, CEO, InetSoft

More Articles About Reporting

Better Than OLAP Cube Reporting - OLAP cubes are a confusing subject, to say the least, and while your IT department may be familiar with the concept, most of your other employees probably aren't. So then why deal with them if you don't have to? OLAP is an acronym for online analytical reporting. OLAP cubes are an older data warehousing technology for databases. They are optimized for summarizing and aggregating information...

Connecting the BI App to a DB2 OLAP Server - In order to use an Essbase OLAP data source, it is necessary to create a DB2 JDBC data source. The ess_japi.jar file from the Essbase Enterprise Server installation must be included in the system classpath...

Development of a New Dashboard for C-level Executives - Iterating the development of a new dashboard for C-level executives involves a structured and iterative approach to ensure that the dashboard meets their specific needs and provides valuable insights. Here's a step-by-step guide on how to iterate the development of a dashboard for C-level executives: Define Objectives and Requirements: Start by clearly defining the objectives of the dashboard. What key performance indicators (KPIs) and metrics are critical for C-level executives to monitor? Gather requirements by consulting with C-level stakeholders to understand their information needs, strategic goals, and decision-making processes...

Key Metrics for IT Managers - IT managers rely on a variety of key metrics to assess the performance, efficiency, and effectiveness of their IT operations. These metrics provide valuable insights into how well IT resources are utilized, the quality of services delivered, and the overall health of the IT infrastructure. Here are some key metrics commonly used by IT managers: Uptime and Availability: Metric: Percentage of time systems are operational. Importance: High availability is critical for business continuity. Downtime can lead to lost productivity and revenue...

On the Fly Data Modeling - The modeling can be done via a graphical user interface, perhaps with on the fly modeling. Whereas with a disk-based solution, there tends to be more data summarization required to make the environment work properly. Another feature of in-memory solutions is associative indexing. In some cases, it is defined at the user interface level, meaning I can assign a relationship between tables with a drag and drop tool, or in other cases it is defined automatically through some intelligent techniques built into the query engine. The data source environment can include relational or non-relational data sources, including flat files, spreadsheets, or almost any type of data source. This is another common feature of an in-memory BI solution...

What Are the Most Intuitive Dashboards? - InetSoft is in the business of producing the most intuitive dashboards available for your business needs. Not only are they easy to navigate, but they're also easy to develop. What sets InetSoft's Style Intelligence apart from the competition is the seamless drag-and-drop interface for data mashup, report formatting, and dashboard design. The Drag-and-Drop Model To facilitate usability for individuals of all skill levels, this drag-and-drop interface permeates all design stages of Style Intelligence. Standard business users with little to no IT training can feel comfortable creating intricate and intuitive displays by placing charts, sliders, gauges, selection lists, and a plethora of other elements directly on to the dashboard...

Previous: Reporting Software Elements