Release Date: Monday, September 27, 2010
MITS®, the leading provider of reporting and business intelligence solutions, today announced a major new release of its popular operational reporting solution, MITS Report.
MITS Report 3.0 includes an array of new features designed to safely put more power in the hands of end users and free up busy IT resources—while ensuring both data security and overall system performance.
“This version will enable organizations to more rapidly understand situations, get answers and act on them,” says Mickey Lass, MITS Vice President of Sales and Business Development. ”It reflects not only the kinds of enhanced capability our customers have requested—but also establishes important foundational technology for future enhancements, both planned and yet to be identified.”
Calculated columns mean more answers—for more end users.
With version 3.0, MITS Report now lets users create and incorporate new data not identified when the reporting environment is initially configured.
“It’s not unusual for organizations to discover new information needs after MITS Report is in use for a while,” says Gary Owen, MITS Vice President of Development. “Often, once users get better visibility of their company’s data using MITS Report, they start asking more questions. The new Calculated Column feature addresses this issue.”
The new feature lets users create a new column from other data already included in a report, much as users of spreadsheet software can specify a formula for deriving a value that’s not included elsewhere. To oversimplify, if the reporting environment provides data on revenues and employees, an end user can create a new “revenue-per-employee” item and include it in a report. Calculated columns like this one are stored in MITS Report along with all the other reporting data, and are available to other end users for their own reporting needs.
Particularly appealing is the way end users specify how a value is calculated. Instead of composing a complex formula as with most spreadsheet software, users can access a graphical, point-and-click, wizard-like dialogue to define a calculated column in a report.
Foundational design offers ease of use, high performance—and more to come.
The MITS Report development team took its time, evaluating multiple design approaches, to add this important feature. “It’s powerful—the ability to define complex calculations with ease and the ability to store these definitions for reuse. We were certain our customer base would begin seeing the possibilities and ask for more, related functionality—so we had to get the design right,” says Gary.
The results include some unique advantages:
- If a user tries to create a new calculated column with the same definition as one created by another use, he’s alerted to use the one already in place.
- Progress bars alert and inform users when complex calculations require extra time.
- Administrators can grant calculated column creation privileges to a subset of end users, while all end users can take advantage of the new data items once they’re defined.
- Security is enforced at the calculated column level. Users cannot see data derived from forbidden columns.
Date-range columns: easy to use comparative and trend reporting.
The MITS development team has already begun to leverage the new foundational technology—in this case, to give users the ability to assign date ranges to columns, enabling comparative and trend-focused reports.
Take a given quantity or amount—such as sales by department, or inventory by product line—and have it display only data falling within a specified date range, and you have a data-range column. Take two or more such columns—each associated with a different date range—and you have ready-made comparison or trend reporting.
Because it is built on top of calculated columns, it gets all the benefits listed above.
“We’re certain our customers will want other specialized features like this,” says Gary. “So it has been well worth the extra time we took to optimize the underlying calculated column design.”
Ranking helps identify sweet spots, areas for attention.
The new release also adds an easy-to-use ranking feature that’s ideal for performing rapid, basic analysis of operational data. Simply by clicking on a column heading, users can sort data after it’s summarized to quickly prioritize their work. Sorting a report, for example, by our calculated revenue-per-employee figure from above, could quickly identify who needs a bonus—or who needs training.
Simple, elegant additions with big impact.
Other new features include convenient tools for modifying reports more quickly, so users can easily look at operational data in different ways, or prepare multiple views of the same information for different report consumers who have varying needs.
As with many major technology advances, the true value of MITS Report 3.0’s new capabilities will be in its everyday use. “We worked hard to make each of these features natural and easy to use,” says Gary. “At the same time, extensibility was a critical goal, and we were very careful to achieve the right blend of new capability and readiness for ongoing expansion and enhancement.”
About MITS
MITS® is a leading developer of Advanced Reporting and Business Intelligence products. The MITS product line contains both the MITS Discover® OLAP Business Intelligence suite, as well as the ad hoc report tool, MITS Report®. Founded in 1996 and headquartered in Seattle, Washington, the company's technologies are used by thousands of organizations, resellers and systems integrators worldwide. MITS products are firmly entrenched in a wide range of business areas, including manufacturing, distribution, retail sales and services, education, government, healthcare, and insurance, as well as in many other industries.
For more information, visit http://www.mits.com
About UniVerse
Reliable and Flexible Foundation for Business Solutions
Successful businesses continually push themselves to find ways to maximize their effectiveness and reduce costs. UniVerse maximizes return on investment and is built to keep costs low, delivering uncompromising reliability and power with the features that successful businesses need.
UniVerse offers a unique combination of an intuitive development environment and a powerful, reliable data engine. It is easy to embed in an application and delivers high-performance and high scalability in a small footprint. On top of that, it's very easy to use and administer.
Based on technology newer than the relational model, UniVerse uses XML-like data structures resulting in fewer tables, fewer joins and better performance.
Highlights
- Provides intuitive database design and high performance data access
- Secures data through encryption and authentication
- Ensures high availability through data replication
- Enables access via a variety of APIs, protocols, frameworks and architectures
- Provides flexible data storage choices for maximum interoperability
- Accelerates time to market and lowers TCO for business solutions
For more information, visit http://www.rocketsoftware.com/u2/
About UniData
Secure and Available 24 X 7
Tuned for business
The current economic climate demands more from your technology than ever before. While easy-to-use, high-performance solutions have always offered a faster return on investment, they may be a matter of survival today. And for businesses prepared to take advantage of changing times to position themselves for the future, they offer a competitive advantage.
UniData(r) comes into its own at times like these, delivering the capabilities you need to develop, enhance and deploy comprehensive business applications rapidly and with minimal cost.
UniData is an extended relational database ideal for embedding in vertical solutions. It allows multiple nested tables within a table, while maintaining support for ANSI SQL access. Data modeling is more intuitive and fewer tables are created compared with a traditional relational database.
Using UniData, developers can create solutions quickly and easily for a wide variety of markets. The product's real-world approach to application development and deployment minimizes time to market, which in turn saves you money and helps you compete more effectively.
Highlights
- Delivers low TCO and exceptional scalability to meet the challenges of on demand business in the SMB and large enterprise market
- Provides intuitive design and high-performance queries using extended relational data model
- Enables use of standard protocols including ODBC, OLEDB, ADO.NET, JDBC, XML and SOAP
- Supports security and robustness via encryption, authentication and high availability features
- Features native, high performance interfaces for .NET, Java(tm) and more
- Leverages application investment with flexible data storage
For more information, visit http://www.rocketsoftware.com/u2/
About Reality
A MultiValue and relational(SQL)-enabled database, it allows users to maximise the use of existing technologies while ensuring their customers needs are met, now and in the future. While maintaining its virtual machine concept, Reality now has open interfaces - using integrated ODBC/JDBC SQL, Web Services, HTML, TCP/IP Sockets and simple extensions to DataBasic - an extended Dartmouth BASIC language with exceptional database and string handling abilities. Remote calls can also be made in order to provide integration with open Java applications and Microsoft Visual Basic/C/C++/C# and .net.
For more information, visit http://www.northgate-reality.com/
About D3
The D3 DBMS embodies the best and most desired features for developers and users. It is simple in its structure but allows for complex definitions of data structures and program logic. The built-in development environment allows applications to be rapidly prototyped, developed, and modified on the spot. Custom applications and on-site enhancements are common in the D3 community. Everything required for development is already in D3, making D3 much more than a typical database environment. Site administration requires a fraction of the staff of other environments of the same size - a large proportion of sites running D3 do not have an IT staff.
D3 is developed and supported over the many environments indicated on these pages. All code and data easily migrates between environments without modification, so both developers and users can work on their platforms of choice.
Other products from TigerLogic include connectivity tools like FlashCONNECT for web, the D3 Class Libraries, the Open Systems File Interface for Oracle and other environments, and XML technologies to exchange data with other XML-compliant programs or environments.
For more information, visit http://www.rainingdata.com/products/dbms/d3/index.html
About jBase
A multidimensional database, a development environment including a
development language, and a middleware component allowing other
mainstream and standards-based products to communicate with the jBASE
products. The unique jEDI middleware enables access to other databases
such as Oracle, DB2 and SQL Server. Microsoft Windows, all major Unix
platforms including Linux, and IBM's e-Servers are supported.
For more information, visit http://www.jbase.com/products/jbase.html
Related Articles: