Prophix Review

Microsoft multidimensional cubes has several disadvantages in write back solutions which results in poor performance. Client installation and updating is really easy.

Valuable Features

  • The ability to write back to a Microsoft multidimensional cube
  • Using workflows with accept/decline function and automate data management
  • Flexibility: Prophix's metadata is stored in a SQL server database and can be edited freely
  • Security: Being able to give users very specific availability in the program such as specific dimension members

Improvements to My Organization

When implemented in customers' environments we see budget and economic reporting is greatly improved because of automation and naturally more interest in key performance indicators.

Room for Improvement

Being able to work on Microsoft tabular cubes or perhaps your own technology. The Microsoft multidimensional cubes does have several disadvantages in write back solutions which results in poor performance.

Use of Solution

I've used it for four years.

Deployment Issues

Deployment is fairly simple. A few steps are needed before the main installation, but the wizard that follows the software is easy to use. As mentioned before, Prophix uses SQL Server databases to store its metadata and also Cube data which makes it really flexible.

Stability Issues

The software itself runs without issues, though Prophix is highly dependent on Microsoft multidimensional cube structure which can lead to critical errors. Overall Prophix does handle this fairly well and error handling is bearable.

Scalability Issues

Again Prophix is dependent upon Microsoft multidimensional cubes which creates several problems with scalability. Prophix itself doesn't have any issues with this from what I'm aware of.

Customer Service and Technical Support

Customer Service:

9/10 - Prophix is a Canadian company and doesn't have customer support in Denmark. The timezone difference makes live support difficult at times, but that's the only issue as the support is really good.

Technical Support:


Previous Solutions

I haven't used a previous solution.

Initial Setup

As mentioned under deployment, Prophix is fairly simple to set up. The client gets installed by a web service which makes client installation and updating really easy.

Implementation Team

We sell the solution to customers.


With the proper consulting and deployment customers get a ROI that is medium to high. Though Prophix does require administrators who take care of workflows, updating reports and so on, from what we experience customers are, overall, satisfied with the performance improvement of their budget management.

Pricing, Setup Cost and Licensing

As a company who deliver Prophix as a solution, we don't have these kind of numbers.

Other Solutions Considered

We only work with solutions that use Microsoft solutions and Prophix is the only complete solution in it's category.

Other Advice

Make sure your data quality is decent. Don't fill dimensions with over 1000 members. Keep your model simple and think it through before implementing it as you can't edit cubes when they first are made.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email