Suggestions for reporting solution for Agile PLM

Hi Guys,

We are looking to improve the reporting solution for Agile and would like to get suggestions.

We mostly have multi level BOM reports which is the main reason to look for a better reporting solution.

The current reporting is a combination of the Standalone Process extension using the Agile API and we are using ACS export also to load the files to a staging DB and extract the reports from the same.

We are currently looking at the option of using the either of the below:

1. Use the ACS export to build the complete reporting solution. Export either AXML or PDX and load the data into the staging database. Use a reporting tool to create custom reports. Most likely we are going towards this.