Welcome Guest | My Membership | Login

International Spectrum
More MultiValue Database and Products Articles...

U2 Product Release: U2 DataVu Web Report and Dashboard v2.0

U2 DataVu 2.0 has been enhanced with a variety of features that make it easier for users to access, analyze and visualize business data. Users can now combine results from queries, apply filters and transformations and quickly create reports and charts with a series of mouse clicks. Drilldown scenarios provide users with the ability to slice their data, accessing underlying information on demand. Predictive analytics, flexible result set joining and appending, cross-tabulations and data normalizations together with result set filtering and improved parameter prompting make U2 DataVu 2.0 both powerful and a breeze to use.

Conference Schedule

Florida 2018 - April 23rd-26th
More Info

 

 

Release Date: Thursday, June 30, 2011

U2 DataVu 2.0 has been enhanced with a variety of features that make it easier for users to access, analyze and visualize business data. Users can now combine results from queries, apply filters and transformations and quickly create reports and charts with a series of mouse clicks. Drilldown scenarios provide users with the ability to slice their data, accessing underlying information on demand. Predictive analytics, flexible result set joining and appending, cross-tabulations and data normalizations together with result set filtering and improved parameter prompting make U2 DataVu 2.0 both powerful and a breeze to use.

Business users will benefit from the new HyperVu web interface allowing them to manage their queries, reports and dashboards and power users will benefit from the new integrated repository allowing any query, report or dashboard to be shared with others.

One-click Generation of Charts

U2 DataVu 2.0 allows you to select columns from a query result and with one click turn them into the chart of your choice. Charts can refined, adding additional value columns, changing the chart type and formatting the output. Any number of charts can be stored with the original query, allowing users to select between each of them when the query is subsequently accessed.

Graphical Drill-down Scenarios

Charts can be transferred to scenarios and used to explore different levels of detail using a drill-down navigator. These scenarios can be refined to change the data level and data sets displayed and can be recorded to define the layout options that users will be presented for chart layouts. Multiple scenarios can be driven from the same underlying result set.

Wizard-driven 'quick reports'

U2 DataVu 2.0 allows you to transfer a result set to the U2 DataVu Report wizard to quickly generate a new report. The two-step wizard guides you through defining the columns that will appear on the report and the grouping and aggregations that should be used for data roll-up. Simple options for preferences and formatting guide you through the aspects you need to quickly create reports without the need to resort to a full report editor.

Result set Joining and Appending

Queries can be assembled into hybrid or 'complex' queries allowing you to join data from unrelated data sources. Users can append data from separate queries or use the results of one query to automatch target columns in a related query. To the user, these queries appear as one result set but at run-time U2 DataVu will decompose and execute these against their respective data sources.

Filtering

U2 DataVu 2.0 allows results to be filtered post-Query. These filters can be simple or compound expressions, allowing users to determine what data should be shown. These filters are applied at the client or web-server level and do not require queries to be re-executed.

Improved Query Prompts

Columns in queries can be assigned a prompt allowing for easier selection of data when running a query. Parameters can be applied for simple prompts such as numbers, date or times or complex, multi-tiered prompts can be used to define prompt queries that are executed against data to define the values to be used for selection. (e.g. a State and City prompt hierarchy can be defined to provide the list of States and Cities to be used to select data from a locations file)

Predictive Analytics

U2 DataVu 2.0 provides a comprehensive data modeling solution for predictive analytics to compute trends and cyclicity in query results. Popular algorithms, including simple and weighted moving averages, exponential smoothing, Holt-Winters, multiplicative decomposition, nth order curve fitting, polynomial regression and neural network analysis, are available allowing multiple algorithms to be applied to result set data to determine the best statistical fit

Normalization and cross-tabulations

In order to gain an insight into business data, users must often transform or tabulate query results. U2 DataVu's new data manipulation features allow users to tabulate column values over two or more dimensions. Conditional crosstabs offer the same capability but for specific rows that match a defined criteria. DataVu's normalization feature allows users to transform column-based results into row-based results, often useful when subsequently joining data with other queries.

HyperVu Web interface for Business Users

U2 DataVu 2.0 introduces a new web interface, specifically designed for business users. This intuitive interface provides a simpler view into pre-built repository content yet provides the necessary ad-hoc charting facilities that business users require. A simple menu of options allows results to be explored and directly exported to Excel with one click.

Built-in Shared Repository

A new built-in shared repository that can be used by developers and web users alike allows for developed content to be easily shared and quickly deployed to end users without requiring an external repository database. Simply drag and drop developed content from your own repository to the built-in shared repository to provide users with immediate access.

Virtual Data Sources

