Error in cube processing using conformed Dimensions
Page 1 of 1
Error in cube processing using conformed Dimensions
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=https://servimg.com/view/17543054/1][/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?
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=https://servimg.com/view/17543054/1][/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
Not really any issue
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
Similar topics
» SSAS Cube - zero downtime even during cube processing
» Cube Processing for Dimension Schema changes
» Conformed Dimension Processing Multiple Data Marts
» Design all dimensions as conformed dimensions
» Cube with two time dimensions
» Cube Processing for Dimension Schema changes
» Conformed Dimension Processing Multiple Data Marts
» Design all dimensions as conformed dimensions
» Cube with two time dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum