17.7 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.