You need to create system “DSN” for loading data through SQL database.
System DSN is created successfully.
Now you need to create rule file for data load.
You have DSN for SQL server. Go to file and open “Open SQL”, and then you need to select Essbase server information server name, application name and database name.
You have build DNS “bisp”, so you need not to specify connection information again. You need to write SQL statement then click ok and retrieve. You need to enter username/password in SQL Connect and specify Essbase server information click ok.
Set data load properties for building rule file.
Validate the rule file
Save rule file.
There is import and export wizard utility in SQL server, through which you can import data from SQL database into text file. Browse text file and rule file and click ok for loading data in to Essbase.