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 

Last updated almost 2 years ago