6 Replies Latest reply: Apr 18, 2012 10:31 PM by 605905 RSS

    Validation lookup error

    605905
      Hi there,

      I am using FDM 11.1.2.1 with the Essbase adapter.

      I have set up a validation rule to report the entities that have been loaded but that are not at the bottom level of the ENTITY dimension.
      For that, I added an account "+LevelNumber+" is Essbase ACCOUNT dimension that returns the current entity level number.
      The rule is set as #ModeRule and the rule logic is "+|,,,,,,LevelNumber,,,,,,,,,,,,,,,,,,,,,|>0+"
      However when the validation is executed upon "Check" in the workflow and the report is generated, it returns a "LOOKUP ERROR" in the report value column and each entity has the status of "Error".

      Anybody faced this issue before?

      Thanks,

      Regis