If Essbase cannot open the data source that you want to load, ensure that the following conditions are true:
The data source is open (for example, is someone editing the data source?).
Essbase can load only data sources that are not locked by another user or application.
The data source has the correct file extension.
Text files must have a .txt extension; rules files must have an .rul extension.
The data source name and the path name are correct.
Check for misspellings.
The data source is in the specified location.
Ensure that no one has moved or deleted the data source.
If you are using a SQL data source:
The connection information (such as the user name, password, and database name) is correct.
You can connect to the SQL data source without using Essbase.