Panorama NovaView for Microsoft SQL Server Analysis Services

Key Features

Panorama NovaView for Microsoft SQL Server AS offers a single integrated Proactive BI solution that includes analysis, reporting, dashboards, scorecards, modeling, and advanced data visualization.

Advanced Analytics

Panorama NovaView makes it easy to select, filter and highlight subsets of data for further analysis, based on wizards and rules designed for business users. Value filters, available from a pop-up menu, let you select data sets based on Boolean logic, ranges, top and bottom count, and top and bottom percent. You can add sliders set to predefined filter values, such as the top 5, 10, or 25 sales representatives or accounts.

A Select Members pop-up menu lets you manually select dimension members or search for members based on alphanumeric characteristics (exact match, starting with, or pattern). For example, Panorama NovaView can find a customer name or an inventory part number from thousands or millions of records using the search function.

Exception management features enable users to quickly identify results above or below expectations.  Panorama NovaView’s “bubble-up” exceptions feature can find poorly performing products, sales outlets, or customers at the lowest level of detail. 

Advanced Time Based Analysis

Panorama NovaView excels at time-based analyses, a hallmark of business intelligence applications. Panorama NovaView knows what the current day, week or month is.  Using that information, the MDX time functions provide year-to-date results through the current day, week, or month.  A user only has to select the appropriate date level and Panorama NovaView does the rest.

Users can toggle back and forth from calendar time, to fiscal time, to reporting time periods.  Panorama NovaView knows what time hierarchy is in use, so all the time period comparisons work correctly with no user intervention.

Panorama NovaView's Time Period Comparison dimension incorporates a wide variety of calculations with variances, including current period, previous period, same period last year, YTD, MTD, and WTD. Current YTD, MTD, and WTD also can be compared to the same periods last year.

Reporting: Seamless Navigation From Reporting to Analytics with One Click

• In cell visualization in pixel perfect reports
• Report can be navigated just like any analytical view

Performance Enhancement

Panorama NovaView for SQL Server 2005 supports connection pooling to route queries with similar characteristics (such as user roles and slicing authorizations) from multiple web clients to a single OLEDB connection. NovaView then uses its advanced smart caching technology to cache the query results and a variety of scenarios, using the cached data to respond to any identical requests over a configurable time period. This feature reduces system resources loads and enables multiple users to use a single connection.  The result is more users able to access the NovaView Server at any given time, reduced data traffic, and improved response time.

Security

Enterprise web-driven BI applications usually have several security layers: portal/web/access, report/view, and data. Panorama NovaView offers security options at each level, ensuring the confidentiality of organizational data. Panorama NovaView supports User impersonation protocol.

 

  

Solution Overview

Key Features

Product Tour

Case Studies

Whitepapers

Virtual Appliance