Skip to Content
Former Member
May 26, 2010 at 01:40 PM

Multiple account hierarchies


Hi all,

I need to add another hierarchy to my account dimension so the total would be three hierarchies.

I have added PARENTH3 property to the dim and go to the member sheet. When I select Process dim I get the following error:

- Your Excel sheet or source table must include the FORMULAH3 property.

Now, I added this column to the member sheet and process the dimension again but the system return this message:

-The number of parentH columns cannot be different than the number of hierarchies.

However, I have this property defined and when I remove H3 columns from the member sheet, the system requires to add them.

Obviously I'm missing something here but don't seem to figure that out.

Any help would be appreciated.