Getting wrong data

  • I am getting the wrong data in cube report but getting proper data when I am using normal select statement in dataware hosue database.

    What would be possibilities for getting the wrong data??

    kamal maurya

  • Bad joins between the Dimension tables and the Fact tables. Depends on whether you're getting too many records or not enough records.

    Check your table relationships.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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