Fixing Smart View Extension Issues

  • Ensure that the version of the Strategic Modeling Oracle Smart View for Office extension is the same as the Oracle Enterprise Performance Management Cloud version of the environment.

    To check the version of Strategic Modeling Smart View extension, in Smart View, select Options and then Extensions.

  • To improve performance, reduce the number of accounts in the Account View by creating account groups with smaller number of accounts and checking in the model. The model, when checked out or reopened, defaults to the Account View it was checked in with.
  • In some cases, turning off formatting in User Preferences improves performance. To access formatting preference setting:
    1. Click Start on the Strategic Modeling ribbon and select User Preferences.
    2. Click Accounts.
  • For Freestyle reports, better performance may be achieved by assigning cell attributes by sheet, row, or column instead of assigning attributes for each cell.
  • If a calculation reports a circular error, load the file in Smart View and troubleshoot the issue using the Where Used dialog box, which allows you to see where an account is used. You may also use the audit trail to track down this information.

    For example, the report may show that v0385:397/e in the first forecast period in May 2021 requires v0385:401/e in the same period. Repeated use of the Where Used dialog box may show the following information ending with v0385:397/e, which is where the calculation started:

    v0385:397/e is used by
    v0385:399/e is used by
    v1680:100/e is used by
    v0360:419/e is used by
    v0360:499 is used by
    v0360:500 is used by
    v0360:750 is used by
    v0360:999 is used by
    v0385:401/e is used by
    v0385:397/e