17.5 Data Visualization Reports
This section provides information about generating and viewing the Data Visualization reports. Visualizations enable you to dynamically explore datasets in a tabular or a graphical format, all within a single interface. You can visualize data from the staging entities and error tables.
Accounting Foundation Cloud Service (AFCS) provides data visualization dashboards which are pre-configured to see the raw data from the entities. You can view the data, create new visualization and see the error records. Data Visualization is supported for pre-built datasets and is best suited for scenarios where a query will return a few rows of the output. The following capabilities are present out-of-the box in AFCS:
- View subset of data that is loaded from the source systems.
- Aggregate queries with appropriate filters for use against any dataset.
- Raw data analysis for staging entities are loaded during data ingestion. Grid view to see raw data of the entities post data load.
- Error type identification. Grid view of the error entities in which erroneous records of staging entities are present.
- Query Console to run the SQL query comprising of temporary tables created at run time during data ingestion.
- You can create new datasets or reports in new folders.
Note:
Filters can display the datasets but refrain from displaying the entire dataset. Custom data elements introduced in the Data Catalog will not be available. Pre-seeded datasets and reports should not be customized.