Technical Specifications

proCube is a Windows program for the creation and maintenance of multi-dimensional data grids that add database power to spreadsheets. proCube lets you easily drag-and-drop to rearrange analytical dimensions, facilitating complex  business data analysis on-the-fly. This enables the user to obtain—in an instant—views of business data that were once prohibitively complex to request and slow to present. With this new power, trends that were previously invisible can now be uncovered.

proCube’s analytical power can be utilized directly in the proCube interface or in Excel, with which proCube is thoroughly integrated. This leverages users’ familiarity with Excel opens your data to Excel’s rich visual tools. Excel worksheets created from proCube retain a dynamic connection to the proCube database, providing live data that is always up-to-date. This live connection is the key factor by which proCube eliminates the duplication of effort and resultant errors inherent in traditional spreadsheet maintenance. The following figure shows a proCube grid, called a ‘slice,’ and its instantly-created equivalent in Excel.

Figure 1.    A proCube Slice and its Dynamically-Connected Equivalent in Excel

Hardware Requirements

Server

Server

Technical Requirements

Hardware

Dedicated Physical Server (Do not share with other applications.)

 

Intel Quad Core Processor 2.0 GHz or greater with 16 GB RAM (4 GB RAM per proCube Instance is recommended)

 

Storage Array Controller with 512MB Cache and Battery Backed Controller

 

20 GB free hard disk space

Software

Windows 2003 Enterprise Edition, Windows 2003 Standard x64, Windows 2008 Enterprise, or Windows 2008 Standard x64.  (x64 version of Windows is recommended)

 

Microsoft .NET 3.5

Workstations

Workstations

Technical Requirements

Hardware

1 GHz or greater with 1-GB RAM or more

 

250 MB free hard disk space

Software

Windows XP, Windows Vista, or Windows 7

 

Microsoft Excel 2003 (32-bit), 2007 (32-bit), or 2010 (32- or 64-bit)

 

Microsoft .NET 3.5

Technical Limits

Item Specification

Technical Limits

Concurrent Users Signed In

Limited by license

Users

Unlimited

Groups

Unlimited

Database Size

3 GB on 32-bit OS
4 GB on 64-bit OS

Cubes

Unlimited

Slices

Unlimited

Slice Size

Unlimited

Dimensions

Unlimited

Members per Dimension

Unlimited

Hierarchy Levels per Dimension

Unlimited

Cube Design

Multi-cube

Features and Functions

General Design

  • Multi-cube architecture for optimum recalculation speed.

  • Support for multiple instances of Windows service on the server (to optimize performance by isolating workgroups with disparate processing loads, such as data entry versus financial analysis).

  • Multi-threading with intelligent queuing so that a lengthy calculation does not stop other tasks.

  • Support for multiple processors and hyper-threading, automatically scaling to the number of processors present.

  • Opens shared databases or standalone, workstation-based databases.

  • Option to allow reserved characters in fact data (quotes, periods, commas, etc.).

  • Automatic database backup option.

  • Configurable proportion of memory allocated to caching of data.

Security

  • Option for secured or unsecured databases.

  • Secured sign in (username and password).

  • Object-level security at cube level and down to specific data point.

  • Functional security at three levels (user/operational administrator/administrator).

  • User-changeable password.

  • Maintenance of users and groups.

Customization

  • Comprehensive Application Programming Interface (API) using Microsoft .NET architecture. Advanced technical users can make use of it for programmatic purposes by calling functions via a COM wrapper within MS Excel. This new API supports opening multiple databases simultaneously.

  • Comprehensive formula language in proCube. For details, refer to Creating Cube Formulas.

  • Approximately 80 proCube functions available in Excel, with point-and-click parameter selection, to use in creating your own worksheet automation and customization.

Usability

  • Menu, toolbar, context menu (right-click), and accelerator key support for functions.

  • Recent database “pick list”.

  • Comprehensive, illustrated help file with end-to-end scenarios.

  • Color-coded icons for hierarchical, detail, persistent, and page members.

  • Option to automatically re-open most recent database.

