LOAD DATA RULE ERROR

Hi to all,

I have a data load rule with the next error:

Data value encounter before dimension.....

The typical error when you have no properly map all your dimensions (itīs not the case, that the reason Iīm getting crazy) let me explain:

My flat file contains members as follow

Year Period Product .....
2008 001 1234125
2009 002 234335
2010 003 2134353

For evoiding duplicates member and following the Hyperion standard for members in dimension, I have added some prefix in order to create the dimensions as follows:

Year Period Product .....
A2008 M001 PROD-1234125
A2009 M002 PROD-234335
A2010 M003 PROD-2134353

The outline itīs perfect build.

When I try to map the flat file for a "data load" I add the prefix in the field I need and I have a "data load rule" as follows

Year Period Product Indicator(Sales for example)
A2008 M001 PROD-1234125 12313
A2009 M002 PROD-2343354 43500
A2010 M003 PROD-2134353 50000

the rule itīs validate and perfect to data load, but when I try to load I have the error ....."Data value encounter before dimension....."

I have modified the flat file for writing on fire the "prefix" I have for the members dimensions, and the data load rule works fine, the problem, CLIENT doesnīt want to modify the flat file.

Any help by construying the DATA LOAD RULE as client desires??


Many thanks to all.