Time Dimension Cube processing error

[JulesBonnot]

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,

 

[johnherman]

There is something "wrong" with either the data in the dimension (not valid date/time data) or in your definition of that data with respect to conversion to date/time. (Since it all works fine when the data is string)

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright