Web Intelligence Datasource Analysis¶
Web Intelligence documents can be sourced from many different types of systems. RDBMS, SAP BW, NoSql, Hadoop, CSV and Excel are just some of the data sources a user may choose when creating a Webi dataprovider.
In this section we'll demonstrate different techniques understand Web Intelligence composition; what reports use Postgres? Which ones connect directly to a BEx query? Excel?
A1: What database engines are used by my Webi reports?¶
This analysis describes all Webi reports vs. database engine used across all dataproviders.
Understanding Webi dataprovider Complexity
Reports with excessive dataproviders can cause them to become slow because of additional processing required by the report engine to evaluate the report structure and variables therein. This
scenario allows users to adjust the
nbr_dps > n value to look for Webis with several dataproviders and can be a good starting point
to reduce complexity.