21.6 Data Visualization

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.

Note:

• Users with only AFCS-DV groups will be redirected automatically to the Data Visualization home page post-login.
• Users mapped to both AFCS-BI and AFCS-DV groups will have the option to select between the Dashboard and Data Visualization pages.

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.

Note:

In the AFCS Standard Edition, backward flow is not applicable and therefore any action with respect to Balances, Computation and Revaluation are not supported. For more information, see the About Accounting Foundation Cloud Service- Standard Edition.