OBIEE SQL Query - Last 90 Days minus Last 45 Days

Hi there,

I am trying to create an Insights Report that shows contacts with Email Open activity in the last 90 days. We are running into issues with the 200,000 row limit, so we want to split the report into 2 reports.

I was thinking Report A could use (TIMESTAMPADD(SQL_TSI_DAY, -45, CURRENT_DATE). This would give me the last 45 days worth of contacts.

We still need to cover contacts who opened greater than 45 days ago, but less than 90 days ago. For Report B, is it possible to write a query that would fetch the last 90 days worth of contacts, then minus last 45 days?