If your BI team think the ETL may fail then they're not doing their job properly.
A properly bult data warehouse is the ideal way to provide the information you are after. It is bad practise to build reports off live OLTP systems.
Regards
Jamie
[quoted text, click to view] "Richard G" wrote:
> I'm wondering in general about the main purpose of BI. More specifically,
> should BI be used only for internal business intelligence, e.g., trends and
> analysis for senior managment and marketing, or can it also be appropriately
> used for daily operational reports? We have daily/weekly/monthly reports
> that need to go to third parties, for example, how many customers have
> signed up for our service via their service. The BI team is saying that
> these reports should not be produced from the data warehouses, but rather
> from the source systems. One of the reasons is because the ETL may fail,
> therefore the report may not be reliablly produced in a timely manner.
>
> Any input regarding your experience or opinion is appreciated.
>
> Richard
>
>