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?

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)

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 or Product version