Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    India
    Posts
    4

    Post Unanswered: Analysis Services Cube Measures showing #ERR

    Hi,

    We have a MS OLAP Cube using 10 dimensions and 1 fact table with measures as COUNT and DISTINCT COUNT.

    When we processed the cube using Analysis Services, it was done but all the measures are showing #ERR as values. The cube is about 650MB in size and all the joins between Dimension and Fact tables seem to be OK.

    What could be the possible reasons of getting #ERR in measures? Do all the datatypes and length of JOIN columns between dimension and fact HAVE TO BE the same????

    Please provide any inputs as this is very urgent.
    Thanks
    Omkar

  2. #2
    Join Date
    Feb 2003
    Posts
    109

    id assume its some division by 0 error

    id assume its some division by 0 error

    you can deal with this by replacing a Zero with a NULL in whatever field you use as a denominator. (the bottom half of division-- i hope that was the right word)
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •