cancel
Showing results for 
Search instead for 
Did you mean: 

Upload/copy paste to table level not to model in SAP SAC Story

0 Kudos
157

Hi Experts!!

Here is the requirement!!

we want to copy paste from excel to SAC table /Story. While copy pasting it is taking time and performance is poor. is there any custom widget or solution to upload a file just to story table respecting filters not to model level.

Note:

1.Kindly don't recommend Upload starter , as our model has many dimensions to map, where user file doesn' t have , it has to pick up story/table level filters.

2. We have already pre-populated the data to initialize the combinations with zero's , as our data is a NON-SAP data at discrete level. (validation rules will not work as we have more than 8 dimensions)

using CSV or Excel file just upload data to story at table level only (Not via Upload/Import Jobs from model)

Model level /upload starter we tried , but we have to write custom logic to fetch other dimensions 

 

Thanks

Surya Harsha

 

@William_Yu  

@N1kh1l 

 

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

If copy & paste not preferred and upload starter is not feasible( because model year & factory is not part of user data),  my only suggest would be:

  1. Still use upload starter to upload user data to factory =  # and model year = #
  2. Run data action to allocate uploaded data to desired factory/model year combination based on your pre-filled ratio/weight.