DTP is taking long time while loading data from DSO to cube or Cube to Cube
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.