Avoiding the Attempt to Cross a Null Member in Function Error

Generally, the Attempt to cross a null member in function [@X] error is displayed in business rules that use an @concatenate or substring function to create a new member name and the resulting member is not present in the database in which the business rule is being executed.

Consider the example "Begbalance"=@member(@concatenate(@name(@parent(@currmbr("Company"))),"_Input"));, which writes the BegBalance value into the Company member with an _Input suffix for each Company member.

If the member is named Company1, there should also be a member Company1_Input for this formula to work. If, for example, a Company2 member is created and a corresponding Company2_Input member is not, the business rule fails with an attempt to cross a null member in function [@X] error.

To resolve this issue, the FIX statement around the @concatenate or @sibling syntax should be amended to exclude members that do not have the corresponding _Input members. In this example, you should find and exclude members of Company dimension that do not have corresponding Company_Input members or add Company_Input members to Company dimension members that do not have them.