Skip to Content
0
Former Member
May 20, 2015 at 11:05 AM

report query slow on PARENTH2

108 Views

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