Page 1 of 1
TM1 Contributor 10.2 very slow copy paste and commit
Posted: Wed Jan 15, 2014 8:57 pm
by Slava79
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
Re: TM1 Contributor very long save the values copied from
Posted: Wed Jan 15, 2014 8:59 pm
by Slava79
I moved the screenshots below to forum
Re: TM1 Contributor very long save the values copied from
Posted: Thu Jan 16, 2014 1:00 pm
by Slava79
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.
Re: TM1 Contributor very long save the values copied from
Posted: Thu Jan 16, 2014 1:07 pm
by declanr
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?
Re: TM1 Contributor very long save the values copied from
Posted: Thu Jan 16, 2014 1:59 pm
by Slava79
Data spread works very fast
Re: TM1 Contributor very long save the values copied from
Posted: Thu Jan 16, 2014 2:08 pm
by Slava79
I did Active Form
Copy and paste from Excel to Active Form works very fast.
But In cubeview slowly.
Re: TM1 Contributor very long save the values copied from
Posted: Sun Jan 19, 2014 10:03 am
by Slava79
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
Re: TM1 Contributor very long save the values copied from
Posted: Sun Jan 19, 2014 10:05 am
by Slava79
- 1.jpg (30.27 KiB) Viewed 7597 times
- 2.jpg (30.58 KiB) Viewed 7597 times
- 3.jpg (104.99 KiB) Viewed 7597 times
Re: TM1 Contributor very long save the values copied from
Posted: Sun Jan 19, 2014 10:06 am
by Slava79
- 4.jpg (227.01 KiB) Viewed 7597 times
- 5.jpg (179.48 KiB) Viewed 7597 times
- 6.jpg (234.78 KiB) Viewed 7597 times
Re: TM1 Contributor very long save the values copied from
Posted: Sun Jan 19, 2014 10:08 am
by Slava79
- 7.jpg (236.46 KiB) Viewed 7597 times
- 8.jpg (83.26 KiB) Viewed 7597 times
- 9.jpg (170.97 KiB) Viewed 7597 times
Re: TM1 Contributor very long save the values copied from
Posted: Sun Jan 19, 2014 10:09 am
by Slava79
- 10.jpg (197.5 KiB) Viewed 7577 times
- 11.jpg (224.21 KiB) Viewed 7597 times
Re: TM1 Contributor 10.2 very slow copy paste and commit
Posted: Tue Jan 28, 2014 6:27 am
by EP_explorer
Try to install FixPack 1. It seems may help.