I'm having problems processing a dimension.
Before I could process the dimension manually through Mgmt Studio but it would fail when I ran a SQL job with an SSIS package to process the cube. Now I can't
Now I can't even process the dimension manually via Mgmt Studio. I keep getting the error below:
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0.
Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.
The unknownmember property of the dimension is none.
The nullProcessing proprty of the Est_Hours attribute is Automatic
The dimension view shcema has not changed.
The dimension key attribute does not include the Est_Hours atribute.
Can someone understand the error below? I can provide more information if needed.
Processing Dimension Attribute 'Vw RFC Effort Analysis Details' failed. 1 rows have been read.
(2 detailed error messages
(1)
<Batch ProcessAffectedObjects="true" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns
dl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsdl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
<Object>
<DatabaseID>ProjectManagement</DatabaseID>
<DimensionID>Vw RFC Effort Analysis Details</DimensionID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Cube 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Measure Group 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Partition 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Dimension 'RFC_EffortAnalysis_Details' failed.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:25 PM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed successfully.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
Processing Dimension Attribute 'Manager' completed successfully. 18 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Manager] AS [dbo_vwRFC_EffortAnalysis_DetailsManager0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Primary Change Category' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Primary Change Category] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC Group' completed successfully. 10 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC Group] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Group0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC Short Name' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC Short Name] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Short_x0020_Name0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Role' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Role] AS [dbo_vwRFC_EffortAnalysis_DetailsRole0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Sub Role' completed successfully. 12 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[SubRole] AS [dbo_vwRFC_EffortAnalysis_DetailsSubRole0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Status' completed successfully. 10 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Status] AS [dbo_vwRFC_EffortAnalysis_DetailsStatus0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'SVP Approver' completed successfully. 11814 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT [dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0],[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_1],[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_2],[dbo_vwRFC_EffortAnalysis_Details].[SVP Approver] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_Approver0_3]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'SVP OK' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[SVP OK?] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_OK_x003F_0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Est Hours' completed successfully. 274 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Est_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsEst_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Act Hours' completed successfully. 182 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Act_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsAct_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Rem Hours' completed successfully. 168 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Rem_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsRem_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Pred Hours' completed successfully. 61 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Pred_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsPred_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'ID' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[ID] AS [dbo_vwRFC_EffortAnalysis_DetailsID0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Title' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Title] AS [dbo_vwRFC_EffortAnalysis_DetailsTitle0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'IT Lead' completed successfully. 36 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[IT Lead] AS [dbo_vwRFC_EffortAnalysis_DetailsIT_x0020_Lead0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Parking Lot' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Parking Lot] AS [dbo_vwRFC_EffortAnalysis_DetailsParking_x0020_Lot0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Total Scorecard Score' completed successfully. 227 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Total Scorecard Score] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Process Excellence Project' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Process Excellence Project] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Requestor' completed successfully. 117 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Requestor] AS [dbo_vwRFC_EffortAnalysis_DetailsRequestor0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Scorecard Override' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Scorecard Override] AS [dbo_vwRFC_EffortAnalysis_DetailsScorecard_x0020_Override0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Employee' completed successfully. 80 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC No' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Week Of Date' completed successfully. 187 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Vw RFC Effort Analysis Details' failed. 1 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:25 PM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0],[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_1],[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_2],[dbo_vwRFC_EffortAnalysis_Details].[Manager] AS [dbo_vwRFC_EffortAnalysis_DetailsManager0_3],[dbo_vwRFC_EffortAnalysis_Details].[Primary Change Category] AS [dbo_vwRFC_EffortAnalysis_Details0_4],[dbo_vwRFC_EffortAnalysis_Details].[RFC Group] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Group0_5],[dbo_vwRFC_EffortAnalysis_Details].[RFC Short Name] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Short_x0020_Name0_6],[dbo_vwRFC_EffortAnalysis_Details].[Role] AS [dbo_vwRFC_EffortAnalysis_DetailsRole0_7],[dbo_vwRFC_EffortAnalysis_Details].[SubRole] AS [dbo_vwRFC_EffortAnalysis_DetailsSubRole0_8],[dbo_vwRFC_EffortAnalysis_Details].[Status] AS [dbo_vwRFC_EffortAnalysis_DetailsStatus0_9],[dbo_vwRFC_EffortAnalysis_Details].[SVP OK?] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_OK_x003F_0_10],[dbo_vwRFC_EffortAnalysis_Details].[Est_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsEst_Hours0_11],[dbo_vwRFC_EffortAnalysis_Details].[Act_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsAct_Hours0_12],[dbo_vwRFC_EffortAnalysis_Details].[Rem_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsRem_Hours0_13],[dbo_vwRFC_EffortAnalysis_Details].[Pred_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsPred_Hours0_14],[dbo_vwRFC_EffortAnalysis_Details].[ID] AS [dbo_vwRFC_EffortAnalysis_DetailsID0_15],[dbo_vwRFC_EffortAnalysis_Details].[Title] AS [dbo_vwRFC_EffortAnalysis_DetailsTitle0_16],[dbo_vwRFC_EffortAnalysis_Details].[IT Lead] AS [dbo_vwRFC_EffortAnalysis_DetailsIT_x0020_Lead0_17],[dbo_vwRFC_EffortAnalysis_Details].[Parking Lot] AS [dbo_vwRFC_EffortAnalysis_DetailsParking_x0020_Lot0_18],[dbo_vwRFC_EffortAnalysis_Details].[Total Scorecard Score] AS [dbo_vwRFC_EffortAnalysis_Details0_19],[dbo_vwRFC_EffortAnalysis_Details].[Process Excellence Project] AS [dbo_vwRFC_EffortAnalysis_Details0_20],[dbo_vwRFC_EffortAnalysis_Details].[Requestor] AS [dbo_vwRFC_EffortAnalysis_DetailsRequestor0_21],[dbo_vwRFC_EffortAnalysis_Details].[Scorecard Override] AS [dbo_vwRFC_EffortAnalysis_DetailsScorecard_x0020_Override0_22]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Error Messages 2
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093. 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 'Vw RFC Effort Analysis Details' attribute of the 'RFC_EffortAnalysis_Details' dimension from the 'ProjectManagement' database was being processed.
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
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 'Vw RFC Effort Analysis Details' attribute of the 'RFC_EffortAnalysis_Details' dimension from the 'ProjectManagement' database was being processed.
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: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0.
Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.
(2)
<Batch ProcessAffectedObjects="true" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlnsdl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlnsdl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
<Object>
<DatabaseID>ProjectManagement</DatabaseID>
<DimensionID>Vw RFC Effort Analysis Details</DimensionID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Cube 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Measure Group 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Partition 'RFC_EffortAnalysis_Details' completed successfully.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:23 PM; Duration: 0:00:00
Processing Dimension 'RFC_EffortAnalysis_Details' failed.
Start time: 7/11/2007 2:38:23 PM; End time: 7/11/2007 2:38:25 PM; Duration: 0:00:02
Processing Dimension Attribute '(All)' completed successfully.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
Processing Dimension Attribute 'Manager' completed successfully. 18 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Manager] AS [dbo_vwRFC_EffortAnalysis_DetailsManager0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Primary Change Category' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Primary Change Category] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC Group' completed successfully. 10 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC Group] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Group0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC Short Name' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC Short Name] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Short_x0020_Name0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Role' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Role] AS [dbo_vwRFC_EffortAnalysis_DetailsRole0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Sub Role' completed successfully. 12 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[SubRole] AS [dbo_vwRFC_EffortAnalysis_DetailsSubRole0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Status' completed successfully. 10 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Status] AS [dbo_vwRFC_EffortAnalysis_DetailsStatus0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'SVP Approver' completed successfully. 11814 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT [dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0],[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_1],[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_2],[dbo_vwRFC_EffortAnalysis_Details].[SVP Approver] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_Approver0_3]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'SVP OK' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[SVP OK?] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_OK_x003F_0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Est Hours' completed successfully. 274 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Est_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsEst_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Act Hours' completed successfully. 182 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Act_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsAct_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Rem Hours' completed successfully. 168 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Rem_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsRem_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Pred Hours' completed successfully. 61 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Pred_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsPred_Hours0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'ID' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[ID] AS [dbo_vwRFC_EffortAnalysis_DetailsID0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Title' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Title] AS [dbo_vwRFC_EffortAnalysis_DetailsTitle0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'IT Lead' completed successfully. 36 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[IT Lead] AS [dbo_vwRFC_EffortAnalysis_DetailsIT_x0020_Lead0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Parking Lot' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Parking Lot] AS [dbo_vwRFC_EffortAnalysis_DetailsParking_x0020_Lot0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Total Scorecard Score' completed successfully. 227 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Total Scorecard Score] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Process Excellence Project' completed successfully. 4 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Process Excellence Project] AS [dbo_vwRFC_EffortAnalysis_Details0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Requestor' completed successfully. 117 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Requestor] AS [dbo_vwRFC_EffortAnalysis_DetailsRequestor0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Scorecard Override' completed successfully. 6 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Scorecard Override] AS [dbo_vwRFC_EffortAnalysis_DetailsScorecard_x0020_Override0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Employee' completed successfully. 80 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'RFC No' completed successfully. 316 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Week Of Date' completed successfully. 187 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:24 PM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_0]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Processing Dimension Attribute 'Vw RFC Effort Analysis Details' failed. 1 rows have been read.
Start time: 7/11/2007 2:38:24 PM; End time: 7/11/2007 2:38:25 PM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_vwRFC_EffortAnalysis_Details].[Employee] AS [dbo_vwRFC_EffortAnalysis_DetailsEmployee0_0],[dbo_vwRFC_EffortAnalysis_Details].[RFC_No] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_No0_1],[dbo_vwRFC_EffortAnalysis_Details].[WeekOfDate] AS [dbo_vwRFC_EffortAnalysis_DetailsWeekOfDate0_2],[dbo_vwRFC_EffortAnalysis_Details].[Manager] AS [dbo_vwRFC_EffortAnalysis_DetailsManager0_3],[dbo_vwRFC_EffortAnalysis_Details].[Primary Change Category] AS [dbo_vwRFC_EffortAnalysis_Details0_4],[dbo_vwRFC_EffortAnalysis_Details].[RFC Group] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Group0_5],[dbo_vwRFC_EffortAnalysis_Details].[RFC Short Name] AS [dbo_vwRFC_EffortAnalysis_DetailsRFC_x0020_Short_x0020_Name0_6],[dbo_vwRFC_EffortAnalysis_Details].[Role] AS [dbo_vwRFC_EffortAnalysis_DetailsRole0_7],[dbo_vwRFC_EffortAnalysis_Details].[SubRole] AS [dbo_vwRFC_EffortAnalysis_DetailsSubRole0_8],[dbo_vwRFC_EffortAnalysis_Details].[Status] AS [dbo_vwRFC_EffortAnalysis_DetailsStatus0_9],[dbo_vwRFC_EffortAnalysis_Details].[SVP OK?] AS [dbo_vwRFC_EffortAnalysis_DetailsSVP_x0020_OK_x003F_0_10],[dbo_vwRFC_EffortAnalysis_Details].[Est_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsEst_Hours0_11],[dbo_vwRFC_EffortAnalysis_Details].[Act_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsAct_Hours0_12],[dbo_vwRFC_EffortAnalysis_Details].[Rem_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsRem_Hours0_13],[dbo_vwRFC_EffortAnalysis_Details].[Pred_Hours] AS [dbo_vwRFC_EffortAnalysis_DetailsPred_Hours0_14],[dbo_vwRFC_EffortAnalysis_Details].[ID] AS [dbo_vwRFC_EffortAnalysis_DetailsID0_15],[dbo_vwRFC_EffortAnalysis_Details].[Title] AS [dbo_vwRFC_EffortAnalysis_DetailsTitle0_16],[dbo_vwRFC_EffortAnalysis_Details].[IT Lead] AS [dbo_vwRFC_EffortAnalysis_DetailsIT_x0020_Lead0_17],[dbo_vwRFC_EffortAnalysis_Details].[Parking Lot] AS [dbo_vwRFC_EffortAnalysis_DetailsParking_x0020_Lot0_18],[dbo_vwRFC_EffortAnalysis_Details].[Total Scorecard Score] AS [dbo_vwRFC_EffortAnalysis_Details0_19],[dbo_vwRFC_EffortAnalysis_Details].[Process Excellence Project] AS [dbo_vwRFC_EffortAnalysis_Details0_20],[dbo_vwRFC_EffortAnalysis_Details].[Requestor] AS [dbo_vwRFC_EffortAnalysis_DetailsRequestor0_21],[dbo_vwRFC_EffortAnalysis_Details].[Scorecard Override] AS [dbo_vwRFC_EffortAnalysis_DetailsScorecard_x0020_Override0_22]
FROM [dbo].[vwRFC_EffortAnalysis_Details] AS [dbo_vwRFC_EffortAnalysis_Details]
Error Messages 2
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.
Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093. 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 'Vw RFC Effort Analysis Details' attribute of the 'RFC_EffortAnalysis_Details' dimension from the 'ProjectManagement' database was being processed.
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
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 'Vw RFC Effort Analysis Details' attribute of the 'RFC_EffortAnalysis_Details' dimension from the 'ProjectManagement' database was being processed.
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: The attribute key cannot be found: Table: dbo_vwRFC_EffortAnalysis_Details, Column: Est_Hours, Value: 0.
Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Vw RFC Effort Analysis Details of Dimension: RFC_EffortAnalysis_Details from Database: ProjectManagement, Record: 6093.
Hello! First question: Do you have referential integrity between the dimension tables and the fact table?
In other words do you have defined relations(foreign keys) between the dimension tables and the fact table?
Next question. Have you processed all dimensions before the cube(s)? Always process dimensions before the cubes in AS2000 and SSAS2005.
HTH
Thomas Ivarsson
|||This was originally an AS 2000 cube .... I used Management Studio and VS2005 to migrate to an AS 2005 cube.
Therefore I needed to add a fact dimension in orer to enable drillthrough.
I am not even trying to process the cube.
I am trying to process the fact dimension (i.e the dimension is based on the same table/view the cube is based on)
No. There are no foreign keys or referential integrity checks.
I am not even trying to process a cube....thats the weird part.
|||dear friend,
Tell us how you defined your dimensions. Relation with factTables, and hierarchies inside dimension.
Regards!
|||Do you have a project in BI-Dev Studio for your migrated cube(s)?
If so, in the data connection for the project in BI-Dev Studio check the impersonation mode and set it to default if this is not the case.
If not you can import an deployed SSAS2005 cube in BI-Dev studio if you choose the import project.
HTH
Thomas Ivarsson
No comments:
Post a Comment