I have just added an additional level in my main hierarchy and on processing the AccountL dimension I get the below error:
- Error while update members of multiple hierarchy of AccountL
- Maximum stored procedure, function, trigger, or view nesting level exceeded (limit32)
I counted the level that I am inserted and it is only 7, is it possible that my alternate hierarchy levels are added to the main hierarchy levels? I have not included another level on any of the other hierarchies - only my first one.