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

Slow performance of a PCM export

I've got a PCM model that only uses the Revenue table. The users make use of View Builder to look at results, and they also use predefined ESP files to export results to CSVs, which are subsequently loaded into another system. Performance through View Builder is fine, but exporting results is ridiculously slow.

To try to isolate the problem, I've done the following.

First I exported the existing model structure, without rules, to XML, and loaded into a new model. So now, I have a copy of my original model without any data and without any rules.

Then I created an Export Specification (ESP) file that includes a single selection on each dimension member of the exports a single record from the Revenue table to a CSV. The ESP file selects calculated results. It runs almost instantaneously, but (as expected) produces a file with no records in it.

Then I wrote a very simple Revenue rule (cellvalue=99) for the Revenue Type that I selected in the ESP file, and ran the export again. Suddenly, it takes forever to export - or more accurately, I let it run for 10 minutes and then gave up, and cancelled the export.

I then deleted the first rule, and wrote an identical rule for a completely different Revenue Type. I ran the export again, and once again the export took a long time before I gave up on it. Note: the model has one rule, and it's NOT for the one Revenue Type that I'm exporting.

So, to sum up, I have a model with no data, and one Revenue Type rule. If I try to export a single cell value FOR A DIFFERENT REVENUE TYPE, the export is unacceptably slow.

Other things that might be relevant:

  • The model has grown over time, in terms of the number of cost objects, and the performance of the exports has declined over time.
  • Whereas export takes a long time to export, View Builder gives me the same results almost instantaneously.
  • I can't use "Export View" to get the results out because the customer is still on PCM 7.5.
  • The model has 28 Versions, 23 Periods, 6 RCs, 824 CO1s, 62 CO2s, 4 CO3s, 26 CO4s, 5 CO5s and 125 Revenue Types, so yes, it has a lot of combinations.

It feels like the model might be hitting some limit in the environment.

Anyone got any thoughts?

Thanks in advance


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2014 at 07:47 PM

    OK, so I think I have a solution that improves things considerably. What I've done is move the dimensions around.

    My largest dimension (the one with 824 members) is now the Responsibility Center dimension, instead of CO1. For technical reasons to do with RestrictCombination functions and various rules (which I won't bore you with), I need certain dimensions to be in Versions and Periods, so I'm limited as to what options I have, and changing almost every rule in the model to swap the parameters around in the various PCM functions wasn't much fun, but it does seem like performance improves considerably if I minimise the number of cost objects combinations. Weird.

    Anyway, export time is now down to a respectable six minutes (the full model was taking hours before). Thanks Jef and Mike for chipping in.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 04:58 PM

    Do you know that is actually requesting the system to export 102.650.096.640 records?

    28 Versions * 23 Periods * 6 RCs * 824 CO1s * 62 CO2s * 4 CO3s * 26 CO4s * 5 CO5s * 1 Revenue Type = 102.650.096.640

    That rule will run for all possible combinations, unless you limit it somehow (like you probably did in view builder.

    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.