TM1 Data Spread while Data hold take place

Post Reply
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

TM1 Data Spread while Data hold take place

Post by dharav »

Hello All,

I am experiencing following issue:

I have a requirement where user would hold the data cell based on their requirement in the target cube and than would do data spread in cube B and Cube A is a source cube.

=> When there is no data hold applied than process runs successfully and it takes 12 seconds.

=> When data hold is applied (for more than 15 rows) and you run the same process than it takes 4 minutes before it throws following error (Image).
[img]
IBM PMR DataSpread.JPG
IBM PMR DataSpread.JPG (33.86 KiB) Viewed 1420 times
[/img]


does anyone experiencing same in their environment? I spoke with IBM folks and they are looking in to it. Moreover, they said that the performance issue while data spreading when data hold functionality applied is known and rectified in 10.2.2 FP4. Here, process throws the error as it shows in the image and not run successfully. If i remove all hold and run the same process than i runs successfully and takes 12 seconds only.

Please feel free if you require further information.

Thank You

Dharav
Post Reply