Skip to Content
author's profile photo Former Member
Former Member

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 07, 2012 at 01:57 PM

    Hi Aparna,

    which sp are you using?

    Have you create an account with numeric ID?

    Did you see this parent in the CV and/or in the OLAP?

    Kind regards


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.