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

report query slow on PARENTH2

Dear experts;

after creating a second hierarchy, data retrieval on this second hierarchy is very slow. Before we created this second hierarchy, all data was duplicated in default logic on dummy accounts. We now removed that script statement and adjusted dimension formula's. So, we can retrieve the correct data again using the second hierarchy and without duplication of data... however- - all reports using this second hierarchy are twice as slow as before, especially for a first data retrieval (second comes from memory).

We have a BPC MS 10 sp15 server installation and client EPM addin SP 20.

What can we do to speed up things - and restoring the old method doesn't sound like a best practise to me..

many thanks for your suggestions,

christophe

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 20, 2015 at 05:00 PM

    Hi Christophe,

    have you done a full optimize and a Modify Model with Process Model and Recreate Index after the described operations?

    Regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2016 at 10:22 AM

    Hi Christophe.

    Did you manage to solve the issue with data retrieval being slow when adding a second hierarchy?

    The reason I ask is because we seem to have the same problem and I haven't been able to find similar postings elsewhere. However, it only seems to be an issue when we have formula calculations in both account hierarchies. If we have calculations in only hierarchy 1 or hierarchy 2, no performance issue. We run BPC MS sp21 on the server and sp25.1 on the EPM addin.

    br Søren (DFDS A/S)
    .

    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.