Error in the transport layer

Hello,

When i try to connect with excel with tcp/ip to an other computer where there is a cube, i've got this message:

'an error was encountered in the transport layer

Errors in the OLE DB provider

An error occured while loading the connection dialog box component for prompting'

I'm in mixed mode for the authentication and my user and password are in the olap administrator of the cube i want to browse.

I've got Windows XP sp2, SQL server 2005 Sp2 with SSAS developer edition, OWC 11.0 is installed and the OLE DB provider Analysis Service 9.0

Adriano.

There was an earlier thread on this topic that may provide some guidance:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=700734&SiteID=1

B.

sql

Error in Processing Cube while ROLAP Storage

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Nasir wrote:

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Above Cube runs these two Queries while processing:

Query 1 succeeds and Query 2 fails, here are both of them:

Query 1

CREATE

VIEW [Agg_Fact One_0_1_1_1_1_1] ( [Amount_0],[_1],[TimeID_2], [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS

(

SELECT SUM ( [dbo_Fact_One].[dbo_Fact_OneAmount0_0] )

AS [dbo_Fact_OneAmount0_0],

COUNT_BIG ( [dbo_Fact_One].[dbo_Fact_One0_1] )

AS [dbo_Fact_One0_1],[dbo_Fact_One].[dbo_Fact_OneTimeID0_2] AS [dbo_Fact_OneTimeID0_2], COUNT_BIG(*) AS [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a]

FROM

(

SELECT [Amount] AS [dbo_Fact_OneAmount0_0],1 AS [dbo_Fact_One0_1],[TimeID] AS [dbo_Fact_OneTimeID0_2]

FROM [dbo].[Fact_One]

)

AS [dbo_Fact_One]

GROUP BY [dbo_Fact_One].[dbo_Fact_OneTimeID0_2]

)

Query 2

CREATE

UNIQUE CLUSTERED INDEX [Agg_Fact One_0_1_1_1_1_1] ON [Agg_Fact One_0_1_1_1_1_1] ( [TimeID_2] )

Error in Processing Cube (Microsoft Analysis Services)

Hi,
I am processing one cube using Full Process option and it's giving
following error.

Analysis Server Error: Internal error [Object does not exist] '11948' ;
Time:1/8/2004 6:11:11 PM

Error(-2147221421): Internal error (Internal error [Object does not
exist] '11948' ); Time:1/8/2004 6:11:11 PM

Can anyone help me on this.If you are using shared dims, process your dimensions, then the cube and see if that fixes it.

GO COLTS!!

HTH

Error in Merging partitions in AS 2005 from DSO

I have the following code to incrementally process a cube (this is not the full code. I am omiting error handling and other less relevant parts). Basically, I clone the existing partition, process the clone, and then merge it back into the original partition:

Set dsoCube = m_dsoDatabase.MDStores.Item(cubeName)
For Each wrkDimension In dsoCube.Dimensions
m_dsoDatabase.Dimensions(wrkDimension.Name).process processDefault
Next
Set dsoPartition = dsoCube.MDStores.Item(cubeName)
Set dsoClonePartition = dsoCube.MDStores.AddNew(tmpPartition)
dsoPartition.Clone dsoClonePartition, cloneMinorChildren
dsoClonePartition.SourceTableFilter = "Tranno > GetMaxTranNo(cubeName)" ' simplification
dsoClonePartition.process processDefault
dsoPartition.Merge tmpPartition ' Error occurs in SA 2005
dsoPartition.SourceTableFilter = dsoClonePartition.SourceTableFilter
dsoPartition.Update

This works fine in AS 2000. In AS 2005, an error at the step of merging the two partitions is:
Partitions cannot be merged because the source and target partitions have a different number of aggregations.

Manually merging the temporary partition back into the main one from Management studio works without errors.

Any idea on what this might be?

Thanks,
Boris Zakharin, MCAD

Looks like a bug to me.
Please go ahead and file it using http://connect.microsoft.com/sql

I would also like to seize the opportunity and make a little plea for anyone trying to develop DSO applications against Analysis Services 2005:
Please , take a good look at your requirements and at your reasoning to why you are trying to invest in new application code that uses outdated object model. DSO running against AS2005 is there for supporting legacy applications mostly. I would highly discourage anyone from heavily investing in new development using DSO.
Take a look at .NET development using AMO. It is greatly superior to DSO.

HTH.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Done. I was just wondering, would there be a hotfix for this in the near future. If not, is there a workaround? We need to tell our customers why parts of our software are incompatible with SQL Server 2005.

As far as AMO goes, we must still support customers with SQL 2000 with the same version of our code, so AMO would seem to not be an option. Also, We have multiple utilities written in VB6 that deal with OLAP (In addition to our main ASP.NET web application), so porting to AMO would require rewriting large chunks of code in .NET including code that is unrelated to AS at all.

Thanks for your time,
Boris Zakharin, MCAD
P/A, Metavante Risk and Compliance|||

I am afraid I cannot speak of any dates or avaliablity of any particular fix.
If you have immideate need it is definitely better contact product support directly.

I completely understand the reasoning for this current DSO usage. Only... there should come a moment and you should be switching to AMO. In my humble opinion you should make all the effort and switch as soon as you can. Any application you developing applications using DSO is the the application you'll have to rebuild using AMO.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Error in deployment.

<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.

Error in Deploying Cube

I am working on a BI prototype development. Everything seemed working smoothly and, all of a sudden, I got the following error in deploying the changes made to some properties of a dimension:

Error - 1056964586: Internal error: An unexpected exception occured.

Error - 1055653859: Errors in the metadata manager. An error occuurred when loading the Slot Game Daily Fact measure group, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\BI PoC Slot.0.db\BI PoC 1.96.cub\Slot Game Daily Fact.106.det.xml.'

Since I could not find the way to work around this error, I created a new project and could deploy the new changes without any error for a while. Again, suddenly, I got the same type of error as listed above and can no longer proceed with my development work.

Grateful if someone could advise me how to get rid of the errors and prevent it from heppening again.

This looks like a case of data corruption.

Please file your case with http://connect.microsoft.com/sql. Make sure your are running latest service pack SP2.

Please post it in this forum or on connect site if you ever get the same problem again.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Error in deploying cube

Hi,

I'm getting an internal exception error while deploying the solution. The error is as follows -

"Error - 1056964586: Internal error: An unexpected exception occured."

When deployed for the first time, it went through and subsequent changes processed as well. For a specific reason I had to delete the database and redeploy.

From then on I'm getting this error. Earlier threads said try SP2, still the error persists.

Had to share this solution with my teammate as well and even he is getting this error, even though he is deploying it for the first time.

Any help on this would really help, otherwise I would have to recreate the entire solution, changes etc.

Thanks in advance.

Hi,

I do not know this sepcific error message or number.

But I now - you cannot deploy the cube if you have a role with a user which does not exists. Remove incorrect users from you roles (or try remove all and then deploy again)

I had such issues in most of my deployment scenarios.

Else - does the message come from deployment or processing - try only deploy the solution and do not process.

HANNES

|||

Hi Hannes,

I dont have any user roles defined. Also I'm the administrator of the system and the Analysis Services server as well.

And the error comes when I'm trying to deploy the solution.

|||

"Unexpected Exception" errors usually indicate a bug in the server, and we would require either a crash dump or a copy of the solution in order to diagnose exactly why we're hitting it. I'd recommend opening a support ticket if that option is available to you.

- Brad

|||

I was able to track down the problem in my case.

I had 3 cubes and there was 2 relationships (linked objects), viz. Cube 1 refering Cube 2 and Cube 2 refering Cube 3.

When I removed one of the references, the deployment and processing went through.

I guess this is a limitation not to have such kind of references.

-

Vivek C.

error in as with rs samples

hi,
I'm using the sample RS code for my cube. I just copied
from the sample code and replaced the cube name with my
cube name ...its working fine with the code given by them
and for microsoft's reports. but when i run my reports its
giving an error msg like ... The expression for the
query 'Selection' contains an error: [BC30648] String
constants must end with a double quote.
here selection is my dataset name... i'm running this thru
report designer in vs.net... could any one tell me wht's
my wrong ...
=IIF(Parameters!pParamIn.Value="", "WITH MEMBER
MEASURES.DIMNAME AS 'NULL' MEMBER MEASURES.UNAME AS 'NULL'
MEMBER MEASURES.PUNAME AS 'NULL' MEMBER MEASURES.LABEL
AS 'NULL' MEMBER MEASURES.SYMBOL AS 'NULL' SELECT
{MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
MEASURES.SYMBOL, MEASURES.PUNAME} ON 0 FROM [Purchase
Order]", "WITH MEMBER MEASURES.DIMNAME AS '" & Parameters!
pMember.Value & ".DIMENSION.NAME' MEMBER MEASURES.UNAME
AS '" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER.UNIQUENAME' MEMBER
MEASURES.PUNAME AS '" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER.PARENT.UNIQUENAME' MEMBER
MEASURES.SYMBOL AS 'IIF(" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER IS " & Parameters!
pMember.Value & ", 1, IIF(COUNT(INTERSECT({" & Parameters!
pMember.Value & ".DIMENSION.CURRENTMEMBER}, {" &
Parameters!pMember.Value & ".SIBLINGS}))=1, 2, 3))' MEMBER
MEASURES.LABEL AS '" & Parameters!pMember.Value
& ".DIMENSION.CURRENTMEMBER.NAME' SELECT
{MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
MEASURES.SYMBOL, MEASURES.PUNAME} ON 0, DRILLDOWNMEMBER({"
& Parameters!pMember.Value & ".SIBLINGS}, {" & Parameters!
pMember.Value & "}) ON 1 FROM [Purchase Order]")
Thanks in advance..You have a typo in the query around one of the IIFs: MEASURES.SYMBOL AS
'IIF(" & Parameters!pMember.Value
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"alex" <anonymous@.discussions.microsoft.com> wrote in message
news:520501c48089$bbaa46b0$a401280a@.phx.gbl...
> hi,
> I'm using the sample RS code for my cube. I just copied
> from the sample code and replaced the cube name with my
> cube name ...its working fine with the code given by them
> and for microsoft's reports. but when i run my reports its
> giving an error msg like ... The expression for the
> query 'Selection' contains an error: [BC30648] String
> constants must end with a double quote.
> here selection is my dataset name... i'm running this thru
> report designer in vs.net... could any one tell me wht's
> my wrong ...
>
>
> =IIF(Parameters!pParamIn.Value="", "WITH MEMBER
> MEASURES.DIMNAME AS 'NULL' MEMBER MEASURES.UNAME AS 'NULL'
> MEMBER MEASURES.PUNAME AS 'NULL' MEMBER MEASURES.LABEL
> AS 'NULL' MEMBER MEASURES.SYMBOL AS 'NULL' SELECT
> {MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
> MEASURES.SYMBOL, MEASURES.PUNAME} ON 0 FROM [Purchase
> Order]", "WITH MEMBER MEASURES.DIMNAME AS '" & Parameters!
> pMember.Value & ".DIMENSION.NAME' MEMBER MEASURES.UNAME
> AS '" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER.UNIQUENAME' MEMBER
> MEASURES.PUNAME AS '" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER.PARENT.UNIQUENAME' MEMBER
> MEASURES.SYMBOL AS 'IIF(" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER IS " & Parameters!
> pMember.Value & ", 1, IIF(COUNT(INTERSECT({" & Parameters!
> pMember.Value & ".DIMENSION.CURRENTMEMBER}, {" &
> Parameters!pMember.Value & ".SIBLINGS}))=1, 2, 3))' MEMBER
> MEASURES.LABEL AS '" & Parameters!pMember.Value
> & ".DIMENSION.CURRENTMEMBER.NAME' SELECT
> {MEASURES.DIMNAME, MEASURES.UNAME, MEASURES.LABEL,
> MEASURES.SYMBOL, MEASURES.PUNAME} ON 0, DRILLDOWNMEMBER({"
> & Parameters!pMember.Value & ".SIBLINGS}, {" & Parameters!
> pMember.Value & "}) ON 1 FROM [Purchase Order]")
>
> Thanks in advance..
>

Error in Analysis Services

I am getting an error while I try to browse data in a Cube. I have installed SQL 2000 Developer version along with Analysis Services. My operationg system is Windows XP.
I have attached the error message below.
Thanks
RVCE02what is the error you are getting ?

Error help when deploying a cube

I'm getting an error message and i'm not sure what it's trying to tell me.

Errors

Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idcol, Value: 441183. 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, Cube: SDW, Measure Group: Rpt Vr Flat Cmb Ih So, Partition: Rpt Vr Flat Cmb Ih So, Record: 441183. 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 processing the 'Rpt Vr Flat Cmb Ih So' partition of the 'Rpt Vr Flat Cmb Ih So' measure group for the 'SDW' cube from the sdw4 database. 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

-background-

My cube is just one flat table the only linking it has is to a time table. This table is put together over night for users to query off of, and when we built this table a primary key wasn't a option so we added a auto incermenting col just to give us a key and that is the key is called idcol which i think is telling me something is wrong with that record. but i'm not sure.

suggestions?

Hello! A guess is that you have a factrecord with a time key that is not in the time table/flat file.

HTH

Thomas Ivarsson

error handling while processing a cube

hi

in analysis services when i process a cube i got an error that
data from the fact table isnt exists in the dimenstion table
for example : fact table sales has column suplier that one of its row
has data(suplier id = 170) that doesnt match with the dimension table ( in the dimension table there isnt such supier id)
how can i handle this error ?
can i insert instead someyhing else so that the proccess can continue and not failed ?

Thanks

Eyal

Ideally, you've addressed this problem in your data warehouse/data mart. I recommend to my clients they never allow NULLs in their foreign keys. This requires you to place a NULL member in each dimension -- we usually assign that member the surrogate key value of -1 -- and eliminates this issue.

It sounds like in your example, you have a valid key in your partition, so I would suggest you make sure you dimension is processed before you process your cube/partitions.

If that is not an option, you use use the UnknownMember and ErrorConfiguration properties in SSAS to handle this issue. In the dimension that is causing problems (the supplier dimension in your example?) set the UnknownMember property to either visible or hidden. It defaults to None which makes the UnknownMember inaccessible.

Then, on the measure group that points to this dimension table, change the error configuration to replace missing key values with unknown (using the KeyErrorAction and KeyNotFound properties). Be certain to also set the KeyErrorLimitAction property to Stop Logging when the max error is hit.

One important gotcha on this. If your dimension member lands in your dimensions, the facts assigned to the unknown member do not revert to your new dimension value. To line your facts up correctly with the values in your dimension, you will need to do a full reprocess of the partition.

B.