360Eyes Database Size Calculator

360Eyes Database Size Calculator

Overview

This article explains how to estimate the recommended size of the 360Eyes database so you can plan storage capacity before deployment.

Calculation Formula

Recommended 360Eyes DB size (GB) = B4 * B7 / 3 + B8 * (B5 / 10 + B4 / 3)

Excel version: =B4*B7/3+B8*(B5/10+B4/3)

Input Definitions

VariableDescription
B4Allocated size of the CMS database repository (tables + indexes), in GB.
B5Allocated size of the Audit database repository (tables + indexes), in GB.
B7Number of CMS snapshots you want to keep. CMS snapshots include BO metadata such as users, groups, security, universes, and reports.
B8Number of Impact Analysis snapshots you want to keep. Impact Analysis snapshots (UNIVERSE, CRYSTAL, DESKI, DESKI_INFOVIEW, WEBI) store object content and usage information from audit data. Enter the number of snapshots of the same type to keep. If retention differs by type, use the maximum value.

How to Calculate

  1. Collect B4 and B5 values in GB from your current SAP BO environment.
  2. Define your snapshot retention policy (B7 and B8).
  3. Apply the formula exactly as written.
  4. Round the result up and add a safety margin for growth.

Example

  • B4 = 25 GB
  • B5 = 80 GB
  • B7 = 6
  • B8 = 4

Calculation:

25 * 6 / 3 + 4 * (80 / 10 + 25 / 3)
= 50 + 4 * (8 + 8.33)
= 50 + 65.32
= 115.32 GB

Recommended provisioning in this example: at least 116 GB, plus additional buffer based on expected growth.

Recommendations

  • Use consistent units (GB) for all inputs.
  • Recalculate after major SAP BO content growth or retention changes.
  • Plan extra headroom for temporary peaks during snapshot processing.

    • Related Articles

    • How to expand Dataprovider SQL Query column in 360Eyes database

      Symptom When running 360Eyes Impact Analysis Reports (such as Report 52), users observe that the SQL query stored in the 360eyes_REPORTS.unx / Eye Document / Dataprovider / Dataprovider Sql Queryfield is incomplete, partial or truncated. This often ...
    • 360Plus backup repository size calculation

      Introduction This document explains how to estimate the size of the 360Plus backup repository. The retrieved information comes from performance tests ran in our Dev labs and customers environment. The numbers may change depending on SAP ...
    • 360Eyes evolution: from "standalone" to 360Suite web application

      Context On the meta-level, 360Eyes is part of 360Suite, a suite a modules working with BusinessObjects environments to help BI administrators with their day-to-day activities. On a practical level, the 360Eyes module itself has known changes over ...
    • Wrong collation for 360Eyes database on SQL Server

      Error Updating SQL Server Password in 360Eyes – Collation Issue Description After updating the SQL Server account password used in 360Eyes, attempts to update the password in the Eyes Configuration (Admin Page) result in a runtime error: [ERROR] ...
    • "DB003: No suitable driver found" when configuring 360Suite databases

      Symptoms When configuring 360Suite main database. When configuring 360Eyes database. When trying to create a 360Cast SQL source. When trying to create a 360View SQL Query. In any of these situations, when the database type was selected, the following ...