I want to develop a BI product and wondering about the 2 approaches below:
Build EDW or data mart layer in database and do not provide RPD as part of product.
This is so that customer can choose a reporting tool of their choice on top of data model provided at ETL layer.
Different customers may have varying reporting requirements and building a RPD to serve all may be a stupid idea.
Build EDW or data mart layer in database along with reporting layer (RPD).
This is with thinking that RPD built can be reused in multiple tools like OAS, OAC and OBIEE.
Also RPD can be built with basic common features which are applicable to all as initial template.
Customers can enhance (applying custom changes) on top of this initial template to build a relevant full fledged solution to them.
I understand any approach can be determined based on specific business needs, however in general may I invite different perspective from various SMEs what is
- possible pros and cons of these 2 approaches, recommendations and suggestions.
- What is benefit of RPD based reporting solution over non-RPD based reporting solution like Tableau reporting tool?
- Is this RPD symantics layer of BI solution?