Home >

Dataleaf Technologies, Inc:  HR System migration, Archiving, Analysis, Modeling, Interim HRIS

[Document ©2001-2005 Dataleaf Technologies, Inc, 486 Concord Street, Carlisle MA 01741. Contact georgestalker@dataleaf.net, (978) 369-7472]


'Cube' Implementation

Some applications offer the user a proprietary functionalities for reporting or packaging data. These facilities are useful, but often difficult for users to learn to use.

Typically, Dataleaf® data marts use a different approach. Unless forestalled by security considerations, Dataleaf® data marts most often emit formatted and labeled reports, graphics, and 'live' pivot tables and charts in MSExcel.

In the case of local or standalone Dataleaf® implementations, most pivot table reports are packaged in self-contained, portable files, based on rows selected by the user.

Such reports are portable, presentable, linkable, and contain a well-understood drill down capability. Codes appearing in Dataleaf-generated Excel pivot tables are accompanied by descriptions which are themselves accessible for breakdowns.

In other instances, server-resident (or, occasionally, client-resident) OLAP structures may be used. Of course volume, performance, and security issues combine to determine the best approach in each individual case.

For online Dataleaf® databases, a number of different approaches are used. For example, reports on user-selected data rows are sometimes implemented as linked pivot-table/data pairs.

complementary options are always available

Naturally Excel pivot tables can't meet every reporting need. All Dataleaf® databases incorporate other reporting mechanisms, activated at the client's option. Often this means printable or PDF-format predefined reports, flat Excel worksheets/charts emitted by the application, and even MSAccess databases emitted by our applications.

fully-portable pivot tables and charts...

cube image

Dataleaf® data marts emit formatted and labeled reports, graphics, and 'live' pivot tables and charts in MSExcel.