Microsoft SQL Server forum - Member Key found in Fact Table but not in Dimension

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Member Key found in Fact Table but not in Dimension

Mully

2005-06-30, 7:24 am

I have a problem with the data in my Cubes in Analsyis Services.

When I try to process the cubes I get the following error:
"A member with key 'XXX' was found in the fact table but was not found
in the level 'XXX' of the dimension 'XXX'"

I have narrowed it down to the way the data is entered into the
Relational Database Table for example instead of typing 'Inventory' the
word is '=CCnventory' (this is due to hitting the apostrophe key before
typing in the word)

Has anyone come across this problem? Has anyone been able to solve it?
Please advise 8o)

Sponsored Links