How to improve performance with 'Last Snapshot (xxx)' filters on 360Eyes reports

How to improve performance with 'Last Snapshot (xxx)' filters on 360Eyes reports

Symptom

How to improve performance on 'Last Snapshot (xxx)' filters in 360eyes reports?

Environment


  • 360Eyes
  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence 4.0
  • SAP BusinessObjects Business Intelligence 4.1
  • SAP BusinessObjects Business Intelligence 4.2
  • SAP BusinessObjects Business Intelligence 4.3


Cause

The queries generated by the filters Last Snapshot (xxx) add sub queries that can greatly increase the refresh time of the reports.
Here is an example of a report using Last Snapshot (mono CMS)









Resolution

The general idea for this work around is to separate the filter results from the main query. Then use the results as a filter for the main query

First we need to create a new query that we can name SNAPSHOT_ID.
Using the Snapshot Id object and the previous filter Last Snapshot (mono CMS) or (multi CMS).

See the example below:


Run this query, then we can go back in the main query and replace the Last Snapshot filter by a new filter on Snapshot Id.
This filter should be set to Equal to the Result from another query (select Snapshot Id from SNAPSHOT_ID query).

See the example below:



Keywords
WEBI, SQL, filter

Product

Product or Product version

  • 360Eyes

Languages

  • English 

    • Related Articles

    • How to use "Last Snapshot" filter to improve performance on 360Eyes reports

      It's always a good practice to use the Snapshot ID filter to prevent combining data from multiple snapshots, which could lead to incorrect results and fail to represent the system's current status. To accurately reflect the current status, you should ...

    • High WIPS memory consumption during a 360eyes WEBI Jobs

      Symptoms When running 360Eyes Webi jobs, the Web Intelligence Processing Servers (WIPS) can consume a lot of memory, potentially triggering alerts in SAP BusinessObjects or making the WIPSes unresponsive. Cause When exporting metadata of Webi ...

    • 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 ...

    • 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 ...

    • How to create a Webi Destination List

      Environment Product : 360Suite Other relevant information: Client wants to use a Dynamically updating Excel file as Destination List for Cast tasks Resolution Add the Excel Destination file to CMC Then create a WEBI document based on the Excel ...