I have a use case, can anyone suggest me if i can achieve it using Pentaho Community Edition? Any pointers will help.
i have a set of files coming in daily, let us say a files with product prices - i want to run few reports like :
- Average Prices of each of the different products
- Total Sales per each product ( how much each product made)
- Some Rules( configurable), if Product Price for a particular transaction is less than the Marketed Price (due to system issues or anything) i should be able to flag it through some alerts or some different report.
- All these reports shall be available on some dashboards .
Thanks a lot for your help!