This content has been marked as final. Show 2 replies
<p>If I understand correctly, what I would do is ignore the firstrow completely (not even use it as a header). You can do this usingthe "number of lines to skip" parameter.</p><p> </p><p>Then on your dataload, the column holding "Jan" data Iwould have the load rule point to your January Time Member, and forthe column named "Feb" point to your February timemember.</p><p> </p><p>You may notice that if you choose to "Skip first row"or "ignore row" etc, that essbase doesn't grey out thatrow or hide it in any fashion in the load rule editor. Never fear,it should handle it properly when actually running the rule.</p>
Another option is to use the QUOTEMBRNAMES command in your report script and skip the load rule altogether. Of course that requires that all your member names line up in the target database, or that you can use the RENAME command in your report script to make them line up - RENAME will ignore the QUOTEMBRNAMES command, unfortunately and there appears to be no way to make the renamed version of the name quote-enclosed. If your target DB member names don't require quotes, then RENAME also works just fine.<BR><BR>You can possibly get rid of the first row in the results file with the SUPPAGEHEADING command in the report script.