ESSBASE ODBC DRIVER
Login to EAS, create a rules file for the target database. The one we care about, is the Oracle Wire Protocol data source. And then click “Test Connect” for testing. Then click “OK” to continue. There are three data load options in “Data Load Values” tab, normally we use the setting of “Overwrite existing values”. The beginning section of the file contains the names of the various data sources that are set up in the file.
|Date Added:||26 September 2004|
|File Size:||26.99 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Actually, the field names of the SQL table will be generated to the field name of the rules file automatically.
Oracle Essbase SQL Interface Guide
If you find it hard, you can execute the following command to find the file for you: First, create a calculation script as below. Now we can load the data from the relational database with the saved rules file. 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 Click “OK” to continue.
Input eswbase Password and then 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 eswbase.
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. Notify me of follow-up comments by email. Thanks for the kind words. For example, if you have no version field in the source data, but you have the “Version” dimension in the target Essbase cube.
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.
Leave a Reply Cancel reply Your email address will not be published. If essgase have another name of the data source, copy this part of configuration and then rename it.
Suspicious Activity Detected
It may need to change the settings for the flat file source. 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.
And then click “Test Connect” for testing. We can use a trusty text editor like vi to open the file. The one we care about, is the Oracle Wire Protocol data source.
Swetha Mukka February 11, at The Oracle documentation tells us we can find the file in the following location:. Then you need to specify one of the version to load the data.
As giving password in ODBC file is an confidential, can we have any workaround? Vijay Kurian February 13, at 3: Select the Combinations to clear from the Dimension list and then continue.
Login to EAS, create a rules file for the target database. Roll down to the [Oracle Wire Protocol] part. Switch to Security Tab, input the User Name here. If your data source is Oracle, select DataDirect 7.
Oracle Hyperion: Creating ODBC DRIVER
You can find the SQL data sources you created before. Hi, I am dssbase to remember, but, did you try leaving the password blank?
Vijay Kurian November 30, at Then click “OK” to continue. If we want to clear data combinations before the data load, switch to the “Clear Data Combinations” tab.