![]()
|
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
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.
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.
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.
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.
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.
|
|
|
