Can I have a two dimensions (i.e. Account & Product) in an Essbase load rule column?
Essbase is behaving oddly in that it is loading data to an incorrect dimension member. The load rule is loading data correctly to the account but not the product dimension.
You need to have a member from every dimension of your database to load the data.
You can only have one dimension defined in one column of a load rule.
If the number of columns (fields) in your data file doesn't match with the dimension count, then you might have to specify a default member of that particular dimension in the heading section of the load rule