Error in cube processing using conformed Dimensions

View previous topic View next topic Go down

Error in cube processing using conformed Dimensions

Post  King Conch on Sat May 26, 2012 8:55 pm

I have an issue with two fact tables connected to one date dimension. The two fact tables have ranges of different dates, but all dates are present in the date dimension.

I encounter the problem when I try to process the cube, I get an error stating that my date dimension does not have a FK for dates that I know are in the dimension. See the illustration below:

[url=http://www.servimg.com/image_preview.php?i=1&u=17543054][/url

Only when my two fact tables share the same date ranges will my cube process. If either cube has any dates that are not in the other, then the process fails.

Has anyone encountered this issue?

King Conch

Posts : 2
Join date : 2012-05-26

View user profile

Back to top Go down

Not really any issue

Post  King Conch on Sun May 27, 2012 2:40 am

I found the culprit causing the cube to fail. There was a filter applied in the DSV that was limiting my date dimension. I removed the filter and it processed like a champ.

King Conch

Posts : 2
Join date : 2012-05-26

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum