Skip to Content
Former Member
May 04, 2012 at 03:41 AM

CtblDimAccount table is missing a Parent member


Hi folks,

We are on SAP BPC 7.0 MS version. In the Account dimension, we have only one hierarchy and we have added a new subtotal or a parent member in the Account dimension.

This is a HLEVEL5 member.

We do have another level down at HLEVEL6, and then follows the base members of this node.

The ctblDimAccount table does not have a row for the new member or subtotal that we have added.We are trying to fetch the base members of that parent member, in one of our procedures, and we figured that the ctblDimAccount is missing a row for this new member(ID) as the AGREGAT and hence the base members of this parents were not picked in the logic.

We did a full process of the Dimension while adding this new member. We also tried to process the applications and found no luck.

We also processed the Anaylsis services cube to update the OLAP, but we still do not have the ctbldimaccount table updated.

Can anyone tell us, if you have faced this issue earlier and what could be the possible solution ?

Any help in this regard is appreciated.

Thanks in Advance.