Attribute key cannot be found issue after migration

Hi Guys,

I have migrated my cubes from 2000 to 2005. My cubes are getting processed fine (after fixing known issues) but it looks there is problem with table join with date dimension so lots of rows coming as not found.

This is the error/warning I get while processing however cube is processing fine.

Errors in the OLAP storage engine: The attribute key cannot be found: Table: <fact table>, Column: DT_ID, Value: 2005010208. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: DT_ID of Dimension: Date from Database: Risk Reports, Cube: <cube name>, Measure Group: <name>, Partition: <name>, Record: 6.

The error is very simple and I know what is happing. I have date dimensions which is 30 days only and while processing cube is reading 2005 data. Now in AS 2000 when I check SQL while processing cube I see join between fact table and date dimension. but in 2005 I don't see that join. In 2005 it just select from fact table.

The partition is build using fact table. I think I can fix this issue by making partition as query and join with date dimension but I feel it should be done at data source view level not at partition level.

I am not able to find how I can do at data source view level any idea what I am talking about?

Thank you - Ashok

Hey ashok, in your DSV, you can change your fact table to a Named Query, and limit the pull to only have the related data in your date dimension table..

something like:

select field1,field2,field3 from FACT_TABLE where DT_ID in(
select distinct DT_ID from dim_DATE)

I'm not sure if that's what you want to do, or if that's what you meant.. If you want the unrelated data, you could always just ignore the error in your error configuration, too..

Hope that helps?

C.|||

Named Query will work fine. What I was thinking and I am not sure it is possible or not. In Data Source View when we create relation between fact and dimension tables is there any was that we can set that some join will be taken while cube processing.

In other words in my case I want my fact table should always join with date dimension while processing cube even my cube partition is created using fact table only not query or fact table as named query. I like to have some properties setting in data source view so that while processing cube it should join fact and date dimension based on join key set in data source view.

Thank you - Ashok