Slice Editing

  • Two-click slice creation (grid view of a cube, using all dimensions with last two as columns and rows, respectively).

  • Drag-and-drop dimension/row/column arrangement.

  • Pivot slices by dragging dimensions.

  • Selection of only aggregate, detail, or child members.

  • Searching and selection of members by text filtering, levels, particular orders, browsing hierarchy, and subsets.

  • Specification of ad hoc member set.

  • Ability to hide zero rows or columns.

  • User-defined row and column constraints (to show/hide only certain data) with:

  • Point-and-click range reference expression builder.

  • Boolean and comparison operators (AND, OR, <, <=, etc.).

  • “TOP” and “BOTTOM” operators to isolate key data.

  • Syntax checking.

  • Fill Down, Fill Right, and Clear Cell functions.

  • Edit and preview (no dimensions) modes.

Slice Viewing

  • Automatic or on-demand recalculation modes to optimize for analysis or report creation, respectively.

  • Drill through (reveal transactions from source database).

  • Drill down in cube (list data for hierarchical page members).

  • Frozen column and row headings.

  • Color- and font-coded cells at four levels (detail, read-only, detail heading, aggregate heading).

  • Eight number formats.

Cubes

  • Data automation through cube-level formulas, shared across multiple slices and resultant worksheets.

  • Complete customer control of formulas.

  • Inter-cube (cross-cube) formula references.

  • Formula editor with:

  • Over 100 self-prompting, point-and-click functions (arithmetic, logic, date, etc.).

  • Rich text editing capabilities (undo, selection, block indentation, etc.).

  • Color-coding.

  • Bookmarks.

  • Point-and-click range reference expression builders.

  • Syntax checking.

  • Definition of data dependencies to eliminate recalculation time spent unnecessarily on frozen, historical data.

  • Four levels of manually-assigned data locking, to effect temporary or long-term protection, workflow techniques, and performance optimization.

  • Object security at three levels per user and/or group: Read, Add, Design.

  • Fact data (business numbers or measures) security down to the individual data point, per user and/or group.

  • Transfer cube data from one cube to another, with optional scripting to transform values.

Dimensions

  • Definition and reuse of members subsets.

  • Definition of member aliases (alternate languages or coding schemes) and display in Excel.

  • Definition of member properties (ancillary business information) and display in Excel.

  • Member weightings can be defined, to conveniently effect negative multipliers .

  • Object security at three levels per user and/or group: Read, Add, Design.

Excel Integration & Exporting

  • One-click Excel worksheet creation from proCube.

  • Dynamic data connection between proCube database and the Excel worksheet:.

  • Values changed in proCube are seen by users when they open or update worksheets.

  • Values changed in Excel (where configured to be permissible) are saved in proCube database.

  • All proCube object (data) security rules enforced from Excel.

  • Three formula options (one formula per sheet, one per cell, or support for pivotable sheet).

  • One-click creation of “values only” worksheet (no formulas or live connection to proCube) .

  • Export metadata to ASCII text or XML.

  • Export slice or cube to ASCII text.

  • Export security specifications (encoded and password protected).

  • Creation of relational database tables from multidimensional cube fact data.

  • Save standalone proCube database from Excel.

  • Drill through (reveal transactions from source database) from Excel workbook.

Importing

  • Import data from source, relational database, including….

  • Point-and-click, wizard-based definition of a reusable, editable specification for the import mapping.

  • Industry-standard ODBC connectivity to source databases.

  • Preview (open) listings from source tables.

  • Metadata and fact data import.

  • Timed and/or on-demand updating.

  • Whole table updating.

  • Ability to have manually-added members persist through whole table updates.

  • Automatic derivation of member aliases (alternate referencing schemes such as UPC codes instead of product names) from source tables.

  • Automatic derivation of member properties (supporting business information) from source tables.

  • Specification of conditional rules dictating which items to import.

  • Assignment of member names from selected range of characters in source values.

  • Specification of additional, non-imported source fields that can later be accessed from proCube.

  • Import metadata from ASCII text (with configurable delimiter) or XML.

  • Import fact data from ASCII text.

  • Import security specifications (encoded and password protected).

Administration

  • Automatically save database at timed interval.

  • Automatically save database at specific time-of-day.

  • Configurable quantity of backups retained.

  • Transaction logging and report.

  • Restore database transactions since a specified time.

  • Undo database transactions back to a specified time.

  • Remotely notify users of system maintenance.

  • Disconnect users remotely and prevent subsequent logins.

  • Cancel individual or all user calculations.


Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk