When I try to process a cube I get an error:
A member with key 'xxx.xxx.xxx.xxx' was found in the fact table but was not found in the level 'Client Ip' of the dimension 'the Client IP'.; (NOTE the actual IP addres is displayed, I x'ed it out for security reasons).
The fact table has a session id that links to the dimension table that contains the client ip. I have 2 databases, one that doesn't get used and I can process the cube with no problem.....the other database is getting hit constantly and new records are created with new client IP and that is where the problems occur. I'm going thru the MS documentation and not getting very far. I'm not a DBA, just some poor sap that got this problem dump on them.
Can you tell me why this error occurs and how to go about trouble shooting it?