cancel
Showing results for 
Search instead for 
Did you mean: 

How can we insert a data record into an SAC planning model

madireddy_rahulreddy
Participant

We have a requirement where we are giving a simple user input screen to user in SAC. We have to save the entered data to a planning model with few dimensions. Can you please share some information on how we can insert data records into a planning model? Can this be done using Data actions? The measures in the model are actually irrelevant. We only need to save dimension information to be used for a few custom admin functions within SAC. We are able to update dimension members using create members planning function but this is not what we are looking for(this doesn't create any data rows in the model). We are also able to update the key figure values in a the model using the setuserinput function along submit/publish(This helped with only updating the key figure values but this doesn't post a new data row in the model). But we are unable to insert a completely new transaction record into the SAC planning model.

We are planning to use Analytic designer to make this happen. Can anyone suggest on what the best way is to fulfil this requirement?

Accepted Solutions (1)

Accepted Solutions (1)

JefB
Active Contributor
0 Kudos

For me it's a clear gap in the SAC planning product.

Suggest you vote for this enhancement request:
270692 - Plan on (copy-paste) multiple new lines in a table

Answers (3)

Answers (3)

azy_pather
Advisor
Advisor
0 Kudos

Hi Rahul

If you create a table, select the required dimension members, and set all dimensions to "Unbooked" data, entering the data values and publishing will insert new records into the model.

Regards

Azy

JefB
Active Contributor

In my experience that only works for very small models with just a few dimensions...
The performance will exponentially get worse for each unbooked dimension added, as the carthesian product of all possible combinations gets too large for the front-end table to handle.

madireddy_rahulreddy
Participant
0 Kudos

Hi Azy, Apart from what Jef mentioned, with this method, we lose the ability to run validations. For example, when users are inputting data into the table, we have to do certain validations on date fields etc. In the method you specified, we will be able to insert any value and we will lose the ability to run validations. We need a way to do this via scripting or any planning functions such as data actions( using APIs provided by SAP)

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi madireddy.rahul,

Analytics Desinger scripting is mostly used to create customer specific interaction with user interface. To insert data into planning model, it's recommended to use data action. You first create data action by using either copy step or advance formula step based on user requirement logic, then you can trigger this data action from application either through through standard button or via API.

Best regards, William

swathi
Explorer
0 Kudos

hi rahul

To do this as the first step we will try to create Dimensions, after dimensions are created we will load Master Data into the Dimensions. After master data is loaded into Dimensions, save the Model to create Planning Model. As the last step we will try to load the Actual Data into the Planning Model.

Thank You.

madireddy_rahulreddy
Participant

Hi Swathi,

All of the above requirements need to be done via scripting in an analytic application. The business users want an input screen to enter data to save to planning model. We can udpate the master data using planning functions such as create members but we are unable to insert records into the planning model via scripting. The Business users will not have access to model itself to update the data via excel.