止まってしまうSQL文
INSERT INTO oo_meta.cube_1(
dim_01
,dim_02
,dim_03
,uriage_kingaku
,cost_kingaku
)
SELECT
temptime.key
,oo_dim_1_1.key
,oo_dim_2_1.key
,SUM(fact_sales.sales)
,SUM(fact_sales.costs)
FROM
public.fact_sales
,oo_meta.oo_dim_4_1
,oo_meta.oo_dim_4_1 AS temptime
,oo_meta.oo_dim_1_1
,oo_meta.oo_dim_2_1
WHERE
oo_dim_4_1.org_level = 3
AND oo_dim_1_1.org_level = 1
AND oo_dim_2_1.org_level = 3
AND fact_sales.time = oo_dim_4_1.time_date
AND oo_dim_4_1.par_key = temptime.key
AND oo_dim_4_1.min_val = '1'
AND fact_sales.chan_id = oo_dim_1_1.col_1
AND fact_sales.prod_id = oo_dim_2_1.col_1
GROUP BY
temptime.key
,oo_dim_1_1.key
,oo_dim_2_1.key
;
RE: キューブを作成すると途中で止まります。 (2007-10-08 14:56 by emunami #32684)