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 In your 360Eyes Webi and Crystal job logs you are seeing data being truncated in EYE_DATAPROVIDER.DATAPROVIDER_SQL_QUERY Environment 360Eyes SAP BusinessObjects Enterprise XI 3.1 SAP BusinessObjects Business Intelligence 4.0 SAP ...

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

    • Error : "Can't instanciate Webi Factory"

      Symptom When running WEBI jobs, the following error may be encountered: 2014-11-14 15:05:00 +0100 INFO Creating hash for CUID-ShortName/path universe link: done 2014-11-14 15:05:00 +0100 INFO Getting url 2014-11-14 15:05:00 +0100 INFO Found url ...