TM1 Forum

Hi there

Hope somebody can help me with my problem.
The problem that I have is that the amounts in a cube is duplicated after loading the cube from a TI process. The TI process is getting the data from SQL server.

The Data Action is set to Accumulate Values.

I have tested the SQL Data as well to see if the duplication might occur in the SQL data source but as far as I can see there is no duplication of data in SQL.

Can you guys give me any help or ideas on this problem??

Thanks
Andrea

What do you mean by "duplication" exactly?

afullex wrote:The Data Action is set to Accumulate Values.

This means the process will add the value to the value already in the cube. Is that what you want?

On the "Cube" page of the "Maps" tab there is an option to zero out a portion of the cube before the import. Are you using that? If not it might be worth considering.

Thanks for reply's! I found the problem in on of my dimensions, for some reason there was a duplication in the dimension which caused the amounts to duplicate in the cube.

Thanks again!