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
Scoring disabled. You must be logged in to score posts.