April 19, 2011 at 7:19 am
Hi ,
Table on which I have created partition is considered as Fact as well as Dimension table.When I directly process partition instead of processing dimension first , I got exception like "Attribute Key does not exist"
so now I am processing dimension first and then partition and it works .
Lets say I have created two month wise partition for e g Jan-2011,Feb-2011
First I process my Jan-2011 partition and then Feb -2011 partition and then I can see 10 and 12 records in each
partitions respectively.
I then delete one record from sql server db who comes under Feb-2011 partition and then Process Jan-2011 partition
When I browse in SSAS i can see , one record from Feb-2011 partition has got deleted. Even I did not process Feb-2011
partition . Why should it happened ?
and when I add new record in SQL Server database which comes under Feb-2011 Partition and then Process Jan-2011 partition
When I browse in SSAS i can see , New added record in SQL Server database does not affect Feb-2011 partition.
Please give me some idea ! Where I am going wrong.
Thanks in advance !
April 25, 2011 at 3:22 am
Please check the Partition Source Queries..Check whether its taking data from Feb only or Jan as well.
regards
Bornsql
April 25, 2011 at 4:03 am
Hi
I have checked query too and its correct .
Regards,
Prashant Mhakse
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply