Five Knowledge Modules (KMs):
In the Operator, on the Execution tab, the statistics on Insert, Update, Delete, and Errors are shown as zero for all Essbase loads and extracts because of an Oracle Data Integrator limitation for nonrelational targets and sources. To see the correct statistics on success and failed rows:
A stack trace is displayed that shows the statistics.
org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
File "<string>", line 2, in ?
Essbase Metadata Writer Load Summary:
Number of rows successfully processed: 16
Number of rows rejected: 0
Of you can change the report statistics steps by:
odiRef.setNbInsert(stats.successRows)
odiRef.setNbErrors(stats.errorRows)
odiRef.setNbRows(stats.successRows+stats.errorRows)
On http://edelivery.oracle.com > Hyperion Performance Management and BI > (9.3.1) Media Pack v25 for Microsoft Windows (32-bit) :
Manually, enter the informations.
Using the Topology Manager, connect to a master repository and create a work repository named ODI_ESSBASE_SAMPLE
CREATE user essw IDENTIFIED BY essw;
GRANT connect, resource TO essw;