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.