1. Implementing Oracle Fusion Analytics Warehouse
  2. Resources
  3. Recommendations
  4. Recommendations for the Validating Stage

Recommendations for the Validating Stage

Carefully consider and apply these recommendations when planning your implementation.

Review the user acceptance process

In this task, evaluate and ensure that:
  • The Oracle Fusion Analytics customer success manager (CSM), where applicable, assisted in developing a successful user adoption plan.
  • The custom subject areas, visualizations, and data are available to appropriate user groups.
  • The unaffected prebuilt content was reaccepted.
  • You've validated the custom metrics.
  • Query response times are acceptable.
  • All users with all security profiles accepted the custom content.
  • You've explained the proper use of the shared folder structure to the authors.
  • Custom data is available to appropriate user groups.

Review the full and incremental data load performance

In this task, evaluate and ensure that:
  • You've scheduled enough time for the initial full data load in the production environment.
  • You've synchronized the custom data loads with the Fusion Analytics pipelines.
  • The full data load using prebuilt and custom data pipelines completed successfully within the required time constraint.
  • The incremental data loads using prebuilt and custom data pipelines completed successfully within the required time constraints.

Review that all queries meet performance requirements

In this task, evaluate and ensure that:
  • All custom SQL queries, including those using custom security predicates, return correct results within the required time frames for concurrent users.
  • The prebuilt SQL queries are unaffected by the customizations.

Review the capacity sizing

In this task, evaluate and ensure that:
  • You're able to monitor the Autonomous Data Warehouse memory, compute units (CPU), and storage capacity.
  • You're able to monitor the Analytics Cloud memory and CPU capacity.
  • The Autonomous Data Warehouse and Analytics Cloud sizing is sufficient for the projected data and user growth over the next 90 days.
  • The system raises proactive alerts when usage reaches thresholds that indicate capacity must be increased.
  • You've tested the capacity of the environment where customizations matches the capacity of the production environment.

Review the object and data security profiles

In this task, evaluate and ensure that:
  • Users with custom security profiles can access the same data in Fusion Analytics and the data source environment.
  • Users with custom security profiles can access appropriate subject areas, folders, and report content with proper read and write privileges.
  • Users with prebuilt security profiles aren't affected by the customizations.

Review the accuracy of your data

In this task, evaluate and ensure that:
  • The custom data in Fusion Analytics is as accurate as it is in the data's source system.
  • You've rerun the prebuilt data validations in the production environment and aren't affected by the customizations.

Review the functional requirements

In this task, evaluate and ensure that:
  • You're able to complete the custom visualizations and reports successfully and they return accurate data, hierarchies, and aggregations.
  • The custom metrics are validated.
  • The prebuilt critical metrics are validated and aren't affected by the customizations.
  • The custom subject areas are available for analysis.
  • The custom visualizations are available and informative.

Review the non-functional requirements

In this task, evaluate and ensure that:
  • Full and incremental data loads meet performance requirements.
  • Visualizations and reports meet performance requirements.
  • Network latency meets performance requirements.
  • Capacity and sizing are sufficient for the expected growth in the next 90 days.
  • You've secured the Fusion Analytics services from outside threats.
  • The Fusion Analytics services are creating and receiving network connections as required.
  • The user security profiles properly allow and restrict access to subject areas, visualizations, and data.

Review the success criteria

In this task, evaluate and ensure that:
  • You're able to attain the overall success criteria determined for the customization phase.
  • You're able to achieve user experience and satisfaction criteria.
  • You've met the customization phase timeline.
  • Any outstanding issues are within the allowable range of severity.