Invalid column name 'formula6'.

[Former Member]

This error occurs when i attempt to process the dimension. "- Error occurs during UpdateRemainData. Invalid column name 'formula6'."

When I uncheck the InApp FORMULAH1 and FORMULAH2 properties it process without error. When I have them as InApp, i get the error.

Any ideas why this happens?

thanks,

Agnes

[sorin_radulescu]

Hi,

Parent and Formula should not be added into dimension properties.

The system automatic is doing interpretation of excel file and it will know to add into cube these two properties.

So you don't need to add these properties into dimension property.

saying this it doesn't make sense to have InApp flag because the system is doing this by default.

Regards

Sorin Radulescu

[Former Member]

To add to Sorin's explanation -- the ParentH1, ParentH2, FormulaH1, FormulaH2 properties are controlled by the system -- you must add these columns to the member sheet, and you must NOT add them manually as properties.

It's never been clear to me exactly why it works this way, but that's how it works. There are a few other system-controlled properties (EvDescription, Calc, IsBaseMem, HIR, DimCalc are some, plus others that may vary by dimension type, such as TimeID) which are created as columns in the member table, but which don't need to be in the member sheet.

Also note, if you only have one hierarchy ParentH1 (but no ParentH2), then you should use Formula (not FormulaH1). If you have 2 hierarchies, then use FormulaH1 and FormulaH2. At least, that's been my experience on BPC 5.0 and 5.1. Things may have changed slightly on BPC 7 M, and I'd bet that this has changed in even greater ways on BPC 7 NW.

[Former Member]

I've succeeded in adding using the Formula properties in other Dimensions.

This particular dimension gets the error and I can't see why. I started out adding the Formula columns (there are two partent hierarchies) as Sorin indicated and this gave me the error. I deleted them and tried to manually add the properties and still get the error.

i have tried to minimize the number of InApp properties as suggested on a different post but this does not help.

[Former Member]

I noticed that the PARENTH1 and PARENTH2 properties were missing from the "Manage Dimension Property" window. When I added these it resolved the issue.

Strange, because I never had to manually add PARENT properties before.

thanks Tim, Sorin, for your suggestions.