<I hope this doesn't post twice but the 1st one never showed up>
I'm not sure why this is happening because the cube was working for weeks now, but it just now stopped and i'm having some issues reading the error. I'm hoping someone here can point me in the right direction. I'm getting 3 errors and 2 warnings.
Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. 0 0
Warning 2 Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Rpt Vr Flat Cmb Ih So of Dimension: Rpt Vr Flat Cmb Ih So from Database: sdw4, Record: 232495. 0 0
Error 3 Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. 0 0
Error 4 Errors in the OLAP storage engine: An error occurred while the 'Rpt Vr Flat Cmb Ih So' attribute of the 'Rpt Vr Flat Cmb Ih So' dimension from the 'sdw4' database was being processed. 0 0
Error 5 Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. 0 0
Here is the all query details:
sdw4
http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
sdw4
sdw4
Default
http://schemas.microsoft.com/analysisservices/2003/engine">
ProcessDefault
sdw4
Processing Database 'sdw4' failed.
Start time: 4/30/2007 9:24:32 AM; End time: 4/30/2007 9:45:07 AM; Duration: 0:20:35
Processing Dimension 'Rpt Vr Flat Cmb Ih So' failed.
Start time: 4/30/2007 9:24:32 AM; End time: 4/30/2007 9:45:07 AM; Duration: 0:20:35
Processing Dimension Attribute '(All)' completed successfully.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:33 AM; Duration: 0:00:00
Processing Dimension Attribute 'Site Nbr' completed successfully. 6 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:34 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[site_nbr] AS [dbo_rpt_vr_flat_cmb_ih_sosite_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Static Data Flag' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[static_data_flag] AS [dbo_rpt_vr_flat_cmb_ih_sostatic_data_flag0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Flag' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_flag] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_flag0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Site Db' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[site_db] AS [dbo_rpt_vr_flat_cmb_ih_sosite_db0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Nbr' completed successfully. 110693 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:25:09 AM; Duration: 0:00:36
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Cm Nbr' completed successfully. 1967 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[cm_nbr] AS [dbo_rpt_vr_flat_cmb_ih_socm_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Cm Name' completed successfully. 1571 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:37 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[cm_name] AS [dbo_rpt_vr_flat_cmb_ih_socm_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Cust Po' completed successfully. 99607 rows have been read.
Start time: 4/30/2007 9:24:33 AM; End time: 4/30/2007 9:24:49 AM; Duration: 0:00:16
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_cust_po] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_cust_po0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Due Date' completed successfully. 724 rows have been read.
Start time: 4/30/2007 9:24:34 AM; End time: 4/30/2007 9:24:38 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_due_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_due_date0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Ship Date' completed successfully. 638 rows have been read.
Start time: 4/30/2007 9:24:34 AM; End time: 4/30/2007 9:24:36 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_ship_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_ship_date0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Inv Date' completed successfully. 506 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:38 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_inv_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_inv_date0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Loc Nbr' completed successfully. 51 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:39 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_loc_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_loc_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Brk Nbr' completed successfully. 368 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:38 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_brk_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Nbr' completed successfully. 3404 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:40 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Name' completed successfully. 3071 rows have been read.
Start time: 4/30/2007 9:24:36 AM; End time: 4/30/2007 9:24:39 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Add Line1' completed successfully. 2533 rows have been read.
Start time: 4/30/2007 9:24:37 AM; End time: 4/30/2007 9:24:40 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line1] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line10_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Add Line2' completed successfully. 1089 rows have been read.
Start time: 4/30/2007 9:24:38 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line2] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line20_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp State' completed successfully. 113 rows have been read.
Start time: 4/30/2007 9:24:38 AM; End time: 4/30/2007 9:24:39 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_state] AS [dbo_rpt_vr_flat_cmb_ih_soshp_state0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp City' completed successfully. 1180 rows have been read.
Start time: 4/30/2007 9:24:38 AM; End time: 4/30/2007 9:24:40 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_city] AS [dbo_rpt_vr_flat_cmb_ih_soshp_city0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Zip' completed successfully. 1793 rows have been read.
Start time: 4/30/2007 9:24:39 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_zip] AS [dbo_rpt_vr_flat_cmb_ih_soshp_zip0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Xref Nbr' completed successfully. 2166 rows have been read.
Start time: 4/30/2007 9:24:39 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Shp Xref Name' completed successfully. 1938 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Channel Market Id' completed successfully. 18 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Channel Market Name' completed successfully. 18 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:41 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Corp Id' completed successfully. 148 rows have been read.
Start time: 4/30/2007 9:24:40 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Corp Name' completed successfully. 148 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Reg Id' completed successfully. 30 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Reg Name' completed successfully. 29 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:43 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Cur Brk Nbr' completed successfully. 199 rows have been read.
Start time: 4/30/2007 9:24:41 AM; End time: 4/30/2007 9:24:42 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Cur Brk Name' completed successfully. 191 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Accounting Channel Id' completed successfully. 8 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Accounting Channel Name' completed successfully. 8 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:45 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Chn Type Nbr' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:42 AM; End time: 4/30/2007 9:24:45 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_chn_type_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_chn_type_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Chn Type Desc' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:43 AM; End time: 4/30/2007 9:24:44 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[chn_type_desc] AS [dbo_rpt_vr_flat_cmb_ih_sochn_type_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Div Nbr' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:43 AM; End time: 4/30/2007 9:24:45 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_div_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_div_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Div Desc' completed successfully. 7 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:46 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[div_desc] AS [dbo_rpt_vr_flat_cmb_ih_sodiv_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Part' completed successfully. 3030 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:48 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_part] AS [dbo_rpt_vr_flat_cmb_ih_sopt_part0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Desc' completed successfully. 3073 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:49 AM; Duration: 0:00:05
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Um' completed successfully. 97 rows have been read.
Start time: 4/30/2007 9:24:44 AM; End time: 4/30/2007 9:24:47 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_um] AS [dbo_rpt_vr_flat_cmb_ih_sopt_um0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Qty Ord' completed successfully. 1998 rows have been read.
Start time: 4/30/2007 9:24:45 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:05
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ord] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ord0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Qty Ship' completed successfully. 2005 rows have been read.
Start time: 4/30/2007 9:24:45 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:05
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ship] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ship0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Sales' completed successfully. 54958 rows have been read.
Start time: 4/30/2007 9:24:46 AM; End time: 4/30/2007 9:24:59 AM; Duration: 0:00:13
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Sales Rolling Fx' completed successfully. 59546 rows have been read.
Start time: 4/30/2007 9:24:46 AM; End time: 4/30/2007 9:25:05 AM; Duration: 0:00:19
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_rolling_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_rolling_fx0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Sod Sales Raw Wout Fx' completed successfully. 57840 rows have been read.
Start time: 4/30/2007 9:24:47 AM; End time: 4/30/2007 9:25:05 AM; Duration: 0:00:18
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_raw_wout_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_raw_wout_fx0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Category Id' completed successfully. 9 rows have been read.
Start time: 4/30/2007 9:24:48 AM; End time: 4/30/2007 9:24:49 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_category_id] AS [dbo_rpt_vr_flat_cmb_ih_sopt_category_id0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Cat Desc' completed successfully. 9 rows have been read.
Start time: 4/30/2007 9:24:49 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_socat_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Label Nbr' completed successfully. 89 rows have been read.
Start time: 4/30/2007 9:24:49 AM; End time: 4/30/2007 9:24:50 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_label_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_label_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Label Desc' completed successfully. 87 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:51 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_label_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_label_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Sub Cat Nbr' completed successfully. 16 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_cat_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_cat_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Sub Cat Desc' completed successfully. 16 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[sub_cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_sosub_cat_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Group Nbr' completed successfully. 61 rows have been read.
Start time: 4/30/2007 9:24:50 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_group_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Group Desc' completed successfully. 60 rows have been read.
Start time: 4/30/2007 9:24:51 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_group_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_group_desc0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Sub Group Nbr' completed successfully. 138 rows have been read.
Start time: 4/30/2007 9:24:51 AM; End time: 4/30/2007 9:24:52 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_group_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Sub Group Name' completed successfully. 133 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:53 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_sub_group_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_sub_group_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Season' completed successfully. 42 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:53 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_season] AS [dbo_rpt_vr_flat_cmb_ih_sopt_season0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Hgpl' completed successfully. 6 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:55 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_hgpl] AS [dbo_rpt_vr_flat_cmb_ih_sopt_hgpl0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Size' completed successfully. 100 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:55 AM; Duration: 0:00:03
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_size] AS [dbo_rpt_vr_flat_cmb_ih_sopt_size0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Count' completed successfully. 71 rows have been read.
Start time: 4/30/2007 9:24:52 AM; End time: 4/30/2007 9:24:54 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_count] AS [dbo_rpt_vr_flat_cmb_ih_sopt_count0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Pt Xref Nbr' completed successfully. 2835 rows have been read.
Start time: 4/30/2007 9:24:53 AM; End time: 4/30/2007 9:24:55 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_pt_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_pt_xref_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Xref Name' completed successfully. 2633 rows have been read.
Start time: 4/30/2007 9:24:53 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:04
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_xref_name0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Pm Code' completed successfully. 6 rows have been read.
Start time: 4/30/2007 9:24:54 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_pm_code] AS [dbo_rpt_vr_flat_cmb_ih_sopt_pm_code0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Prod Line' completed successfully. 9 rows have been read.
Start time: 4/30/2007 9:24:55 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_prod_line] AS [dbo_rpt_vr_flat_cmb_ih_sopt_prod_line0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Mfg Site' completed successfully. 16 rows have been read.
Start time: 4/30/2007 9:24:55 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_mfg_site] AS [dbo_rpt_vr_flat_cmb_ih_sopt_mfg_site0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Apm Forecast Group' completed successfully. 129 rows have been read.
Start time: 4/30/2007 9:24:55 AM; End time: 4/30/2007 9:24:56 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[apm_forecast_group] AS [dbo_rpt_vr_flat_cmb_ih_soapm_forecast_group0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Pt Net Wt' completed successfully. 273 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[pt_net_wt] AS [dbo_rpt_vr_flat_cmb_ih_sopt_net_wt0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Project' completed successfully. 22 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_project] AS [dbo_rpt_vr_flat_cmb_ih_soidh_project0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Idh Samp Flag' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:57 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idh_samp_flag] AS [dbo_rpt_vr_flat_cmb_ih_soidh_samp_flag0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Ih So Curr' completed successfully. 3 rows have been read.
Start time: 4/30/2007 9:24:56 AM; End time: 4/30/2007 9:24:58 AM; Duration: 0:00:02
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_curr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_curr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'So Nbr' completed successfully. 111624 rows have been read.
Start time: 4/30/2007 9:24:57 AM; End time: 4/30/2007 9:25:14 AM; Duration: 0:00:17
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soso_nbr0_0]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Processing Dimension Attribute 'Rpt Vr Flat Cmb Ih So' failed. 230000 rows have been read.
Start time: 4/30/2007 9:25:12 AM; End time: 4/30/2007 9:45:07 AM; Duration: 0:19:55
SQL queries 1
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idcol] AS [dbo_rpt_vr_flat_cmb_ih_soidcol0_0],[dbo_rpt_vr_flat_cmb_ih_so].[site_nbr] AS [dbo_rpt_vr_flat_cmb_ih_sosite_nbr0_1],[dbo_rpt_vr_flat_cmb_ih_so].[static_data_flag] AS [dbo_rpt_vr_flat_cmb_ih_sostatic_data_flag0_2],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_flag] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_flag0_3],[dbo_rpt_vr_flat_cmb_ih_so].[site_db] AS [dbo_rpt_vr_flat_cmb_ih_sosite_db0_4],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_nbr0_5],[dbo_rpt_vr_flat_cmb_ih_so].[cm_nbr] AS [dbo_rpt_vr_flat_cmb_ih_socm_nbr0_6],[dbo_rpt_vr_flat_cmb_ih_so].[cm_name] AS [dbo_rpt_vr_flat_cmb_ih_socm_name0_7],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_cust_po] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_cust_po0_8],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_due_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_due_date0_9],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_ship_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_ship_date0_10],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_inv_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_inv_date0_11],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_loc_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_loc_nbr0_12],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_brk_nbr0_13],[dbo_rpt_vr_flat_cmb_ih_so].[shp_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_nbr0_14],[dbo_rpt_vr_flat_cmb_ih_so].[shp_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_name0_15],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line1] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line10_16],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line2] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line20_17],[dbo_rpt_vr_flat_cmb_ih_so].[shp_state] AS [dbo_rpt_vr_flat_cmb_ih_soshp_state0_18],[dbo_rpt_vr_flat_cmb_ih_so].[shp_city] AS [dbo_rpt_vr_flat_cmb_ih_soshp_city0_19],[dbo_rpt_vr_flat_cmb_ih_so].[shp_zip] AS [dbo_rpt_vr_flat_cmb_ih_soshp_zip0_20],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_nbr0_21],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_name0_22],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_id0_23],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_name0_24],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_id0_25],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_name0_26],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_id0_27],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_name0_28],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_nbr0_29],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_name0_30],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_id0_31],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_name0_32],[dbo_rpt_vr_flat_cmb_ih_so].[apm_chn_type_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_chn_type_nbr0_33],[dbo_rpt_vr_flat_cmb_ih_so].[chn_type_desc] AS [dbo_rpt_vr_flat_cmb_ih_sochn_type_desc0_34],[dbo_rpt_vr_flat_cmb_ih_so].[apm_div_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_div_nbr0_35],[dbo_rpt_vr_flat_cmb_ih_so].[div_desc] AS [dbo_rpt_vr_flat_cmb_ih_sodiv_desc0_36],[dbo_rpt_vr_flat_cmb_ih_so].[pt_part] AS [dbo_rpt_vr_flat_cmb_ih_sopt_part0_37],[dbo_rpt_vr_flat_cmb_ih_so].[pt_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_desc0_38],[dbo_rpt_vr_flat_cmb_ih_so].[pt_um] AS [dbo_rpt_vr_flat_cmb_ih_sopt_um0_39],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ord] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ord0_40],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ship] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ship0_41],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales0_42],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_rolling_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_rolling_fx0_43],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_raw_wout_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_raw_wout_fx0_44],[dbo_rpt_vr_flat_cmb_ih_so].[pt_category_id] AS [dbo_rpt_vr_flat_cmb_ih_sopt_category_id0_45],[dbo_rpt_vr_flat_cmb_ih_so].[cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_socat_desc0_46],[dbo_rpt_vr_flat_cmb_ih_so].[apm_label_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_label_nbr0_47],[dbo_rpt_vr_flat_cmb_ih_so].[pt_label_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_label_desc0_48],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_cat_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_cat_nbr0_49],[dbo_rpt_vr_flat_cmb_ih_so].[sub_cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_sosub_cat_desc0_50],[dbo_rpt_vr_flat_cmb_ih_so].[apm_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_group_nbr0_51],[dbo_rpt_vr_flat_cmb_ih_so].[pt_group_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_group_desc0_52],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_group_nbr0_53],[dbo_rpt_vr_flat_cmb_ih_so].[pt_sub_group_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_sub_group_name0_54],[dbo_rpt_vr_flat_cmb_ih_so].[pt_season] AS [dbo_rpt_vr_flat_cmb_ih_sopt_season0_55],[dbo_rpt_vr_flat_cmb_ih_so].[pt_hgpl] AS [dbo_rpt_vr_flat_cmb_ih_sopt_hgpl0_56],[dbo_rpt_vr_flat_cmb_ih_so].[pt_size] AS [dbo_rpt_vr_flat_cmb_ih_sopt_size0_57],[dbo_rpt_vr_flat_cmb_ih_so].[pt_count] AS [dbo_rpt_vr_flat_cmb_ih_sopt_count0_58],[dbo_rpt_vr_flat_cmb_ih_so].[apm_pt_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_pt_xref_nbr0_59],[dbo_rpt_vr_flat_cmb_ih_so].[pt_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_xref_name0_60],[dbo_rpt_vr_flat_cmb_ih_so].[pt_pm_code] AS [dbo_rpt_vr_flat_cmb_ih_sopt_pm_code0_61],[dbo_rpt_vr_flat_cmb_ih_so].[pt_prod_line] AS [dbo_rpt_vr_flat_cmb_ih_sopt_prod_line0_62],[dbo_rpt_vr_flat_cmb_ih_so].[pt_mfg_site] AS [dbo_rpt_vr_flat_cmb_ih_sopt_mfg_site0_63],[dbo_rpt_vr_flat_cmb_ih_so].[apm_forecast_group] AS [dbo_rpt_vr_flat_cmb_ih_soapm_forecast_group0_64],[dbo_rpt_vr_flat_cmb_ih_so].[pt_net_wt] AS [dbo_rpt_vr_flat_cmb_ih_sopt_net_wt0_65],[dbo_rpt_vr_flat_cmb_ih_so].[idh_project] AS [dbo_rpt_vr_flat_cmb_ih_soidh_project0_66],[dbo_rpt_vr_flat_cmb_ih_so].[idh_samp_flag] AS [dbo_rpt_vr_flat_cmb_ih_soidh_samp_flag0_67],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_curr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_curr0_68],[dbo_rpt_vr_flat_cmb_ih_so].[so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soso_nbr0_69]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
Error Messages 2
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Rpt Vr Flat Cmb Ih So of Dimension: Rpt Vr Flat Cmb Ih So from Database: sdw4, Record: 232495.
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Rpt Vr Flat Cmb Ih So of Dimension: Rpt Vr Flat Cmb Ih So from Database: sdw4, Record: 232495. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while the 'Rpt Vr Flat Cmb Ih So' attribute of the 'Rpt Vr Flat Cmb Ih So' dimension from the 'sdw4' database was being processed.
So is this saying if i run this query in sql server and read the result set of 232495 I should find my error? or is it saying something else?
Code Snippet
SELECT
DISTINCT
[dbo_rpt_vr_flat_cmb_ih_so].[idcol] AS [dbo_rpt_vr_flat_cmb_ih_soidcol0_0],[dbo_rpt_vr_flat_cmb_ih_so].[site_nbr] AS [dbo_rpt_vr_flat_cmb_ih_sosite_nbr0_1],[dbo_rpt_vr_flat_cmb_ih_so].[static_data_flag] AS [dbo_rpt_vr_flat_cmb_ih_sostatic_data_flag0_2],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_flag] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_flag0_3],[dbo_rpt_vr_flat_cmb_ih_so].[site_db] AS [dbo_rpt_vr_flat_cmb_ih_sosite_db0_4],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_nbr0_5],[dbo_rpt_vr_flat_cmb_ih_so].[cm_nbr] AS [dbo_rpt_vr_flat_cmb_ih_socm_nbr0_6],[dbo_rpt_vr_flat_cmb_ih_so].[cm_name] AS [dbo_rpt_vr_flat_cmb_ih_socm_name0_7],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_cust_po] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_cust_po0_8],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_due_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_due_date0_9],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_ship_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_ship_date0_10],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_inv_date] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_inv_date0_11],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_loc_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_loc_nbr0_12],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_brk_nbr0_13],[dbo_rpt_vr_flat_cmb_ih_so].[shp_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_nbr0_14],[dbo_rpt_vr_flat_cmb_ih_so].[shp_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_name0_15],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line1] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line10_16],[dbo_rpt_vr_flat_cmb_ih_so].[shp_add_line2] AS [dbo_rpt_vr_flat_cmb_ih_soshp_add_line20_17],[dbo_rpt_vr_flat_cmb_ih_so].[shp_state] AS [dbo_rpt_vr_flat_cmb_ih_soshp_state0_18],[dbo_rpt_vr_flat_cmb_ih_so].[shp_city] AS [dbo_rpt_vr_flat_cmb_ih_soshp_city0_19],[dbo_rpt_vr_flat_cmb_ih_so].[shp_zip] AS [dbo_rpt_vr_flat_cmb_ih_soshp_zip0_20],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_nbr0_21],[dbo_rpt_vr_flat_cmb_ih_so].[shp_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_soshp_xref_name0_22],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_id0_23],[dbo_rpt_vr_flat_cmb_ih_so].[apm_channel_market_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_channel_market_name0_24],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_id0_25],[dbo_rpt_vr_flat_cmb_ih_so].[apm_corp_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_corp_name0_26],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_id0_27],[dbo_rpt_vr_flat_cmb_ih_so].[apm_reg_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_reg_name0_28],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_nbr0_29],[dbo_rpt_vr_flat_cmb_ih_so].[apm_cur_brk_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_cur_brk_name0_30],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_id] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_id0_31],[dbo_rpt_vr_flat_cmb_ih_so].[apm_accounting_channel_name] AS [dbo_rpt_vr_flat_cmb_ih_soapm_accounting_channel_name0_32],[dbo_rpt_vr_flat_cmb_ih_so].[apm_chn_type_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_chn_type_nbr0_33],[dbo_rpt_vr_flat_cmb_ih_so].[chn_type_desc] AS [dbo_rpt_vr_flat_cmb_ih_sochn_type_desc0_34],[dbo_rpt_vr_flat_cmb_ih_so].[apm_div_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_div_nbr0_35],[dbo_rpt_vr_flat_cmb_ih_so].[div_desc] AS [dbo_rpt_vr_flat_cmb_ih_sodiv_desc0_36],[dbo_rpt_vr_flat_cmb_ih_so].[pt_part] AS [dbo_rpt_vr_flat_cmb_ih_sopt_part0_37],[dbo_rpt_vr_flat_cmb_ih_so].[pt_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_desc0_38],[dbo_rpt_vr_flat_cmb_ih_so].[pt_um] AS [dbo_rpt_vr_flat_cmb_ih_sopt_um0_39],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ord] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ord0_40],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_qty_ship] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_qty_ship0_41],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales0_42],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_rolling_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_rolling_fx0_43],[dbo_rpt_vr_flat_cmb_ih_so].[idh_sod_sales_raw_wout_fx] AS [dbo_rpt_vr_flat_cmb_ih_soidh_sod_sales_raw_wout_fx0_44],[dbo_rpt_vr_flat_cmb_ih_so].[pt_category_id] AS [dbo_rpt_vr_flat_cmb_ih_sopt_category_id0_45],[dbo_rpt_vr_flat_cmb_ih_so].[cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_socat_desc0_46],[dbo_rpt_vr_flat_cmb_ih_so].[apm_label_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_label_nbr0_47],[dbo_rpt_vr_flat_cmb_ih_so].[pt_label_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_label_desc0_48],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_cat_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_cat_nbr0_49],[dbo_rpt_vr_flat_cmb_ih_so].[sub_cat_desc] AS [dbo_rpt_vr_flat_cmb_ih_sosub_cat_desc0_50],[dbo_rpt_vr_flat_cmb_ih_so].[apm_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_group_nbr0_51],[dbo_rpt_vr_flat_cmb_ih_so].[pt_group_desc] AS [dbo_rpt_vr_flat_cmb_ih_sopt_group_desc0_52],[dbo_rpt_vr_flat_cmb_ih_so].[apm_sub_group_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_sub_group_nbr0_53],[dbo_rpt_vr_flat_cmb_ih_so].[pt_sub_group_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_sub_group_name0_54],[dbo_rpt_vr_flat_cmb_ih_so].[pt_season] AS [dbo_rpt_vr_flat_cmb_ih_sopt_season0_55],[dbo_rpt_vr_flat_cmb_ih_so].[pt_hgpl] AS [dbo_rpt_vr_flat_cmb_ih_sopt_hgpl0_56],[dbo_rpt_vr_flat_cmb_ih_so].[pt_size] AS [dbo_rpt_vr_flat_cmb_ih_sopt_size0_57],[dbo_rpt_vr_flat_cmb_ih_so].[pt_count] AS [dbo_rpt_vr_flat_cmb_ih_sopt_count0_58],[dbo_rpt_vr_flat_cmb_ih_so].[apm_pt_xref_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soapm_pt_xref_nbr0_59],[dbo_rpt_vr_flat_cmb_ih_so].[pt_xref_name] AS [dbo_rpt_vr_flat_cmb_ih_sopt_xref_name0_60],[dbo_rpt_vr_flat_cmb_ih_so].[pt_pm_code] AS [dbo_rpt_vr_flat_cmb_ih_sopt_pm_code0_61],[dbo_rpt_vr_flat_cmb_ih_so].[pt_prod_line] AS [dbo_rpt_vr_flat_cmb_ih_sopt_prod_line0_62],[dbo_rpt_vr_flat_cmb_ih_so].[pt_mfg_site] AS [dbo_rpt_vr_flat_cmb_ih_sopt_mfg_site0_63],[dbo_rpt_vr_flat_cmb_ih_so].[apm_forecast_group] AS [dbo_rpt_vr_flat_cmb_ih_soapm_forecast_group0_64],[dbo_rpt_vr_flat_cmb_ih_so].[pt_net_wt] AS [dbo_rpt_vr_flat_cmb_ih_sopt_net_wt0_65],[dbo_rpt_vr_flat_cmb_ih_so].[idh_project] AS [dbo_rpt_vr_flat_cmb_ih_soidh_project0_66],[dbo_rpt_vr_flat_cmb_ih_so].[idh_samp_flag] AS [dbo_rpt_vr_flat_cmb_ih_soidh_samp_flag0_67],[dbo_rpt_vr_flat_cmb_ih_so].[ih_so_curr] AS [dbo_rpt_vr_flat_cmb_ih_soih_so_curr0_68],[dbo_rpt_vr_flat_cmb_ih_so].[so_nbr] AS [dbo_rpt_vr_flat_cmb_ih_soso_nbr0_69]
FROM [dbo].[rpt_vr_flat_cmb_ih_so] AS [dbo_rpt_vr_flat_cmb_ih_so]
There has been quite a few posts on this forum regarding similar situations. The most improtant error you got is the first one:
Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idh_sod_sales, Value: 0. 0 0
Try to search for "The attribute key cannot be found" , you will get muliple threads describing the problem and the way to fix it. For instance this one http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=737482&SiteID=1
HTH
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