Data schemas are often too complex for business users to consume. DataVu's new virtual data source facility provides a metadata layer that allows administrators to publish a simplified data schema for end users. Virtual data sources can accommodate a subset of available files in a given data source and both files and columns can be represented with simplified, user-friendly names.

Example Content

U2 DataVu provides a suite of example Queries, Visual Reports and Dashboards that demonstrate best practices in building Queries, embedding graphical capabilities in Visual Reports and authoring Dashboard content. Included with every U2 DataVu product is a copy of U2 XDEMO which is used in online tutorials and education so you can replicate what you learn with your own version.

 

# # #          # # #          # # #

 

About Rocket Software

Rocket Software (www.rocketsoftware.com) is a technology company that helps organizations in the MultiValue ecosystem modernize and optimize solutions to meet today's needs while extending the value of their technology investments for the future. Thousands of companies depend on Rocket to solve their most challenging business problems by helping them run their existing infrastructure and data, as well as extend those assets to take advantage of cloud, mobile, analytics, and other future innovations. Founded in 1990, Rocket is based in Waltham, Massachusetts with locations in Europe, Asia, and Australia.

For more information, visit http:/​/​www.rocketsoftware.com

About UniData

A MultiValue application platform for developing fast, flexible and secure applications

Organizations rely on Rocket UniData, a best-in-class of the MultiValue application platform, for scalable business apps that can evolve as needs change. As a stable, secure, fast data server engine with high availability and low administrative overhead, Rocket UniData is ideal for rapid development using modern tools. On-premises or in the cloud, UniData serves nearly a million users worldwide.

Performance by design

  • A unique and resilient architecture delivers performance advantages compared to traditional SQL databases
  • variable length records and tables within tables simplifies database design, eliminating the constraints of SQL normalization
  • using direct-read capabilities that result in fewer I/O operations than required by SQL, UniData is faster than many other databases
  • variable length records mean less data is transmitted within the entirety of the system which translates to:
    • more responsive mobile applications
    • more efficient replication (for disaster recovery, high availability and more)
  • Rapid development means rapid returns

    UniData includes multiple, easy-to-use programming languages (including Python) with multiple standard supplied interfaces (Node.js, .NET, Java, ODBC, JDBC, RESTful via JSON) for multi-tier solutions. Accelerate your teams productivity by selecting the best development tools based upon your staffs capabilities.

    Security is paramount

    Rocket embeds the most effective security standards for encryption technology deep within the data server, so your data is secure no matter its location, and whether in-transit or stored on disk.

    • SSL/TLS secures connections to the MultiValue server and encrypts data in transit for protection from snooping or eavesdropping. Third parties can also validate and accredit our cryptographic modules for FIPS 140-2 compliance.
    • Automatic data encryption ensures only trusted users with the encryption key can view data. Stolen data is rendered useless without the encryption key.
    • UniData also offers role-based security for users accessing the application. Required DBA maintenance to implement and maintain these capabilities is simple and efficient.

    For more information, visit http:/​/​www.rocketsoftware.com/​products/​rocket-​unidata

    About UniVerse

    Fast, flexible data management and app development for your enterprise

    Rocket UniVerse, a component of the MultiValue application platform, is a fast, flexible data server for developing enterprise apps. Its variable length, table-within-table architecture means speedy data access and low maintenance with user interfaces for Windows, Linux, and UNIX. Deployable to the cloud or on-premises, thousands of customers globally depend on UniVerse to run their businesses.

    Performance to spare

    • Extremely flexible data structures with high-performance data access, storage, and resource management capabilities
    • Industry-proven design with direct read capability means fewer I/O operations and faster access to data
    • Dynamically allocates available resource to maximize processing throughput of available resources

    UniVerse makes it easy for them to build for your success

    Powerful, easy-to-use programming languages with standard supplied interfaces (.NET, Java, ODBC, JDBC, RESTful with JSON) enable your programmers to become immediately productive in this fast environment.

    Efficiency and speed to market mean faster returns on your investment

  • Does not require a large administrative or programming staff to implement, operate, or maintain
  • Accelerates the time to value for applications, and provides exceptional short- and long-term ROI
  • Includes multiple programming languages, including Python, with multiple interfaces for your tiered architecture so you can pick and choose the best development solutions based upon your staffs capabilities
  • Secure and auditable

    • SSL/TLS secures connections to the data server, in addition to securing data in transit from snooping or eavesdropping.
    • Automatic data encryption makes it easy to adhere to the highest security standards, protecting data at rest on the disk.
      • Only trusted users with the encryption key can view data, and stolen data is rendered useless without the encryption key.
      • Access is granted at the user or group level via role-based security, reducing the time required for DBA maintenance.

    For more information, visit http:/​/​www.rocketsoftware.com/​products/​rocket-​universe

    Related Articles:


    Return to top