Hi,
I have two tables, cds_statday with all transactions for all customers (Meta_ID, fact table)
and part of customers in Group table(PlayerID, dimention table)
I can't process the cube because SSAS can't find players from fact table in demention table. What can I do?
http://public.fotki.com/obulay/image/screen.html
OL
Here is Error Message
Errors in the OLAP storage engine: The attribute key cannot be found: Table: cds_statday, Column: Meta_ID, Value: 775. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Agroup of Dimension: Group from Database: SSAS, Cube: Analyst, Measure Group: Cds Statday, Partition: Cds Statday, Record: 21216.
OL
|||Process the dimension table before the measure group. If this does not work you probably have a problem with the relation between the dimension table and the fact table. You might have keys in the fact table that are not included in the dimension table.
Regards
Thomas Ivarsson
|||found the reason on the forum. I changed processing settings to ignore missing attributes
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=123784&SiteID=1
No comments:
Post a Comment