August 28, 2013 at 10:32 am
Hello all,
I am running into what looks like a pretty comon SSAS error, but I haven't been able to find anything online to address my particular issue, and I'm kind of stumped. Any suggestions would be much appreciated. I'm a little green when it comes to building OLAP cubes, so please be gentle.
I am getting the following error when trying to deploy a cube:
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_DimProject', Column: 'ProjectKey', Value: '0'. The attribute is 'Project'.
I know that this error is typically caused when a dimension is missing a member that is referenced in a fact table, but two things are leading me believe something else is going on:
1. I have directly checked all my fact tables in my DW for records where the ProjectKey vlaue is 0. No such records exist in any of the fact tables.
2. I also get this exact same error when processing the project dimension as opposed to the cube.
I have tried:
- Processing all my other dimensions. They all process fine.
- Running a process full on the project dimension - same error occurs and processing fails
- Processing my partition (I only have one at the moment) independently - same error as above
Thanks in advance for any suggetsions and/or help!
August 28, 2013 at 11:09 am
So after composing this desccription I immediately figured it out.
My project dimension in snowflaked, so it uses attributes from a couplle of related tables. One of the related tables did have a record that has a ProjectKey value of 0.
In my case, this particular record is garbage data from that needs to be removed from the data source, so in the meantime I'm using a named query to filter out this record from the all the tables used in the project dimension. I am fortunate in that this gargbage project record is not reference in any of my fact tables, otherwise I would need filter my fact tables as well.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply