TM1 Contributor 10.2 very slow copy paste and commit

Slava79 · Post by **Slava79** » Wed Jan 15, 2014 8:57 pm

TM1 Contributor 10.2 very long save the values copied (ctrl+c ctrl+v) from Excel

For example
20 rows
10 columns
Saving - more than 1 minute

Slava79 · Post by **Slava79** » Wed Jan 15, 2014 8:59 pm

I moved the screenshots below to forum

Slava79 · Post by **Slava79** » Thu Jan 16, 2014 1:00 pm

Insert 100 rows 20 columns cells from Excel to Contributor performed in 4 minutes 30 seconds.
Saving data (commit) takes 2 minutes 30 seconds.

Total 7 minutes by copying and storing the values of 2000 cells from Excel!

Is this normal?

Cube, where I insert values from Excel is empty. Cube doesn't contain rules.

Cognos Express 10.2.1.

declanr · Post by **declanr** » Thu Jan 16, 2014 1:07 pm

Slava79 wrote:Insert 100 rows 20 columns cells from Excel to Contributor performed in 4 minutes 30 seconds.
Saving data (commit) takes 2 minutes 30 seconds.

Total 7 minutes by copying and storing the values of 2000 cells from Excel!

Is this normal?

Cube, where I insert values from Excel is empty. Cube doesn't contain rules.

Cognos Express 10.2.1.

As a starting point out of interest how long does it take if you do a repeat data spread to that sort of number of cells?
Are there a lot of rules calculated off the back of this input, if so have skipcheck and feeders been used to best effect?

Slava79 · Post by **Slava79** » Thu Jan 16, 2014 1:59 pm

Data spread works very fast

Slava79 · Post by **Slava79** » Thu Jan 16, 2014 2:08 pm

I did Active Form
Copy and paste from Excel to Active Form works very fast.
But In cubeview slowly.

Slava79 · Post by **Slava79** » Sun Jan 19, 2014 10:03 am

I spent Tests
I created cube
I created 2 dimensions
100 elements in the dimension

I copy and paste 100x10 cells from excel to countributor.
Very long working procedure of copying and pasting in TM1 Contributor!
Very long procedure works commit in TM1 Contributor

If you work with ActiveSheet in TM1 Contributor copying and commit work quickly!

TM1Top created a log file of commit procedure.
I add the log file to the forum

Slava79 · Post by **Slava79** » Sun Jan 19, 2014 10:05 am

: 1.jpg (30.27 KiB) Viewed 7593 times

: 2.jpg (30.58 KiB) Viewed 7593 times

: 3.jpg (104.99 KiB) Viewed 7593 times

Slava79 · Post by **Slava79** » Sun Jan 19, 2014 10:06 am

: 4.jpg (227.01 KiB) Viewed 7593 times

: 5.jpg (179.48 KiB) Viewed 7593 times

: 6.jpg (234.78 KiB) Viewed 7593 times

Slava79 · Post by **Slava79** » Sun Jan 19, 2014 10:08 am

: 7.jpg (236.46 KiB) Viewed 7593 times

: 8.jpg (83.26 KiB) Viewed 7593 times

: 9.jpg (170.97 KiB) Viewed 7593 times

Slava79 · Post by **Slava79** » Sun Jan 19, 2014 10:09 am

: 10.jpg (197.5 KiB) Viewed 7573 times

: 11.jpg (224.21 KiB) Viewed 7593 times

tm1top.log: (83.83 KiB) Downloaded 309 times

EP_explorer · Post by **EP_explorer** » Tue Jan 28, 2014 6:27 am

Try to install FixPack 1. It seems may help.

TM1 Forum

TM1 Contributor 10.2 very slow copy paste and commit

TM1 Contributor 10.2 very slow copy paste and commit

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor very long save the values copied from

Re: TM1 Contributor 10.2 very slow copy paste and commit