From what I have seen over the years, EIS drills through, using ODBC technology on the server, on data intersections and essentially dumps relational records into a spreadsheet. If I remember correctly, the cubes must be built with EIS.
In Dodeca, drill-through reports:
- Can execute from a data cell or member cell from any Essbase database, not just databases built with EIS.
- Can drill-through to any relational data source reachable from the Dodeca server via JDBC.
- Can optionally place data on the same worksheet as the Essbase data.
- Can be automatically formatted from an Excel template.
- Can have multiple levels of grouping, based on either column values or expressions, with group header and footer blocks based on Excel ranges.
In turn, group headers and footers:
- Can contain any Excel formula with references into the data range for that block; the formulas references are automatically expanded as the data is filled into the data range.
- Can have Excel grouping optionally applied to each data group. Excel grouping, which is available up to 8 levels deep, can be configured to show the group expanded or collapsed.
Drill-through reports can optionally support write-back operations (insert/update/delete) to the relational database, even within groups. Drill-through reports can also have POV selectors based on either Essbase or relational sources and can optionally be access without starting with a drill-through.
These are a few differences that come to mind..
Tim Tow
Oracle ACE Director
Applied OLAP, Inc
Scoring disabled. You must be logged in to score posts.