System getting Slooooow

­­General Discussions
1

Hi Prophix group,

We are using Prophix cloud and it is getting slow when running reports recently. Can anyone share some solution. Thanks!

Gloria

2

Hi Gloria,
There are numerous potential causes to this from the design of the template to the amount of data the cube holds to other factors. Do you have a CSP program? If yes, would highly recommend you have a session with a PA consultant (your CSM can help set it up) and have them do a model audit at the least.

Hope this helps,
Navin

1 Like
3

Thanks for your recommendation Navin!

1 Like
4

In general you can make sure you’re doing some regular maintenance. I run a process to remove zero values and optimize the fact table weekly, which helped with some performance problems.

3 Likes
5

Hi - these Prophix Help Center articles might help you diagnose what could be impacting your report performance:

3 Likes
6

Great tips, thank you.

1 Like
7

We have schedule the Data Optimization Process to run every Sunday over night. This has helped improve the performance for us.

2 Likes
8

Thank you for this information.

9

Thanks for this info!

10

Thank you for the information.

11

Great tips, thank you.

12

Thanks for the tips.

13

I have been banging my head against the wall on an endless export of a small amount of data. The export section of the System Slowness link fixed my problem in 5 minutes. Great resource.

1 Like
14

I’ve done many if not all of these and still cannot open on of our budget reports. I have been working with Prophix on this and have a ticket I need to follow up on.