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

Profit center dimension Losing hierarchy on excel side

Hi Experts,

On excel client side whenever we access Profit Center dimension in our expense model, it is loaded as flat structure and losing the hierarchy. This is happening even though there were no master data updates made to this dimension. We have to refresh metadata several times for this hierarchy to load correctly and sometimes even log off and log back in for it to load the hierarchy.

Did anyone experienced this kind of behavior. This is consistently happening only to the Profit center dimension. That has about 13,200 members.Please advise how to correct this issue.Any help is very much appreciated.

Our system configuration is BPC NW10.1, SP4 and Excel client is SP21.

Regards,

Sailu

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2016 at 05:49 AM

    Hi Sailu,

    The issue is with the context bar or member selector of dimension? To me it looks like Excel cache issues. Try to run UJA_REFRESH_DIMENSION_CACHE. Or it is best to upgrade your EPM add-in excel to latest SP and check whether the problem still exist!

    Regards,

    JP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 31, 2016 at 06:58 AM

    And BPC NW10.1, SP4 - is also very old!

    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.