I'm attempting to add a hierarchy to the ACCOUNT dimension. Steps taken so far:
1) Added new hierarchy
2) Renamed formula column to formulah1 (within the spreadsheet)
3) Added the column FORMULAH2 (within the spreadsheet) and this is empty (no formulas)
4) Added the properties formulah1 and formulah2 to the dimension properties. Left Formula as a property but no column in the spreadsheet.
Version information
SAP BPC MS 7.0.116.04
Database: SQL 2008
I'm getting the following error when processing the dimension at the "Expanding Formulas" step - 'subscript out of range' this is followed by "Skip step of validating formulas because of the problem expanding formulas." during the Update OLAP portion. The new hierarchy is created correctly and the roll-up is fine for H2. There are also no formulas for H2. What do I need to do redefine the H1 formulas? or do I simply need to add the Formula column back into the spreadsheet with the same formulas as in FormulaH1?