| Uploader: | Nizil |
| Date Added: | 18 May 2004 |
| File Size: | 20.21 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 94262 |
| Price: | Free* [*Free Regsitration Required] |
Login to EAS, create a rules file for the target database. Hi, I am trying to remember, but, did you try leaving the password blank? Save the script and then execute, you can find the data output to the relational database successfully.
The Oracle documentation tells us we can find the file in the following location: Esbase can export Essbase data to relational database with the following command. There are three data load options in "Data Load Values" tab, normally we use the setting of "Overwrite existing values".
Click "OK" to confirm, and then you can find the new added data source. Notify me of follow-up comments by email.
Suspicious Activity Detected
Roll down to the [Oracle Wire Protocol] part. You can find the source data can be retrieved in the rules file.
Click "Data source properties" to change the data source properties, normally it doesn't need to change if the source is relational database. Odbcc 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. Click "Field Properties" to have a check. If your data source is Oracle, select DataDirect 7. Vijay Kurian February 13, at 3: Input the Password and then click "OK" It shows the following message if the information is correct.
Vijay Kurian November 30, at The one we care about, is the Oracle Wire Protocol data source.
ODBC Setup Essbase Unix
Right click the target database, click "Load data It may need to change the settings for the flat file source. Since we are using bit Essbase surely! If you have another name of the data source, copy this part eessbase configuration and then rename it. And then click "Test Connect" for testing. Actually, the field names of the SQL table will be generated to the field name of the rules file automatically.
Then essabse need to specify one of the version to load the data. For example, if you have no version field in the source data, but you have the "Version" dimension in the target Essbase cube.
ShieldSquare reCAPTCHA Page
Select the Combinations to clear from the Dimension list and then continue. The beginning section of the file contains the names of the various data sources that are set up in the file.
If we want to clear data orbc before the data load, switch to the "Clear Data Combinations" tab. Need to configure the ODBC driver before the data load and export. We can use a trusty text editor like vi to open the file. Click "OK" to continue. First, create a calculation script as below. Posted by Martin Xie at 6: If you scroll down a bit further, you will see the details of the Oracle Wire Protocol data source. Switch to Security Tab, input the User Name here. In most cases, we would use OCI, but as far as I know, OCI does not support write back, to tables; something essgase would need to do for relational data exports.
Comments
Post a Comment