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 'Ìnventory' (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)
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 'Ìnventory' (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)