forgot to add 2nd query.
SELECT AL_PROD.CLNDR_DT, AL_PROD.TRIP_NAME, AL_PROD.ROUTE_NAME,
AL_PROD.DRIVER_NAME,AL_PROD.TOT_DIS_COV, AL_PROD.REGN_NUMBER FROM (SELECT
AL_TIME_DIM.CLNDR_DT,AL_TIME_DIM.CLNDR_DT,AL_PROD_RPT_FACT.VEHICLE_KEY,AL_DRIVER_DIM.DRIVER_ID,AL_TRIP_DIM.TRIP_NAME,AL_TRIP_DIM.TRIP_ID,AL_ROUTE_DIM.ROUTE_NAME,AL_ROUTE_DIM.ROUTE_ID,AL_DRIVER_DIM.FIRST_NAME
|| ' ' || AL_DRIVER_DIM.LAST_NAME AS
DRIVER_NAME,AL_PROD_RPT_FACT.TOT_DIS_COV,AL_VEHICLE_DIM.REGN_NUMBER FROM
AL_PROD.AL_PROD_RPT_FACT AL_PROD_RPT_FACT inner join AL_PROD.AL_TRIP_DIM
AL_TRIP_DIM on AL_PROD_RPT_FACT.TRIP_KEY=AL_TRIP_DIM.TRIP_KEY inner join
AL_PROD.AL_ROUTE_DIM AL_ROUTE_DIM on
AL_PROD_RPT_FACT.ROUTE_KEY=AL_ROUTE_DIM.ROUTE_KEY inner join
AL_PROD.AL_DRIVER_DIM AL_DRIVER_DIM on
AL_PROD_RPT_FACT.DRIVER_KEY=AL_DRIVER_DIM.DRIVER_KEY inner join
AL_PROD.AL_VEHICLE_DIM AL_VEHICLE_DIM on
AL_PROD_RPT_FACT.VEHICLE_KEY=AL_VEHICLE_DIM.VEHICLE_KEY inner join
AL_PROD.AL_TIME_DIM AL_TIME_DIM on
AL_PROD_RPT_FACT.TIME_KEY=AL_TIME_DIM.TIM_ID where
AL_VEHICLE_DIM.EFF_TO_DATE= date '9999-12-30') AL_PROD where
AL_PROD.REGN_NUMBER in ('TN18 AH4772') and AL_PROD.TRIP_ID in
(274,278,288,293,298,303) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and
'2017-06-20' order by AL_PROD.CLNDR_DT
On Thu, Jun 22, 2017 at 2:45 PM, suresh m <[email protected]> wrote:
> Hi,
>
> Facing an issue with passing no of arguments in Kylin Query.
>
> When I am querying with less than or eaqual to 5 arguements result is
> coming properly. If i pass more than 5 arguments result showing as 0 even
> though records there in cube.
>
> sending you the query as well,
>
>
> SELECT AL_PROD.CLNDR_DT, AL_PROD.TRIP_NAME, AL_PROD.ROUTE_NAME,
> AL_PROD.DRIVER_NAME,AL_PROD.TOT_DIS_COV, AL_PROD.REGN_NUMBER FROM (SELECT
> AL_TIME_DIM.CLNDR_DT,AL_TIME_DIM.CLNDR_DT,AL_PROD_RPT_FACT.
> VEHICLE_KEY,AL_DRIVER_DIM.DRIVER_ID,AL_TRIP_DIM.TRIP_
> NAME,AL_TRIP_DIM.TRIP_ID,AL_ROUTE_DIM.ROUTE_NAME,AL_ROUTE_
> DIM.ROUTE_ID,AL_DRIVER_DIM.FIRST_NAME || ' ' || AL_DRIVER_DIM.LAST_NAME
> AS DRIVER_NAME,AL_PROD_RPT_FACT.TOT_DIS_COV,AL_VEHICLE_DIM.REGN_NUMBER
> FROM AL_PROD.AL_PROD_RPT_FACT AL_PROD_RPT_FACT inner join
> AL_PROD.AL_TRIP_DIM AL_TRIP_DIM on
> AL_PROD_RPT_FACT.TRIP_KEY=AL_TRIP_DIM.TRIP_KEY
> inner join AL_PROD.AL_ROUTE_DIM AL_ROUTE_DIM on
> AL_PROD_RPT_FACT.ROUTE_KEY=AL_ROUTE_DIM.ROUTE_KEY inner join
> AL_PROD.AL_DRIVER_DIM AL_DRIVER_DIM on
> AL_PROD_RPT_FACT.DRIVER_KEY=AL_DRIVER_DIM.DRIVER_KEY
> inner join AL_PROD.AL_VEHICLE_DIM AL_VEHICLE_DIM on
> AL_PROD_RPT_FACT.VEHICLE_KEY=AL_VEHICLE_DIM.VEHICLE_KEY inner join
> AL_PROD.AL_TIME_DIM AL_TIME_DIM on
> AL_PROD_RPT_FACT.TIME_KEY=AL_TIME_DIM.TIM_ID
> where AL_VEHICLE_DIM.EFF_TO_DATE= date '9999-12-30') AL_PROD where
> AL_PROD.REGN_NUMBER in ('TN18 AH4772') and AL_PROD.TRIP_ID in
> (278,288,293,298,303) and AL_PROD.CLNDR_DT BETWEEN '2017-06-20' and
> '2017-06-20' order by AL_PROD.CLNDR_DT;
>
>
> in above query we can see only 5 arguments passing for trip_id. For this
> query result is coming properly and it showing 5 trips as well.
>
> But in below query passing 6 trip id's then result is showing as 0 trips
> and if i removed 1 trip id from the list then its showing 5 trips as usual.
>
>
>
> let me know is there any limitation of passing arguments. If yes let me
> know how resolve this.
>
>
>
> Regards,
>
> Suresh
>
>
>
