Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Adding dim property - Error processing (Invalid column name)

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?

Not what you were looking for? Ask a question