i tried to export data from essbase to relational db but its through an error as sql connection failed.
how can i test the odbc connection in unix.
1) create load rules
and test ODBC like
select * from dual
2) check essbase application error log
i created one dsn and used that dsn in below calc script.
DATAEXPORT "DSN" "dsnName" "tableName" "userName" "password"
BUT ITS TROUGH AN ERROR AS SQL CONNECTION FAILED.
please tell how to test a odbc connection in unix env.
old q -> old a
Use EAS for creating Load Rules with SQL source.