Forum Stats

  • 3,854,634 Users
  • 2,264,392 Discussions
  • 7,905,743 Comments

Discussions

Capex error

649499
649499 Member Posts: 46
edited Nov 11, 2008 9:17AM in Planning and Budgeting
Hi all,
Iam getting the following error while launching BR
Detail:Cannot calculate. Analytic Server Error(1200323): Error parsing formula for [FIX STATEMENT] (line 51): expression expected after [,]

Please help me out,
Krish
Tagged:

Comments

  • 645783
    645783 Member Posts: 91
    Would need more info, it sounds like the BR coding has not opened and closed the FIX statement correctly.
  • 654822
    654822 Member Posts: 16
    Hi!

    I am facing a similar error, and here is the BR:

    FIX([Employees], [Scenario], [Version], [Department], [Year], "BegBalance", [Department], "No Project_ID")

    "Grade"
    (if ([Department]->[Employees]->"No Job_Code_Dim"->Jobcode== "No Entity"->"No Employee"->Jobcode->@CURRMBR(Job_Code_Dim))
    [Department]->[Employees]->"No Job_Code_Dim"->Grade = "No Entity"->"No Employee"->Grade->@CURRMBR(Job_Code_Dim);
    else
    [Department]->[Employees]->"No Job_Code_Dim"->Grade =[Department]->[Employees]->"No Job_Code_Dim"->Grade;
    endif)

    ENDFIX

    The problem seems to be in the FIX statement, as if I edit the FIX to FIX([Employees]), the rule validates fine but with mutiple dimensions in the FIX, it does not validate. I am validating against workforce Essbase App. (9.3.1)

    Any help will be greaty appreciated.

    Thanks!
  • 596223
    596223 Member Posts: 208
    Looking at the fix you are using DEPARTMENT twice that might be an issue. Also it would normally indicate that one of the variables is not validating correctly and therefore the FIX is incorrect.

    Hope this helps

    Andy King
    http://www.analitica.co.uk
  • 654822
    654822 Member Posts: 16
    Andy,


    Thanks for your reply. I had removed the second occurence of [Department], but that did not help. Your suggestion of Essbase not lliking the parameters seems to be the problem. I have removed the parameters in the fix and the first assignment statement that I had and then the rule runs fine.

    This is strange as the parameter values do not have any spaces either. And the assignment does not seem to work in the BR either. So will continue to search for a solution.

    Thanks for the lead.
    NJ
  • Hl-Oracle
    Hl-Oracle Member Posts: 23
    Coz you have fixed employees,department, you do not need to put them at left of equal mark.
  • 654822
    654822 Member Posts: 16
    edited Nov 11, 2008 9:17AM
    The problem was because of spaces in the member names in the FIX. As soon as I changed that, it worked!
This discussion has been closed.