Post reply

The count between the SSAS Fact and SQL Fact dont match

  • September 7, 2010 at 4:13 am

    #141716

    Hi please help, I have successfully process a cube and everything is working good, but when I browse the cube and explore the count is 4863, and when I compare it with that in the database is 5026. So how do I make SSAS to equal the count on the database.

    SELECT COUNT(*) FROM dbo.a_vi_APPurchaseOrders AP WITH (NOLOCK)

    INNER JOIN dbo.a_vi_Vendor V

    ON V.DCLink = AccountID

    INNER JOIN dbo.a_vi_CalendarDate D

    ON AP.InvDate = D.PK_Date

    GO

  • September 13, 2010 at 3:33 am

    #1219916

    make a dimension from your primary key and do a reconciliation

  • September 13, 2010 at 4:43 am

    #1219945

    Thanx, I went to my dimension and I made it to have Unique keys, my dimension had duplicate keys, so that was the reason why my AS Fact count was increasing.

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

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