comments powered by
Using this blog as offline memory. Just ignore this post, if you’re not up to Essbase )
If you’re configuring DataDirect ODBC drivers on *nix system, be aware of following:
- There are 2 versions of odbc.ini file, one in 32bit driver folder, other in 64. 64 essbase uses 64 drivers.
- You should copy required odbc.ini file to essbasepath\bin. And you should create a symbolic link (ln -s) to odbc.ini file in essbase user home folder (/home/hyperion, for example)
- When creating a SQL data source rule file — ServerName corresponds to database server name, not essbase server name (type TNS name for oracle database)
Essbase SQL Interface Documentation
Metalink on search keywords ‘odbc.ini + essbase’ )