Each partition in a cube has a different data source.

I created a cube based on sale1 table in site1 data source
All the dimensions linked to site1 data source
I created partition1 on sale2 table in site 2 data source
Sale1 and sale 2 tables contains same schema
Receiving a error on partition1

A member with key 'Sales2' was found in the fact table but was not found in
the level 'Account Desc' of the dimension 'Account_Desc

Sale1 table account_desc is sale1
Sale 2 table account_desc is sale2

How do I fix it
Thank you so much for your help on this.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200610/1

Hi meghana,

Is is possible that their is an entry from your Fact Table that isn't
in your Account Dimension. It sounds like you may not be using a
conformed Account dimension table and perhaps using a separate Account
dimension table for each fact table. In Analysis Services you will
need to make sure that all our your Account Dimension tables are
included in the load process (probably through a view with a UNION) --
the view because the source table in the data source view.

To test this out I would suggest running a query like:

SELECT count(1)
FROM sales2 s
LEFT OUTER JOIN acct1 a --The table you have defined in
the Analysis Services data source view
ON s.acct_id = a.acct_id --Joining on the same columns
as defined in the Analysis Services data source view
WHERE a.acct_desc IS NULL

Barry

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
meghana via SQLMonster.com wrote: