I have a cube that maps customer information (using a surrogate key
customer_key) to a fact table which contain customer_key.
I check to make sure that all of the customer_key found in the Fact_table
are found in the customer_dim, but when I try to process it return a message.
A member with key "**********************" one of the member key column
that I selected was not found in the fact_table. Which is it looking in the
fact_table for this key, when the key that it should be mapping against it is
customer_key.
thank you for any help

Try executing the SQL statement interactively and see what it returns.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Tomas" <Tomas (AT) discussions (DOT) microsoft.com> wrote