Data Load time and tm1s log

[manu0521]

Hi ,

I am loading my sales cube from Datawarehouse to tm1 cube , all calculations are performed on Data warehouse side .

I am loading around 5 million rows of data and it takes 6 hours . Is this normal as this will be 1 time load and will be refreshing only 2 months of data daily.

Also I see my tm1s log size increases to larger size , Is there some thing i can do so that it doesnot write when doing fulll loads.

Thanks,

[Emixam]

Hello,

I am loading around 5 million rows of data and it takes 6 hours . Is this normal as this will be 1 time load and will be refreshing only 2 months of data daily.

I would say no, especially if you are only doing a simple CellPutN. Is there a lots of rules in your cube ? Show us your code, it will be easier for us to help you !

Also I see my tm1s log size increases to larger size , Is there some thing i can do so that it doesnot write when doing fulll loads.

Look at the documentation related to CubeSetLogChanges function. ExploringTM1 explain how to use that function.

Hope it helps !