Skip to Content
0
May 21, 2009 at 03:22 PM

enable automatic time conversion rule?

87 Views

Hi All,

I have a transformation / DTP loading data from a DSO into an cube in BI7.

one of the mappings uses the automatic time conversion from a date field on the DSO to the 0CALMONTH field in the cube. In our Dev and QA systems, this works correctly, but in prod the mapping appears to be inactive since all the values on the cube in SID_0CALMONTH are 0 (in Dev and QA they contain the correct values).

Is there some configuration setting or something else I need to do in Prod to get this working?

Also, I have activated partitioning on the cube using 0CALMONTH so I am guessing there is no way around having to drop and reload once I get this working again?

Many Thanks for any help!

Best Regards,

Darryl