on 05-21-2014 10:46 AM
Hi,
Using bo4 sp08 and
Query wont'r run due to group by clause not being generated correctly.
Should have extra line
group by DW.LATEST_PRODUCT_MV.PROD_NUM at bottom
but not generating it.
Any workaround for this?
Anyone know when going to b efixed?
SELECT
LISTAGG((
WHOLESALER_DIM_ONLY.BRA_NUM ), ', ')
WITHIN GROUP (ORDER BY (
WHOLESALER_DIM_ONLY.BRA_NUM )) "list",
DW.LATEST_PRODUCT_MV.PROD_NUM
FROM
WHOLESALER WHOLESALER_DIM_ONLY,
DW.LATEST_PRODUCT_MV,
MEDIA
WHERE
( MEDIA.PLIS_PLANT_NUM=WHOLESALER_DIM_ONLY.SPO_NUM AND MEDIA.PLIS_PLANNED_ON_SALE_DATE BETWEEN WHOLESALER_DIM_ONLY.SPO_EFF_DATE AND WHOLESALER_DIM_ONLY.SPO_EXP_DATE )
AND ( MEDIA.PROD_NUM = DW.LATEST_PRODUCT_MV.PROD_NUM and MEDIA.DIMENSION_KEY = MEDIA.PLIS_ID )
AND ( MEDIA.DIMENSION_KEY = MEDIA.PLIS_ID )
AND ( WHOLESALER_DIM_ONLY.DIMENSION_KEY = WHOLESALER_DIM_ONLY.SPO_ID )
AND
(
DW.LATEST_PRODUCT_MV.PROD_NUM = 4123
AND
MEDIA.ISS_ORIGINAL_YEAR_WEEK = 201410
)
/* @Variable('UNVNAME') - @Variable('BOUSER') - @Variable('DOCNAME') */
Thanks
The only workaround I can think of is to edit the SQL
Click on View Script then Use Custom Query Script in the edit query section and then add the GROUP By for yourself.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.