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

Multiple account hierarchies

27 Views

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.

Thanks,

Madis