|
|
|
|
|
Powerful Ad-hoc Analysis
Powerful Ad-Hoc Analysis for Real-Time “Slicing and Dicing”
Transforming data into actionable information, how and when needed, is now possible within a matter of clicks. Whether pivoting or stacking member information, all customized analyses can be saved for future personal or shared use via the web. - Create unique queries on-the-fly, without the need for a wizard or separate design environment
- Generate virtual members using the Dynamic Calculator
- Highlight exceptions with advanced Traffic Lights
- Conduct what-if scenarios or forecasting with the advanced write-back capabilities of Data Entry
- Save time and effort with the ability to record actions such as active exception monitoring with DynaSelect, Executive Viewer's easy to record macro functionality
  (click to enlarge)
Create Unique Queries On-The-Fly
Creating a new query is as simple as pointing a web browser to Executive Viewer and selecting the desired OLAP database from a pull down menu. Once the query has been created, all available dimensions are automatically populated into the new report, defaulted to a level where live data will instantly be seen and is available for slicing and dicing.
 (click to enlarge)
Generate Virtual Members with the Dynamic Calculator
Dynamic calculations such as totals, ratios, variances and ranking can be instantly created with the built-in Calculator. Once created, the calculations are stored as virtual members, automatically updated with the current OLAP data and treated the same as database-stored members. Since the calculations are dynamically based on members rather than position, they can be used for creating member groupings not found in the OLAP database in addition to the typical measure creation.
 (click to enlarge)
Highlight Data Exceptions and Trends with Traffic Lights
For visual representation of data exceptions and trends, value-based color-coding (Traffic Lights) can be applied to all members, including calculated members, within the report or as part of the selection criteria.
 (click to enlarge)
Conduct What-If-Scenarios & Forecasting with Data Entry
Web-based corporate planning, budgeting and forecasting applications can be easily deployed with Executive Viewer's Data Entry capability. Based on the user's database security level and access, data is entered directly into the allowed cells and once submitted, the databases can be refreshed or recalculated without leaving the application.
 (click to enlarge)
Save Time and Effort with DynaSelect
DynaSelect provides a programming-free way to automate reports and analyses. All steps being conducted for the analyses are recorded as they are being done and the functions are automatically applied each time a sheet is refreshed or a new member is selected. The possibilities of DynaSelect are numerous, including automatically finding and selecting a current time period, identifying members according to an exception criterion and more.
 (click to enlarge)
|
|
|
|
