Skip to Content
Former Member
May 05, 2016 at 01:23 PM

Last Year & This Year comparison in one block from single query (WEBI)


Dear Experts

We have a requirement in Web Intelligence report to show last 2 years record for comparison of sales revenue (cross tab). We have single query which brings 2 years of data along with sales details.

DATA SOURCE: (columns look alike - sample)


All columns like quarter/month name can be matched but weekend date will be different for each year. We have used context operator to include them in same block but only managed to achieve different results of not wanted (see below).

I understand that this can be achieved using context operators but not sure where it is being missed. Can anyone suggest other options.

We use SAP Business Objects 4.0 SP10 and Oracle as database.




1.JPG (48.9 kB)
Data Souce.JPG (41.2 kB)
Opt.JPG (26.4 kB)