Post reply

Errors in the OLAP storage engine: The attribute key cannot be found:

  • October 7, 2008 at 12:37 am

    #194394

    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

  • October 10, 2008 at 2:39 pm

    #883647

    Alright, i have never worked with Cubes in 2000 Analysis services but have worked with 2005.

    My plan of action would be :-

    Check the data in the tables, there should be no duplicates, no missing parent-child data. If this is not the case then

    2005 Analysis services will throw this kind of error while processing the cube.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply