You can find the SQL data sources you created before. Click “Data source properties” to change the data source properties, normally it doesn’t need to change if the source is relational database. As giving password in ODBC file is an confidential, can we have any workaround? Input the Password and then click “OK” It shows the following message if the information is correct. Now, we need to copy the lines from the Oracle Wire Protocol section and paste it to the end of the file. 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. And then click “Test Connect” for testing.
|Date Added:||14 June 2009|
|File Size:||16.9 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
If you scroll down a bit further, you will see the details of the Oracle Wire Protocol 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 oebc and then reload the data again, make sure there is no dirty data left in the target environment.
Your email address will not be published.
Oracle Hyperion: Creating ODBC DRIVER
Swetha November 28, at Now we can load the data from the relational database with the saved rules file. Since we are using bit Essbase surely!
We can export Essbase data to relational database with the following command. The beginning section of the file contains the names of the various data sources that are set up in the file.
It may need to change the settings for the flat file source. Click “Field Properties” to have a check.
ODBC Setup Essbase Unix
Click “OK” to continue. As giving password in ODBC file is an confidential, can we have any workaround? You can find the source data can be retrieved in the rules file. Swetha Mukka February 11, at Notify me of new posts by email.
Vijay Kurian February 13, at 3: The one we care about, is the Oracle Wire Protocol data source. Right click the target database, click “Load data Click “OK” to confirm, and then you can find the new added data source.
Then click “OK” to continue.
ShieldSquare reCAPTCHA Page
oebc Vijay Kurian November 30, at Save the script and then execute, you can find the data output to the relational database successfully. For example, if you have no version field in the source data, but you have the “Version” dimension in the target Essbase cube.
Hi, I am trying to remember, but, did you try leaving the password blank? If you find it hard, you can execute the following command to find the file for you: And then click “Test Connect” for testing. The Oracle documentation tells us we can find the file in the following location: Input the Password and then click “OK” It shows the following message if the information is correct.
Actually, the field names of the SQL table will be generated to the field name of the rules file automatically. Thanks for the kind words. But in some cases if there are obc dimension combination records in the source data and we want to aggregate the data together, we use “Add to existing values” option.
If your data source is Oracle, select DataDirect 7. Notify me of follow-up comments by email. Leave a Reply Cancel reply Your email address will not be published. Oracle port number SID: