Error in Dimension Building using Rules File.December 2 2011 at 7:38 AM
No score for this post
from IP address 22.214.171.124
I am trying to create a Dimension using Dim Build Rules File and Text File.
The text file got member formulas for some members.
While loading, its giving some Warnings and Errors, but it is loaded and the Dimension is available.
When I looked into the Outline, Error is occuring at the members having formulas, saying "ERROR! FORMULA NOT LOADED".
But when I verify the formula for that member it is showing 'Formula verified successfully'.
There is no syntax error in the formula.
I did some R&D and came to know that it is giving error due to spaces in between the formula statements as all the statements are there in one line . When I split the statements line by line, its validating well and the error statement "ERROR! FORMULA NOT LOADED" is gone on the member.
My question here is, how can I overcome this error as I should not edit the Dim Build Text File and Outline manually. We are loading this through MAXL and it is Automated. It should load without errors.
Could anyone of you please help me in this regards.
Thanks in Advance
- Re: Error in Dimension Building using Rules File. - Robb Salzmann on Dec 2, 2011, 8:38 AM
- Re: Error in Dimension Building using Rules File. - Kumar on Dec 5, 2011, 8:16 AM
- Re: Error in Dimension Building using Rules File. - Jeff McAhren on Dec 5, 2011, 10:12 AM
- Are you sure there are spaces there? - Feiga Englander on Dec 20, 2011, 2:52 PM