Reporting and Analytics for Sales

Get Involved. Join the Conversation.

Topic

    Mitch Ostrenga
    Enabling Historical Snapshots - Does this cause performance...Answered
    Topic posted February 14, 2018 by Mitch Ostrenga, tagged BI Publisher, Opportunity, Sales, Trends 
    131 Views, 1 Comment
    Title:
    Enabling Historical Snapshots - Does this cause performance issues?
    Summary:
    Performance impact of enabling historical snapshots. Has anyone else encountered issues?
    Content:

    Hello,

    Our company is currently exploring enabling historical snapshots in Oracle Sales Cloud for reporting.

    For those who have enabled this feature, what performance impact has it caused, if any to the system?

     

    Thanks!

    Mitch

     

    Best Comment

    Hitesh Patel

    Hi Mitch,

    Thanks for the question.

    The snapshot is a different table that is populated based on the ESS job that is scheduled.
    So it doesn't impact the performance of the transactional system.

    However, the snapshot report performance is dependent on the records in this table.
    So data retention parameter needs to be set appropriately.

    Here's the documentation that provides details on the ESS job and the different parameters that are configured for taking the snapshots.
    https://docs.oracle.com/en/cloud/saas/sales/r13-update17d/facaa/sharing-analytics.html#FACAA1799403

    Hope this helps.

    Thanks,
    Hitesh

     

    Comment

     

    • Hitesh Patel

      Hi Mitch,

      Thanks for the question.

      The snapshot is a different table that is populated based on the ESS job that is scheduled.
      So it doesn't impact the performance of the transactional system.

      However, the snapshot report performance is dependent on the records in this table.
      So data retention parameter needs to be set appropriately.

      Here's the documentation that provides details on the ESS job and the different parameters that are configured for taking the snapshots.
      https://docs.oracle.com/en/cloud/saas/sales/r13-update17d/facaa/sharing-analytics.html#FACAA1799403

      Hope this helps.

      Thanks,
      Hitesh