Reporting with Business Intelligence

Business intelligence, or BI, is an umbrella term that refers to a variety of software applications used to analyze an organization's raw data. For ClientSpace, BI specifically refers to the embedded Izenda Business Intelligence module that allows you to create on-demand reports from your ClientSpace data using a simple interface.

Business Intelligence provides the following:

Dashboards

Dashboards are a dynamic and interactive tool for viewing critical information from multiple sources in a single view. Users can hover over a report to get details or drill down into it for greater insight. Users can create and customize their own BI dashboards, then use them to print, save, share and send reports. Security options let you decide who can view or make edits.

Data Source

Data Source is the table, view, or data source report that provides data for your Report. Data sources may be joined using Foreign Key relationships to aggregate data. In Business Intelligence, data sources are configured on the Data Sources tab.

Fields

Fields are the individual data points available from a data source in Business Intelligence. An example is tblOrganization, which is the datasource, and Name, Address1, and City, would be fields from that datasource.

Filters

In the Filters tab, the fields of the table/view chosen in the Data Sources tab can be filtered so that only pertinent entries appear in the table.

Exporting

You can save the report to your list of reports. Keep in mind that the lists of categories are global, so please do not add new unless it is a must. Please use the ones already there.

Scheduling

Using Izenda BI, you can schedule and email reports and dashboards to a recipients list. Care should be taken when scheduling reports or dashboards, because the schedule has no way of adhering to the #CurrentUser or #CurrentWorkspace options for filtering, so each recipient of the report receives all of the data contained within the report based on any static filters that are saved on the report.

Why the IZENDA reporting engine? Izenda is a rich, flexible reporting tool that provides self-service reports and dashboards delivered over a browser including:

  • 100% browser-based AJAX Design Environment
  • Rich reports and dynamic dashboards
  • Great looking 3D charts, flexible grids, visual grouping
  • Summaries, subtotals, calculations, formats
  • Flexible and dynamic smart filters
  • Interactive linking and drill-down
  • Exports to all popular file formats
  • Native speed execution

Business Intelligence enables your organization to access data and manage it in the ClientSpace system. For a ClientSpace user to access data from BI reports, the user must have a Reporting Profile. For details on configuring security for Reporting Profiles for Business Intelligence, see Configuring security in Business Intelligence reporting.

User Guides

Topics in this section