<p>Hi Morris,<br>I would see whether I had selected all dimensions properly<br>or<br>I might be loading from my desktop (C:\Documents andSettings\login\Desktop)<br>in this case essbase don't like the spaces in the path. I wouldload it from the address which has no spaces<br>for example (C:\Hyperion\eas\client)<br><br>hope this helps<br><br>------------------------<br>firstname.lastname@example.org</p>
Look closely at your data load rule and make certain that all dimensions are mentioned. If there is no column, they should be added in the header definition.<BR><BR>It may be that you have a header that you don't need or that you SQL query doesn't bring in all of the columns called for in the rule. <BR><BR>The other potential cause to look at is member names that look numeric. Try to avoid them if at all possible by using a prefix or suffix so there is no question on whether the field is a member name or a numeric value.
<p>The last two columns in the laod are data fields. The lastis labeled as the data field. What happens if the previousfield loads a 0 value? Will this cause the problem Willdiscussed?</p><p> </p><p>Thanks</p><p>Duke Morris</p>
<p>A column in the rule file can be a<br>datafield or a<br>dimension or<br>you can ignore the field while loading.<br><br>if you want to load zeros before the loading actual values.<br>try creating two dataload rules and load zeros in the first ruleand load your data in the second rule.<br>hope this helps<br><br>----------------<br>email@example.com</p>