Errors in the OLAP storage engine: The attribute k

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Errors in the OLAP storage engine: The attribute k

Author

Topic

BhaskarDasari
Starting Member

19 Posts

Posted - 2008-10-07 : 03:45:34

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_proj_count_view, Column: is_six_sigma_proj, Value: -1. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Is Six Sigma attribute 12 of Dimension: Is Six Sigma from Database: GPS, Cube: Project Count, Measure Group: Project Count, Partition: Project Count, Record: 2.

i have migrated 2000 cubes into 2005 using migration wizard.when i am processing the cube getting the follwoing error.

error:

Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_proj_count_view, Column: is_six_sigma_proj, Value: -1. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Is Six Sigma attribute 12 of Dimension: Is Six Sigma from Database: GPS, Cube: Project Count, Measure Group: Project Count, Partition: Project Count, Record: 2.

i checked the dimension view "is_six_sigma_dimension_view" and no value with -1 is available even checked the fact view "proj_count_view" and no records having -1 value for foreign key is_six_sigma_proj which is the primary key in dimension " is_six_sigma_dimension_view" .

following code is structure of dimension view

CREATE view [dbo].[is_six_sigma_dimension_view] as
select 0 "is_six_sigma_proj", 'Non-Six Sigma Project' "is_six_sigma_proj_name"
union
select 1 "is_six_sigma_proj", 'Six Sigma Project' "is_six_sigma_proj_name"

fact view structure
create view [dbo].[proj_count_view] as

select distinct proj.proj_id, proj_nbr, lead_subsubdivision_id, lead_facility_id, corp_critical_y_id, proj_status_id, proj_prog_color_id, can_be_repl,

is_six_sigma_proj, is_sourcing_proj, is_eprod_proj, is_indirect_cost_proj, is_dfss_3m_accel_proj, is_noninitiative_proj,

benefit_track_length_id, fin_valid_priority_id, fin_valid_status_id, isnull(six_sigma_phase_id, -1) "six_sigma_phase_id",

isnull(is_green_belt_proj, 0) "is_green_belt_proj", isnull(sourcing_phase_id, -1) "sourcing_phase_id",

isnull(subsubdivision_id, lead_subsubdivision_id) "benefit_subsubdivision_id", isnull(facility_id, lead_facility_id) "benefit_facility_id",

isnull(is_global_business_process_proj, 0) "is_global_business_process_proj"

from proj left join benefit on proj.proj_id = benefit.proj_id

left join six_sigma_proj on proj.proj_id = six_sigma_proj.proj_id

left join sourcing_proj on proj.proj_id = sourcing_proj.proj_id

Any help would be appriciated..

Thanks,
Bhaskar

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources