on 05-20-2015 9:05 AM
Hi ,
When i try to load the data from DSO to cube or cube to cube , dtp is taking long time.
we are using dropping?creating step in PC.
we are loading 10 lakhs records which is taking 1.30 Mins.
No Start/End routine. No formula.
In DTP monitor, i found it is taking time in "Conversion of Characteristic Values to SIDs" step.
could you please advise.
Regards,
Vinay Saraf
Hi Vinay,
This error is coming because SID is generated at the time of loading data to info cube. So better to create SID at the time of activation of DSO only. So data loading will be good and time will be less because conversion of characteristics to SID will be avoided.
Loading data from cube to cube is rare.
Follow DTP performance activities also.
Thanks,
Swapna Jain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vinay,
Anyhow, you loaded master data first and then you are loading transaction data. So SID is generated at the time of loading master data only. But if for some characteristics SID is not generated, then it will get generate. Now the question is When it should be created?
You are transferring data from DSO->Cube right. First you are loading data to DSO but you are using it as a staging layer so skip SID generation upon DSO activation.
But if you are having reporting on DSO then you should do SID generation upon activation. So the reporting performance will be good.
Thanks,
Swapna Jain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think you should avoid creating Semantic Groups because it introduces an extra overhead of sorting and grouping the data before it is loaded into the target.Please check if the cube has been compressed.Since indexes are created on the F-fact table,if the cube is not compressed the index creation as well as deletion steps will also take time.
Regards,
Shalaka
Hi,
can you increase the parallel process in the DTP screen.
increase to 3- 6 process.
select the DTP -> go to the go to menu-> select setting for batch mangaer -> increase the process -> save it execute the DTP.
check the process avalibility in SM50/51.
-Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Phani,
We can use this option, when we have enough Background Job.
When this DTP will be running most of the Jobs will be occupied.
I want to know what this " Conversion of Characteristic Values to SIDs" does.
This is happening in Most of the DTP when we try to load to cube.
Is anything we are missing?
Regards,
Vinay Saraf
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.