Welcome Guest | My Membership | Login

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

2018 - April 10th-12th
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 is a global software development firm that builds and services Enterprise Infrastructure products for the world’s leading OEMs, networks and software companies and enterprises. The company’s current lines of business complement and extend strategic OEM offerings in the areas of database, business intelligence, storage, networks and telecom, terminal emulation and FTP, integration, modernization and SOA, and security. Rocket is engaged in business and technology partnerships with IBM, EMC/RSA, HP/EDS, Nortel, Motorola, and many others. Rocket Software is based in Newton, Massachusetts.

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

About UniData

Power and Performance without the Maintenance.

Deliver Even Better Availability, Interoperability and Security for Your Data.

UniData is an extended relational data server ideal for embedding in a variety of industry-focused solutions. Its extended relational model, with NoSQL access to data, is perfect for rapid cost-effective applications serving the needs of businesses from SMB to the enterprise where outstanding performance, reliability, scalability and manageability are needed.

Product Highlights:

  • Delivers low TCO and exceptional scalability to meet the challenges of on demand business in the SMB and large enterprise markets
  • Provides intuitive design and high-performance queries using an extended relational data model
  • Supports security and robustness via encryption, authentication and high availability features
  • Features native high-performance interfaces for .NET, Java and more
  • Includes U2 Dynamic Objects for easier exchange of data with web services

Emerging Technologies:

  • Data Type Enforcement provides an optional check on data written to a file in order to assure only valid data is stored.
  • Replication with External Database Access (EDA) can be used to replicate your data to a SQL database on the same server.
  • U2 MetaData Manager (U2 MDM), a user-friendly tool, quickly and easily builds and maintains mappingsfor your SQL tools accessing UniData.

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

About UniVerse

Fast and Flexiblefor the Enterprise.

Modern data. Managed.

UniVerse is an extended relational data server optimized for embedding in vertical applications. UniVerse offers a nested relational (MultiValue) data model , with NoSQL access to data, means intuitive data modeling and fewer resulting tables.

Product Highlights:

  • Delivers high performance to business solutions through super-efficient database structures
  • Speeds your time to market while providing a lower total cost of ownership
  • Advanced management with audit logging and account-based licensing
  • Protects your data and provides around-the-clock availability to your enterprise application
  • Integrates easily with third party software and external data sources

Emerging Technology:

U2 MetaData Manager (U2MDM), a user-friendly tool, quickly and easily builds and maintains mappings for your SQL tools accessing UniVerse.

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

Related Articles:


Return to top