You can find the source data can be retrieved in the rules file. There are three data load options in “Data Load Values” tab, normally we use the setting of “Overwrite existing values”. If you find it hard, you can execute the following command to find the file for you: First, create a calculation script as below. And then click “Test Connect” for testing. Login to EAS, create a rules file for the target database.
|Date Added:||10 June 2015|
|File Size:||14.89 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Save the script and then execute, you can find the data output to the relational database successfully. If you have another name of the data source, copy this part eessbase configuration and then rename it. Click “OK” to confirm, and then you can find the new added data source. Roll down to the [Oracle Wire Protocol] part. Notify me of new posts by email. Click “Data source properties” to change dssbase data source properties, normally essbxse doesn’t need to change if the source is relational database.
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. There are three data load options in “Data Load Values” tab, normally we use the setting of “Overwrite existing values”.
For example, if you have no version field in the source data, but you have the “Version” dimension in the target Essbase cube.
Actually, the field names of the SQL table will be generated to the field name of the rules file automatically. 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.
Swetha Mukka February 11, at Now, we need to copy the lines from the Oracle Wire Protocol section and paste it to the end of the file. If your data source is Oracle, select DataDirect 7.
Oracle Essbase SQL Interface Guide
Now we can load the data from the relational database with the saved rules file. Switch to Security Tab, input the User Name here. You can click “Add Since we are using bit Essbase surely! And then click “Test Connect” for testing.
You can find the SQL data sources you created before. If you find it hard, you can execute the following command to find the file for you: It may need to change the essbasw for the flat file source. Input the Password and then click “OK” It shows the following message if the information is correct. The beginning section of the file contains the names of the various data sources that are set up in the file. The Oracle documentation tells us we can find the file in the following location:.
Then click “OK” to continue.
Then you need to dobc one of the version to load the data. Click “OK” to continue. About Vijay Kurian Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for companies for the last 12 years increment years if reading post We can export Essbase data to relational database with the following command.
ODBC Setup Essbase Unix
exsbase Vijay Kurian February 13, at 3: Oracle port number SID: Select the Combinations to clear from the Dimension list and then continue. Click “Field Properties” to have a check. Your email address will not be published.