You can click “Add Right click the target database, click “Load data Leave this field empty. If you scroll down a bit further, you will see the details of the Oracle Wire Protocol data source. You can find the source data can be retrieved in the rules file.

Uploader: Kagarr
Date Added: 23 August 2005
File Size: 61.74 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 28952
Price: Free* [*Free Regsitration Required]

Essbae can use a trusty text editor like vi to open the file. Oracle port number SID: Then you need to specify one of the version to load the data.

Vijay Kurian February 13, at 3: First, create a calculation script as below.

If your odcb source is Oracle, select DataDirect 7. Thanks for the kind words. The Oracle documentation tells us we can find the file in the following location: Actually, the field names of the SQL table will be generated to the field name of the rules file automatically.

Need to configure the ODBC driver before the data load and export. Newer Post Older Post Home. Hi, I am trying to remember, but, did you try leaving the password blank? Click “Data source properties” to change the data source properties, normally it doesn’t need to change if the source is relational database. Since we are using bit Essbase surely!


In most cases, we would use OCI, but as far as I know, OCI does not support write back, to tables; something you would need to do for relational data exports.

Suspicious Activity Detected

If you scroll down a bit further, you will see the details of the Oracle Wire Protocol data source. Right click the target database, click “Load data But in some cases if there are duplicated dimension combination records in the source data and we want to aggregate the data together, we use “Add to existing values” option.

If we want to clear data combinations before the data load, switch to the “Clear Data Combinations” tab. Leave a Reply Cancel reply Your email address will not be published. Essbawe Vijay Kurian Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for essbwse for the last 12 years increment years if reading post And then click “Test Connect” for testing. Notify me of follow-up comments by email.

Leave essbae field empty.

Oracle Essbase SQL Interface Guide

Input the Password and ovbc click “OK” It shows the following message if the information is correct. Click “OK” to confirm, and then you can find the new added data source.

For the cases if the source data changed frequently and we need to reload data after the change, we will need to clear the existing data first and then reload the data again, make sure there is no dirty data left in the target environment.


Save the script and then execute, you can find the data output to the relational database successfully. Roll down to the [Oracle Wire Protocol] part.

Posted by Martin Xie at 6: For example, if you have no version field in the source data, but you have the “Version” dimension in the target Essbase cube. Notify me of new posts by email. Click “Field Properties” to have a check. Now, we need to copy the lines from the Oracle Wire Protocol section and paste it to the end of the file. Swetha November 28, at If you have another name of the data source, copy this part of configuration and then rename it.

There are three data load odb in “Data Load Values” tab, normally we use the setting of “Overwrite existing values”.