Using multiple partitions, each partition has its own datasource(own
facttable)
A member with key '2006' was found in the fact table but was not found in the
level 'Year' of the dimension 'Order_Date.order_Dates'.;

Thank you for your help

--
Message posted via http://www.sqlmonster.com

have you checked your order date dimension to confirm it includes 2006?


"meghana via SQLMonster.com" <u20487@uwe> wrote

Thank you jesse

No, my date dimension doesn’t have 2006 included because partition not yet
processed.

I created a cube and dimensions on sale1 table with site1 data source and
processed successfully. Then I added a new partition on sale2 table with
site2 data source.
When try to process partition I got this error.

Date dimension has data of sale1 table (2004, 2005)
My sale2 table has data of sale2 table (2006)
How does my date dimension get updated wtih 2006? And also date dimension is
linked to sale1 table site1 1data source.
Thank you for your help


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