Error in cube processing using conformed date dimension
-
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:
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?
-
I don't see your illustration. Did it get lost somehow?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Sorry, it's posted now
-
I found the issue, there was a filter being applied in my DSV that I had forgotten about. Removed the filter and cube processed with no problems.
-
Ah, well, glad it worked out for you then.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply