469,924 Members | 1,392 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,924 developers. It's quick & easy.

Error processing cube with disabled lowest level of shared dimension

SRL
Hi,

This is probably a classic scenario with a shared dimension that we
need to use in different cubes, where all fact tables do not offer the
same level of detail. Dimension is snow-flaked.

The cube that's causing me troubles was designed by marking the lowest
dimension level Diabled and not Visible. This allows me to get rid of
one of the snow-flake tables (the one with the lowest level), thus
allowing an INNER JOIN with the remaining table which has a level of
detail corresponding to the fact table.

When processing the cube, I get a 'member with key '[blah]' was found
in the fact table but was not found in the level '[blah]' of the
dimension '[blah]'' that seems to indicate that none of my fact foreign
keys exist as primary keys in the dimension table. However if I then
attempt to query the cube, all data seems to be there.

Would anybody be in a position (and willing ;-)) to share his/her own
experience working around a similar issue?

Thanks,

SRL

Jul 23 '05 #1
2 1380

"SRL" <sr******@gmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
Hi,

This is probably a classic scenario with a shared dimension that we
need to use in different cubes, where all fact tables do not offer the
same level of detail. Dimension is snow-flaked.

The cube that's causing me troubles was designed by marking the lowest
dimension level Diabled and not Visible. This allows me to get rid of
one of the snow-flake tables (the one with the lowest level), thus
allowing an INNER JOIN with the remaining table which has a level of
detail corresponding to the fact table.

When processing the cube, I get a 'member with key '[blah]' was found
in the fact table but was not found in the level '[blah]' of the
dimension '[blah]'' that seems to indicate that none of my fact foreign
keys exist as primary keys in the dimension table. However if I then
attempt to query the cube, all data seems to be there.

Would anybody be in a position (and willing ;-)) to share his/her own
experience working around a similar issue?

Thanks,

SRL


You might want to post in microsoft.public.sqlserver.olap, to see if you get
a better response.

Simon
Jul 23 '05 #2
SRL
Thanks, will do.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Biswajit Barik | last post: by
2 posts views Thread by znelson | last post: by
6 posts views Thread by Peter Frost | last post: by
3 posts views Thread by Christopher | last post: by
1 post views Thread by whitehorse | last post: by
2 posts views Thread by Axel Gallus | last post: by
9 posts views Thread by flyvin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.