=== 2012-01-23 13:31:58,005 [l0-2] INFO  IDACall - Performing 1 operation(s)
=== 2012-01-23 13:31:58,006 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-23 13:31:58,007 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No public zero-argument method named '_summaryAdhocReport' found, performing generic datasource operation
=== 2012-01-23 13:31:58,008 [l0-2] INFO  SQLDataSource - [builtinApplication.summaryAdhocReport] Performing fetch operation with
	criteria: {ORIGIN_TYPE:"Airport",DESTINATION_TYPE:"Country",AIRLINE_TYPE:"Marketing",CLASS_TYPE:"NONE",ORIGIN_VALUE:["BOM"],DESTINATION_VALUE:["US"],TREND:"FALSE",REPORT_TYPE:"DIR",SHOW_ORIGIN:"FALSE",SHOW_DESTINATION:"TRUE"}	values: {ORIGIN_TYPE:"Airport",DESTINATION_TYPE:"Country",AIRLINE_TYPE:"Marketing",CLASS_TYPE:"NONE",ORIGIN_VALUE:["BOM"],DESTINATION_VALUE:["US"],TREND:"FALSE",REPORT_TYPE:"DIR",SHOW_ORIGIN:"FALSE",SHOW_DESTINATION:"TRUE"}
=== 2012-01-23 13:31:58,011 [l0-2] INFO  SQLDataSource - [builtinApplication.summaryAdhocReport] derived query: SELECT 
                #if($advancedCriteria.ORIGIN_TYPE == "Airport" || $advancedCriteria.SHOW_ORIGIN == "TRUE")
                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #elseif($advancedCriteria.ORIGIN_TYPE == "City")
                    AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #elseif($advancedCriteria.ORIGIN_TYPE == "Country")
                    AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE ,   AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #elseif($advancedCriteria.ORIGIN_TYPE == "Region")
                    AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #end
                #if($advancedCriteria.DESTINATION_TYPE == "Airport" || $advancedCriteria.SHOW_DESTINATION == "TRUE")
                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #elseif($advancedCriteria.DESTINATION_TYPE == "City")
                    AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE  , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #elseif($advancedCriteria.DESTINATION_TYPE == "Country")
                    AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #elseif($advancedCriteria.DESTINATION_TYPE == "Region")
                    AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #end
                #if($advancedCriteria.AIRLINE_TYPE == "Marketing")
                    , DOMAIRL
                #elseif($advancedCriteria.AIRLINE_TYPE == "Operating")
                    , OPAIRL
                #end
                #if($advancedCriteria.CLASS_TYPE == "Cabin Class")
                    , YIELD_CLASS_CODE
                #elseif($advancedCriteria.CLASS_TYPE == "Booking Class")
                    , BOOK_CLASS
                #end
                #if($advancedCriteria.TREND == "TRUE")
                    , DATES
                #end
                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
                ADB,AIRPORT_PAIR_DIM
                #if($advancedCriteria.CLASS_TYPE == "Cabin Class")
                , CLIENT_BOOKING_CLASS_DIM
                #end
             WHERE 
                ADB.ORIG=AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE AND ADB.DEST= AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE
                #if($advancedCriteria.REPORT_TYPE == "DIR")
                    AND
                        #if($advancedCriteria.ORIGIN_TYPE == "Airport")
                            ADB.ORIG
                        #elseif($advancedCriteria.ORIGIN_TYPE == "City")
                            AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE
                        #elseif($advancedCriteria.ORIGIN_TYPE == "Country")
                            AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE
                        #elseif($advancedCriteria.ORIGIN_TYPE == "Region")
                            AIRPORT_PAIR_DIM.WA_DEP_WA_CODE
                        #end
                    IN
                    #set ($count = 1)
                    #foreach($orig in $advancedCriteria.ORIGIN_VALUE)
                        #if($count != 1) ,
                        #else (
                        #end
                        #set ($count=$count+1) '$orig'
                    #end )
                    AND
                        #if($advancedCriteria.DESTINATION_TYPE == "Airport")
                            ADB.DEST
                        #elseif($advancedCriteria.DESTINATION_TYPE == "City")
                            AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE
                        #elseif($advancedCriteria.DESTINATION_TYPE == "Country")
                            AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE
                        #elseif($advancedCriteria.DESTINATION_TYPE == "Region")
                            AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                        #end
                    IN
                    #set ($count = 1)
                    #foreach($dest in $advancedCriteria.DESTINATION_VALUE)
                        #if($count != 1) ,
                        #else (
                        #end
                        #set ($count=$count+1) '$dest'
                    #end )
                #else
                    AND ( (
                    #if($advancedCriteria.ORIGIN_TYPE == "Airport")
                            ADB.ORIG
                        #elseif($advancedCriteria.ORIGIN_TYPE == "City")
                            AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE
                        #elseif($advancedCriteria.ORIGIN_TYPE == "Country")
                            AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE
                        #elseif($advancedCriteria.ORIGIN_TYPE == "Region")
                            AIRPORT_PAIR_DIM.WA_DEP_WA_CODE
                        #end
                    IN
                    #set ($count = 1)
                    #foreach($orig in $advancedCriteria.ORIGIN_VALUE)
                        #if($count != 1) ,
                        #else (
                        #end
                        #set ($count=$count+1) '$orig'
                    #end )
                    AND
                    #if($advancedCriteria.DESTINATION_TYPE == "Airport")
                            ADB.DEST
                        #elseif($advancedCriteria.DESTINATION_TYPE == "City")
                            AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE
                        #elseif($advancedCriteria.DESTINATION_TYPE == "Country")
                            AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE
                        #elseif($advancedCriteria.DESTINATION_TYPE == "Region")
                            AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                        #end
                    IN
                    #set ($count = 1)
                    #foreach($dest in $advancedCriteria.DESTINATION_VALUE)
                        #if($count != 1) ,
                        #else (
                        #end
                        #set ($count=$count+1) '$dest'
                    #end ) )
                    OR (
                        #if($advancedCriteria.ORIGIN_TYPE == "Airport")
                            ADB.DEST
                        #elseif($advancedCriteria.ORIGIN_TYPE == "City")
                            AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE
                        #elseif($advancedCriteria.ORIGIN_TYPE == "Country")
                            AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE
                        #elseif($advancedCriteria.ORIGIN_TYPE == "Region")
                            AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                        #end
                    IN
                    #set ($count = 1)
                    #foreach($orig in $advancedCriteria.ORIGIN_VALUE)
                        #if($count != 1) ,
                        #else (
                        #end
                        #set ($count=$count+1) '$orig'
                    #end )
                    AND
                        #if($advancedCriteria.DESTINATION_TYPE == "Airport")
                            ADB.ORIG
                        #elseif($advancedCriteria.DESTINATION_TYPE == "City")
                            AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE
                        #elseif($advancedCriteria.DESTINATION_TYPE == "Country")
                            AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE
                        #elseif($advancedCriteria.DESTINATION_TYPE == "Region")
                            AIRPORT_PAIR_DIM.WA_DEP_WA_CODE
                        #end
                    IN
                    #set ($count = 1)
                    #foreach($dest in $advancedCriteria.DESTINATION_VALUE)
                        #if($count != 1) ,
                        #else (
                        #end
                        #set ($count=$count+1) '$dest'
                    #end ) ) )
                #end
                #if($advancedCriteria.CLASS_TYPE == "Cabin Class")
                    AND ADB.DOMAIRL = CLIENT_BOOKING_CLASS_DIM.BOOKING_CLA_CARRIER_CODE AND ADB.BOOK_CLASS = CLIENT_BOOKING_CLASS_DIM.BOOKING_CLA_CLASS_CODE AND
                    CLIENT_BOOKING_CLASS_DIM.CLIENT_ID = 999
                #end
                AND ($defaultWhereClause)
             GROUP BY 
                #if($advancedCriteria.ORIGIN_TYPE == "Airport" || $advancedCriteria.SHOW_ORIGIN == "TRUE" )
                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE, AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #elseif($advancedCriteria.ORIGIN_TYPE == "City")
                    AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #elseif($advancedCriteria.ORIGIN_TYPE == "Country")
                    AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE ,   AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #elseif($advancedCriteria.ORIGIN_TYPE == "Region")
                    AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                #end

                #if($advancedCriteria.DESTINATION_TYPE == "Airport"|| $advancedCriteria.SHOW_DESTINATION == "TRUE")
                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #elseif($advancedCriteria.DESTINATION_TYPE == "City")
                    AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE  , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #elseif($advancedCriteria.DESTINATION_TYPE == "Country")
                    AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #elseif($advancedCriteria.DESTINATION_TYPE == "Region")
                    AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                #end
                #if($advancedCriteria.AIRLINE_TYPE == "Marketing")
                , DOMAIRL
                #elseif($advancedCriteria.AIRLINE_TYPE == "Operating")
                , OPAIRL
                #end
                #if($advancedCriteria.CLASS_TYPE == "Cabin Class")
                , YIELD_CLASS_CODE
                #elseif($advancedCriteria.CLASS_TYPE == "Booking Class")
                , BOOK_CLASS
                #end
                #if($advancedCriteria.TREND == "TRUE")
                    , DATES
                #end
             ORDER BY 
                BOOKINGS DESC
            

=== 2012-01-23 13:31:58,166 [l0-2] DEBUG SQLDataSource - [builtinApplication.summaryAdhocReport] Eval'd row count query: SELECT COUNT(*) FROM (SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
                ADB,AIRPORT_PAIR_DIM
                             WHERE 
                ADB.ORIG=AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE AND ADB.DEST= AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE
                                    AND
                                                    ADB.ORIG
                                            IN
                                                                 (
                         'BOM'
                     )
                    AND
                                                    AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE
                                            IN
                                                                 (
                         'US'
                     )
                                                AND (('1'='1'))
             GROUP BY 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE, AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                
                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                , DOMAIRL
                                                            ) work


=== 2012-01-23 13:32:01,008 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.summaryAdhocReport] Returning pooled Connection
=== 2012-01-23 13:32:01,573 [l0-2] INFO  SQLDriver - [builtinApplication.summaryAdhocReport] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM (SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
                 .....<same as above>
=== 2012-01-23 13:32:30,164 [l0-2] DEBUG SQLDataSource - [builtinApplication.summaryAdhocReport] JDBC driver windowed select rows 0->500, result size 500. Query: SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
                .....<same as above>
            
=== 2012-01-23 13:32:32,491 [l0-2] INFO  DSResponse - [builtinApplication.summaryAdhocReport] DSResponse: List with 500 items
=== 2012-01-23 13:33:21,077 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 40ms
=== 2012-01-23 13:33:21,099 [l0-2] DEBUG RPCManager - Processing 1 requests.
=== 2012-01-23 13:33:21,107 [l0-2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        ORIGIN_TYPE:"Airport",
        DESTINATION_TYPE:"Country",
        AIRLINE_TYPE:"Marketing",
        CLASS_TYPE:"NONE",
        ORIGIN_VALUE:[
            "BOM"
        ],
        DESTINATION_VALUE:[
            "US"
        ],
        TREND:"FALSE",
        REPORT_TYPE:"DIR",
        SHOW_ORIGIN:"FALSE",
        SHOW_DESTINATION:"TRUE"
    },
    operationConfig:{
        dataSource:"od",
        operationType:"fetch",
        textMatchStyle:"substring"
    },
    exportResults:true,
    exportAs:"ooxml",
    exportDelimiter:",",
    exportTitleSeparatorChar:"",
    exportFilename:"Results.xlsx",
    exportDisplay:"download",
    lineBreakStyle:"default",
    exportFields:[
        "AIRPP_DEPART_AIRP_CODE",
        "CTY_DEP_CITY_CODE",
        "CO_DEP_CNTRY_CODE",
        "WA_DEP_WA_CODE",
        "AIRPP_ARRIVAL_AIRP_CODE",
        "CO_ARR_CNTRY_CODE",
        "WA_ARR_WA_CODE",
        "DOMAIRL",
        "UnadjBookings",
        "bookings",
        "fare",
        "revenue"
    ],
    exportFieldTitles:{
        AIRPP_DEPART_AIRP_CODE:"Origin <br> Airport",
        CTY_DEP_CITY_CODE:"Origin <br> City",
        CO_DEP_CNTRY_CODE:"Origin <br> Country",
        WA_DEP_WA_CODE:"Origin <br> Area",
        AIRPP_ARRIVAL_AIRP_CODE:"Destination <br> Airport",
        CO_ARR_CNTRY_CODE:"Destination <br> Country",
        WA_ARR_WA_CODE:"Destination <br> Area",
        DOMAIRL:"Marketing <br> Airline",
        UnadjBookings:"Unadjusted <br> Bookings",
        bookings:"Bookings",
        fare:"AverageFare <br> InUSD ",
        revenue:"Revenue <br>  InUSD "
    },
    appID:"builtinApplication",
    operation:"summaryAdhocReport",
    oldValues:{
        ORIGIN_TYPE:"Airport",
        DESTINATION_TYPE:"Country",
        AIRLINE_TYPE:"Marketing",
        CLASS_TYPE:"NONE",
        ORIGIN_VALUE:[
            "BOM"
        ],
        DESTINATION_VALUE:[
            "US"
        ],
        TREND:"FALSE",
        REPORT_TYPE:"DIR",
        SHOW_ORIGIN:"FALSE",
        SHOW_DESTINATION:"TRUE"
    }
}
=== 2012-01-23 13:33:21,107 [l0-2] INFO  IDACall - Performing 1 operation(s)
=== 2012-01-23 13:33:21,109 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-23 13:33:21,109 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No public zero-argument method named '_summaryAdhocReport' found, performing generic datasource operation
=== 2012-01-23 13:33:21,110 [l0-2] INFO  SQLDataSource - [builtinApplication.summaryAdhocReport] Performing fetch operation with
	criteria: {ORIGIN_TYPE:"Airport",DESTINATION_TYPE:"Country",AIRLINE_TYPE:"Marketing",CLASS_TYPE:"NONE",ORIGIN_VALUE:["BOM"],DESTINATION_VALUE:["US"],TREND:"FALSE",REPORT_TYPE:"DIR",SHOW_ORIGIN:"FALSE",SHOW_DESTINATION:"TRUE"}	values: {ORIGIN_TYPE:"Airport",DESTINATION_TYPE:"Country",AIRLINE_TYPE:"Marketing",CLASS_TYPE:"NONE",ORIGIN_VALUE:["BOM"],DESTINATION_VALUE:["US"],TREND:"FALSE",REPORT_TYPE:"DIR",SHOW_ORIGIN:"FALSE",SHOW_DESTINATION:"TRUE"}
=
            
=== 2012-01-23 13:33:21,232 [l0-2] INFO  SQLDataSource - [builtinApplication.summaryAdhocReport] Executing SQL query on 'Oracle': SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
                .....<same as above>
            
=== 2012-01-23 13:33:24,182 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.summaryAdhocReport] Returning pooled Connection
=== 2012-01-23 13:33:24,745 [l0-2] INFO  SQLDriver - [builtinApplication.summaryAdhocReport] Executing SQL query on 'Oracle': SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM  .....<same as above>
=== 2012-01-23 13:34:33,388 [l0-2] INFO  DSResponse - [builtinApplication.summaryAdhocReport] DSResponse: List with 2175 items
=== 2012-01-23 13:35:46,502 [l0-2] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall/Results.xls', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1': Moz (Gecko) with Accept-Encoding header
=== 2012-01-23 13:35:46,547 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 12ms
=== 2012-01-23 13:35:46,566 [l0-2] DEBUG RPCManager - Processing 1 requests.
=== 2012-01-23 13:35:46,572 [l0-2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        ORIGIN_TYPE:"Airport",
        DESTINATION_TYPE:"Country",
        AIRLINE_TYPE:"Marketing",
        CLASS_TYPE:"NONE",
        ORIGIN_VALUE:[
            "BOM"
        ],
        DESTINATION_VALUE:[
            "US"
        ],
        TREND:"FALSE",
        REPORT_TYPE:"DIR",
        SHOW_ORIGIN:"FALSE",
        SHOW_DESTINATION:"TRUE"
    },
    operationConfig:{
        dataSource:"od",
        operationType:"fetch",
        textMatchStyle:"substring"
    },
    exportResults:true,
    exportAs:"xls",
    exportDelimiter:",",
    exportTitleSeparatorChar:"",
    exportFilename:"Results.xls",
    exportDisplay:"download",
    lineBreakStyle:"default",
    exportFields:[
        "AIRPP_DEPART_AIRP_CODE",
        "CTY_DEP_CITY_CODE",
        "CO_DEP_CNTRY_CODE",
        "WA_DEP_WA_CODE",
        "AIRPP_ARRIVAL_AIRP_CODE",
        "CO_ARR_CNTRY_CODE",
        "WA_ARR_WA_CODE",
        "DOMAIRL",
        "UnadjBookings",
        "bookings",
        "fare",
        "revenue"
    ],
    exportFieldTitles:{
        AIRPP_DEPART_AIRP_CODE:"Origin <br> Airport",
        CTY_DEP_CITY_CODE:"Origin <br> City",
        CO_DEP_CNTRY_CODE:"Origin <br> Country",
        WA_DEP_WA_CODE:"Origin <br> Area",
        AIRPP_ARRIVAL_AIRP_CODE:"Destination <br> Airport",
        CO_ARR_CNTRY_CODE:"Destination <br> Country",
        WA_ARR_WA_CODE:"Destination <br> Area",
        DOMAIRL:"Marketing <br> Airline",
        UnadjBookings:"Unadjusted <br> Bookings",
        bookings:"Bookings",
        fare:"AverageFare <br> InUSD ",
        revenue:"Revenue <br>  InUSD "
    },
    appID:"builtinApplication",
    operation:"summaryAdhocReport",
    oldValues:{
        ORIGIN_TYPE:"Airport",
        DESTINATION_TYPE:"Country",
        AIRLINE_TYPE:"Marketing",
        CLASS_TYPE:"NONE",
        ORIGIN_VALUE:[
            "BOM"
        ],
        DESTINATION_VALUE:[
            "US"
        ],
        TREND:"FALSE",
        REPORT_TYPE:"DIR",
        SHOW_ORIGIN:"FALSE",
        SHOW_DESTINATION:"TRUE"
    }
}
=== 2012-01-23 13:35:46,572 [l0-2] INFO  IDACall - Performing 1 operation(s)
=== 2012-01-23 13:35:46,573 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-23 13:35:46,573 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No public zero-argument method named '_summaryAdhocReport' found, performing generic datasource operation
=== 2012-01-23 13:35:46,574 [l0-2] INFO  SQLDataSource - [builtinApplication.summaryAdhocReport] Performing fetch operation with
	criteria: {ORIGIN_TYPE:"Airport",DESTINATION_TYPE:"Country",AIRLINE_TYPE:"Marketing",CLASS_TYPE:"NONE",ORIGIN_VALUE:["BOM"],DESTINATION_VALUE:["US"],TREND:"FALSE",REPORT_TYPE:"DIR",SHOW_ORIGIN:"FALSE",SHOW_DESTINATION:"TRUE"}	values: {ORIGIN_TYPE:"Airport",DESTINATION_TYPE:"Country",AIRLINE_TYPE:"Marketing",CLASS_TYPE:"NONE",ORIGIN_VALUE:["BOM"],DESTINATION_VALUE:["US"],TREND:"FALSE",REPORT_TYPE:"DIR",SHOW_ORIGIN:"FALSE",SHOW_DESTINATION:"TRUE"}

            
=== 2012-01-23 13:35:46,927 [l0-2] INFO  SQLDataSource - [builtinApplication.summaryAdhocReport] Executing SQL query on 'Oracle': SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
  .....<same as above>
            
=== 2012-01-23 13:35:50,094 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.summaryAdhocReport] Returning pooled Connection
=== 2012-01-23 13:35:50,702 [l0-2] INFO  SQLDriver - [builtinApplication.summaryAdhocReport] Executing SQL query on 'Oracle': SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
...<same as above>
            
=== 2012-01-23 13:36:53,611 [l0-2] INFO  DSResponse - [builtinApplication.summaryAdhocReport] DSResponse: List with 2175 items
=== 2012-01-23 13:37:22,682 [l0-2] INFO  RequestContext - URL: '/MarketIntelligence/sc/IDACall/Results.csv', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1': Moz (Gecko) with Accept-Encoding header
=== 2012-01-23 13:37:22,830 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 12ms
=== 2012-01-23 13:37:22,873 [l0-2] DEBUG RPCManager - Processing 1 requests.
=== 2012-01-23 13:37:22,881 [l0-2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        ORIGIN_TYPE:"Airport",
        DESTINATION_TYPE:"Country",
        AIRLINE_TYPE:"Marketing",
        CLASS_TYPE:"NONE",
        ORIGIN_VALUE:[
            "BOM"
        ],
        DESTINATION_VALUE:[
            "US"
        ],
        TREND:"FALSE",
        REPORT_TYPE:"DIR",
        SHOW_ORIGIN:"FALSE",
        SHOW_DESTINATION:"TRUE"
    },
    operationConfig:{
        dataSource:"od",
        operationType:"fetch",
        textMatchStyle:"substring"
    },
    exportResults:true,
    exportAs:"csv",
    exportDelimiter:",",
    exportTitleSeparatorChar:"",
    exportFilename:"Results.csv",
    exportDisplay:"download",
    lineBreakStyle:"default",
    exportFields:[
        "AIRPP_DEPART_AIRP_CODE",
        "CTY_DEP_CITY_CODE",
        "CO_DEP_CNTRY_CODE",
        "WA_DEP_WA_CODE",
        "AIRPP_ARRIVAL_AIRP_CODE",
        "CO_ARR_CNTRY_CODE",
        "WA_ARR_WA_CODE",
        "DOMAIRL",
        "UnadjBookings",
        "bookings",
        "fare",
        "revenue"
    ],
    exportFieldTitles:{
        AIRPP_DEPART_AIRP_CODE:"Origin <br> Airport",
        CTY_DEP_CITY_CODE:"Origin <br> City",
        CO_DEP_CNTRY_CODE:"Origin <br> Country",
        WA_DEP_WA_CODE:"Origin <br> Area",
        AIRPP_ARRIVAL_AIRP_CODE:"Destination <br> Airport",
        CO_ARR_CNTRY_CODE:"Destination <br> Country",
        WA_ARR_WA_CODE:"Destination <br> Area",
        DOMAIRL:"Marketing <br> Airline",
        UnadjBookings:"Unadjusted <br> Bookings",
        bookings:"Bookings",
        fare:"AverageFare <br> InUSD ",
        revenue:"Revenue <br>  InUSD "
    },
    appID:"builtinApplication",
    operation:"summaryAdhocReport",
    oldValues:{
        ORIGIN_TYPE:"Airport",
        DESTINATION_TYPE:"Country",
        AIRLINE_TYPE:"Marketing",
        CLASS_TYPE:"NONE",
        ORIGIN_VALUE:[
            "BOM"
        ],
        DESTINATION_VALUE:[
            "US"
        ],
        TREND:"FALSE",
        REPORT_TYPE:"DIR",
        SHOW_ORIGIN:"FALSE",
        SHOW_DESTINATION:"TRUE"
    }
}
=== 2012-01-23 13:37:22,881 [l0-2] INFO  IDACall - Performing 1 operation(s)
=== 2012-01-23 13:37:22,882 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-23 13:37:22,882 [l0-2] DEBUG AppBase - [builtinApplication.summaryAdhocReport] No public zero-argument method named '_summaryAdhocReport' found, performing generic datasource operation

            
=== 2012-01-23 13:37:22,969 [l0-2] INFO  SQLDataSource - [builtinApplication.summaryAdhocReport] Executing SQL query on 'Oracle': SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
                ADB,AIRPORT_PAIR_DIM
                             WHERE 
                ADB.ORIG=AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE AND ADB.DEST= AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE
                                    AND
                                                    ADB.ORIG
                                            IN
                                                                 (
                         'BOM'
                     )
                    AND
                                                    AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE
                                            IN
                                                                 (
                         'US'
                     )
                                                AND (('1'='1'))
             GROUP BY 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE, AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                
                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                , DOMAIRL
                                                             ORDER BY 
                BOOKINGS DESC
            
=== 2012-01-23 13:37:26,198 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.summaryAdhocReport] Returning pooled Connection
=== 2012-01-23 13:37:26,813 [l0-2] INFO  SQLDriver - [builtinApplication.summaryAdhocReport] Executing SQL query on 'Oracle': SELECT 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE  , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                    , DOMAIRL
                                                                    , SUM(UPAX) AS UNADJBOOKINGS, SUM(PAX_COUNT) AS BOOKINGS,ROUND(SUM(ADB_REVENUE)/SUM(PAX_COUNT),2) AS FARE,ROUND(SUM(ADB_REVENUE),0) AS REVENUE
             FROM 
                ADB,AIRPORT_PAIR_DIM
                             WHERE 
                ADB.ORIG=AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE AND ADB.DEST= AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE
                                    AND
                                                    ADB.ORIG
                                            IN
                                                                 (
                         'BOM'
                     )
                    AND
                                                    AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE
                                            IN
                                                                 (
                         'US'
                     )
                                                AND (('1'='1'))
             GROUP BY 
                                    AIRPORT_PAIR_DIM.AIRPP_DEPART_AIRP_CODE, AIRPORT_PAIR_DIM.CTY_DEP_CITY_CODE , AIRPORT_PAIR_DIM.CO_DEP_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_DEP_WA_CODE ,
                
                                    AIRPORT_PAIR_DIM.AIRPP_ARRIVAL_AIRP_CODE , AIRPORT_PAIR_DIM.CTY_ARR_CITY_CODE , AIRPORT_PAIR_DIM.CO_ARR_CNTRY_CODE , AIRPORT_PAIR_DIM.WA_ARR_WA_CODE
                                                , DOMAIRL
                                                             ORDER BY 
                BOOKINGS DESC
            
=== 2012-01-23 13:38:29,759 [l0-2] INFO  DSResponse - [builtinApplication.summaryAdhocReport] DSResponse: List with 2175 items
=== 2012-01-23 13:38:33,585 [l0-2] DEBUG DataExport - Export took 3529ms