Post reply

Processing of Partitions

  • April 22, 2008 at 12:24 pm

    #189400

    Hi

    I have recently started using Analysis services. The other day I had to load some data into the

    fact tables and process the cube.

    To my surprise I saw that 'Analysis Services' is showing more rows processed than present in the fact table. I rechecked it again and again but the same result.

    I am a bit confused. If somebody knows please tell me

    What am I missing here???!!!

    Thanks and Regards

    Kalyan

  • April 22, 2008 at 4:36 pm

    #805815

    Am I wrong in assuming that it can never happen?

    If so under what circumstances can it happen?

    Thanks in advance

  • May 30, 2008 at 5:44 am

    #822225

    my 2 cents..

    Check your cube schema. Make sure all the dim keys in the fact table(s) are linked to appropriate dimension table keys.

    If the problem persists, try removing dimensions one by one from the cube to find the culprit.

    Warm Regards,
    Neel aka Vijay.

  • June 11, 2008 at 12:53 am

    #827083

    Yes, there can be a schema problem.

    After the partition processing complets, extract the query that gets generated and used for partition processing and execute the query from SQL Server DB.

    You will be finding the same number of rows that the partition processing give. Try adding/removing joins between tables and test until you arrive with the number of records that you expect(that equal to the fact).

    That way you will know where in the cube schema/dimension design you got to change.

    Hope that helps...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply