There are three data load options in “Data Load Values” tab, normally we use the setting of “Overwrite existing values”. We can export Essbase data to relational database with the following command. Login to EAS, create a rules file for the target database. Notify me of follow-up comments by email. The Oracle documentation tells us we can find the file in the following location:. Vijay Kurian November 30, at
|Date Added:||17 May 2013|
|File Size:||17.24 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Swetha Mukka February 11, at Your email address will not be published. Thanks for the kind words. If your data source obdc Oracle, select DataDirect 7.
ODBC Setup Essbase Unix
As giving password in ODBC file is an confidential, can we have any workaround? 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. We can use a trusty text editor like vi to open the file.
Click “OK” to continue. Vijay Kurian February 13, at 3: 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 If we want ezsbase clear data combinations before the data load, switch to the “Clear Data Combinations” tab.
Right click the target database, click “Load data There are three data load options in “Data Load Values” tab, normally we use the setting of “Overwrite existing values”. Actually, the field names of the SQL table will be generated to the field name of the rules file automatically.
Suspicious Activity Detected
You can find the SQL data sources you created before. But in some cases if there are duplicated dimension combination esabase in the source data and we want to aggregate the data together, we use “Add to existing values” option.
The beginning section of the file contains the names of the various data sources that are set up in the file.
And then click “Test Connect” for testing. 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. Click odcb to confirm, and then you can find the new added data source.
Input the Password and then click “OK” It shows the following message if the information is correct. Login to EAS, create a rules file for the target database. Notify me of new posts by sssbase.
Then you need to specify one of the version to load the data. Click “Field Properties” to have a check. Click “Data source properties” to change the data source properties, normally it doesn’t need to change if the source is relational database. Notify me of follow-up comments by email.
ShieldSquare reCAPTCHA Page
You can click “Add If you scroll down a bit further, you will see the details of the Oracle Wire Protocol data source. Oracle port number SID: You can find the source data can be retrieved in the rules file. Select the Combinations to clear from the Dimension list and then continue. Newer Post Older Post Home.
Now we can load the data from the relational database with the saved rules file. Then click “OK” to continue.