Monitoring Report Queries
InetSoft's Style Intelligence provides a simple interface for report queries that allows users with minimal experience to full access to administrative level tools. View the information below to learn more about this powerful reporting software.
The 'Queries' page under the 'Monitoring' node provides key information about queries currently executing on the server. In a clustered environment, select a machine from 'Cluster Node' menu to view the monitoring statistics for that machine. The page provides the following information:
#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index |
|
Read More |
Query ID |
A unique identifier. |
Data Objects |
The number of dataset rows cached in memory or disk. |
Thread |
The thread within which the query is executing. Click the link to obtain a stack trace. |
Name |
The name of the query, or of the worksheet/data model executing the query. |
Asset |
The name of the report or Viewsheet from which the query was executed. |
User |
The user who executed the query. |
Rows |
The number or query rows that have been processed. (Requires 'Monitoring Level' set to 'Medium' on the 'Settings' page.) |
Age |
The length of time that the query has been executing. |
|
“We evaluated many reporting vendors and were most impressed at the speed with which the proof of concept could be developed. We found InetSoft to be the best option to meet our business requirements and integrate with our own technology.”
- John White, Senior Director, Information Technology at Livingston International |
To terminate an executing query, click the corresponding 'Select' box to select the query, and then click the 'Remove' button.
The 'Cache' page under the 'Monitoring' node provides key information for both the report cache and the data cache. In a clustered environment, select a machine from 'Cluster Node' menu to view the monitoring statistics for that machine. The page provides the following information:
Pages |
The number of report pages cached in memory or disk. |
Data Objects |
The number of dataset rows cached in memory or disk. |
Hits |
The number of cache hits. A hit occurs when a query is performed against the cache and a match is found. (Requires 'Monitoring Level' set to 'High' on the 'Settings' page.) |
Misses |
The number of cache misses. A miss occurs when a query is performed against the cache and no match is found. (Requires 'Monitoring Level' set to 'High' on the 'Settings' page.) |
Swapped |
The number of bytes swapped from disk to memory, or from memory to disk. (Requires 'Monitoring Level' set to 'Medium' on the 'Settings' page.) |
More Articles About Reporting
Cruise Company Analytics - If you have taken two or more cruises in the last three years with AAA, on a cruise ship, you are going to be getting information on only special cruise promotions that they feel are unique to the way you have shown you a proclivity for travel. Let's say you happen to be traveling on Amtrak, and let's just say because you are based in Washington, D.C. You are a regular traveler from D.C. to New York City on the train. It's just the easiest way to get between the two cities. And sometimes you will travel business class but not all the time. They know an awful lot about you from their operational databases, my previous behavior, transactional behavior, and demographics. When they see you traveling to New York, for example, the next time they will offer you a 30% or some type of discount on the D.C. to New York train in a business class ticket...
Data Science Solution Deployment - Sure, and as we're looking to the future, not only on the payoffs and the implications of where this is relevant, there's also some architectural changes with the way people are using a hybrid cloud technologies sourcing their data centers in different ways. Tell us a little bit about how you're deploying your data science solution. Are you using this all on premise? Do your security requirements make that necessary now? Are you into a hybrid mode, or how will that pan out in the future, and how might that impact how you can get more data into a compute mode that you can analyze...
Evaluate InetSoft's Easy Dashboard Creation Software - Looking for a tool for easy dashboard creation? InetSoft is a pioneer in self-service dashboard design with a drag-and-drop designer for business users. View a demo and try interactive examples...
Reasons to Use Analytics in People Performance Management - The most common analytics used in people management include employee engagement surveys, 360 degree feedback, and performance reviews. These tools allow managers to get a better understanding of what motivates their team members and how they can be supported. A recent study found that organizations using analytics to measure employee productivity were able to improve overall performance by 10 percent. The study also showed that companies that used analytics to track employee performance had higher levels of customer satisfaction than those who did not use analytics. The most important thing to remember when using analytics in people management is to be sure to use data correctly. For example...
Risk Free Starter for KPI Software - Built-in, in-depth interactivity and customization allows business users to dynamically reshape pre-designed dashboards for changing business needs with zero training. Self-service dashboarding further empowers business users with direct access to underlying data assets in a governed and secure environment. Designers can prepare and mashup data from many data online and on-premise sources. Dashboard design is integrated with data preparation in a single web app. The same web app is also user portal where designers can engage business users even during dashboard design...
Using the API to Create Dashboards from XML Data Sources - Using InetSoft's API to create dashboards from XML data sources opens up a range of possibilities. Here are some scenarios illustrating how this can be beneficial: Dynamic Data Integration: Scenario: Your organization receives XML data from various sources, and you want to dynamically integrate this data into dashboards. Use Case: Utilize the API to programmatically fetch XML data, transform it as needed, and populate dashboards in real-time, ensuring that the information is always up-to-date. Automated Dashboard Generation: Scenario: You have a system that generates XML reports regularly, and you want to automate the creation of dashboards based on these reports. Use Case: Develop a script using the API to automatically generate dashboards from incoming XML reports, saving time and ensuring consistency in dashboard creation. Custom XML Schema Support...