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 way, 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. User 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 few rows of the output. Below mentioned 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 to be used against any dataset.
· Raw data analysis for staging entities are loaded during the Data Ingestion. Grid view to see the 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 the Run time during Data Ingestion.
· User can create new Datasets or reports in new folders.
NOTE:
1. Filters can display the Datasets but refrain from displaying entire Dataset.
2. Custom Data Elements introduced in The Data Catalog will not be available.
3. Pre-seeded Datasets and Reports should not be customized.
Data Visualization is an added functionality that will be delivered with AFCS. This functionality will be delivered via Analytics provided as part of your AFCS instance.
The following outcomes will be supported via Data Visualization:
1. Access to data in AFCS Catalog - Staging - please refer AFCS user guide and your instance's Catalog Browser for details on AFCS Catalog
2. Access to data in Staging - data movement error datasets. Data movement error datasets contain records of data that have read or load errors, for purposes of verification. Please refer AFCS User Guide for details on error handling upon data movement.
Data Visualization is intended to provide authorized users tactical access to data that is moved into AFCS data store. Such tactical access is solely for verification purposes, primarily in Test and Non-Production instances.
Data Visualization should not be used for any purpose other than what is stated above.
Data Visualization should not be used for extraction of data in any format.
Please use AFCS Data Extraction feature for this purpose – see Data Extraction for details.
Data Visualization provided with AFCS is limited to the following navigation paths:
1. Home (Data Sets, Dashboards & Reports)
2. Catalog
There are two User roles created for Data Visualization:
· AFCS-DVConsumer- Access Data Visualization Content for Catalog. This role is required for users to view the Staging and Error table details.
· AFCS-DVContentAuthor- Author Data Visualization Content for Catalog. This role is only required for users who wish to analyze the Data Ingestion error tables.
You can access the Data Visualization Reports by accessing the AFCS User Interface. When you sign on to the application, you are directed to the Home Page. You can navigate to view the data from any SLA’s Data Ingestion page. On the Home page, click Annuity (an example SLA ) and then click Data Ingestion. Under Data Ingestion for Annuity page, click View Data option. Click Go button to launch the Data Visualization window. On the Left Hand Side menu, click Catalog option. Under Shared Folders tab, select the Data Visualization Reports. You can view the data of the selected Error Entity or Staging Entity.
The Data Visualization reports consists of the staging table and its corresponding error table details. By default, As of Date is the filter applied for all the staging and error table entries.
You can query for the error logging schema using the Data Ingestion Query window. From the PMF pipeline execution log, you can retrieve the query and use it to fetch the final data used by Data Ingestion. The error records are loaded to source error logging entity and target error entity, which is causing the failure if a connector during the Data Ingestion fails, or if the connector passes the error records. You can view the error records using the SQL prompt to fetch the data of the error records.
"Data Ingestion Query Window” is listed and available as a Data Set in your service instance. This is accessible via Data Sets on the Home portal. It is also accessible via Data - Data Sets navigation path. You can click the Prepare option, select the Edit Definition button to view the Data Ingestion Query window. Please note that users may be taken to Visualise option by default.
If the Results user interface is offered, please navigate to Edit Definition to access the query window.
NOTE:
This function should solely be used if Data Ingestion errors are encountered and the logged query requires to be analyzed, as instructed by Oracle Support.
NOTE:
When the Data Ingestion process run is Success, the PMF execution log final select query cannot be used for fetching data in Data Ingestion Query window. Only when the Data Ingestion process run fails, the query can be used to fetch data from Data Ingestion Query window.