Post reply

Creating and Processing cube's partition dynamically using SSIS

  • April 19, 2011 at 7:19 am

    #249559

    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

    #1315335

    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

    #1315348

    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