How to make column chart with breaks – update – with high performance

Check list of all posts

This report is based on Ex post How to make column chart with breaks against ORACLE database.  It is intended to figure out solution to develop this report with best performance.

Sort by SortGroup, Sort Year, xCategory

	1	2	3	4	5	6	7	8	9	10	11	12
SortGroup	1	1	1	2	3	3	3	3	3	4	5	5
Year	2013	2014	2015	S1	2014	2014	2014	2014	2015	S2	2014	2015
xCategory	2013	2014	2015	S1	Q1 2014	Q2 2014	Q3 2014	Q4 2014	Q1 2015	S2	YTD 2014	YTD 2015

Filters: (Do not use cast, as it will use local process)

3 Year

to_char(to_number(nvl([Year data item], 0))+1)=?p_year?  OR

to_char(to_number(nvl([Year data item], 0))+2)=?p_year? OR

to_char(to_number(nvl([Year data item], 0))+3)=?p_year?

5 Quarters

( to_char(to_number(nvl([Year data item], 0))+0)=?p_year? and

[Quarter data item] <=?p_quarter? )

OR

( to_char(to_number(nvl([Year data item], 0))+1)=?p_year? and

[Quarter data item] >=?p_quarter? )

2 YTDs

( to_char(to_number(nvl([Year data item], 0))+0)=?p_year? and

[Quarter data item] <=?p_quarter? )

OR

( to_char(to_number(nvl([Year data item], 0))+1)=?p_year? and

[Quarter data item] <=?p_quarter? )