Post reply

Error Processing cube when tie dimension is added??

  • July 6, 2006 at 5:59 am

    #153071

    Cube processing errors when i add a time dimension. it says attribute key cannot be found and it is looking for the value 0. There is no value 0 in the dimension column of the fact table????

     

    Anyone got any ideas.

    www.sql-library.com[/url]

  • July 7, 2006 at 3:40 am

    #647908

    The reason for this may be that your fact table conatains record with value which cannot be linked to to time dimension. You have two resolutions, first review value in you fact table, second switch off cube processing option which is responsible for processing failure on key error

  • July 18, 2006 at 8:16 am

    #649797

    Thanks Adam Unfortunatly this wont solve the problem.

    The strange thing is that- i create two cubes with same data source using the same fact table and the same dimension in both cases.

    However with the first one i dont define the dimension as a time dimension and the cube processes fine.

    With the second cube i do define the dimension as a time dimension and then the cube processing errors. The error say attribute key cannnot be found?? But it was found in the first cube?

    Anyone know what might be causing this?

     

    Thanks,

     

     

    www.sql-library.com[/url]

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

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