Adding dim property - Error processing (Invalid column name)

[Former Member]

BPC 5.1 SP3

I'm trying to add FormulaH1 and FormulaH2 properties to a user-defined dim containing two hierarchies. Properties are added and processed without any issues. However, when I subsequently try to process the member sheet, which has two new columns ("FormulaH1" and "FormulaH2"), I receive this error:

- Error occurs during UpdateRemainData. Invalid column name 'formula13'.

Column 13 in the member sheet contains the new "FormulaH2" property. (Column 12 has the "FormulaH1" property).

Any ideas what might be causing this error? I do see the new columns added to the mbr table. I've tried changing the property lengths and "In App" settings---get the same error when processing the member sheet.

Are there issues with added Formula properties to a user-def dim? Or, is there something else going on here?

[Former Member]

Answered my own question....

I only need to add one property called "Formula". BPC will then add the H1 and H2 "property" columns in the member sheet.