SAC Story: How to derive a dimension value from the property of an another dimension

[SP9]

Hi Experts, 

We have an SAC Story requirement where the data would be input on Location, Material, Date, Version, Amount (Measure) of a measure based planning model. It also has Account type dimension, but it's value should be derived automatically from Material's property, which is an account.

So, Materials: M1, M2, M3 has property called Account with values: A1, A2 and A3 respectively. 

Locations are L1, L2

Dates are preiods: From 202501 to 202512

Version: public.Budget

Measure: Amount

Planning Story would be like this:

            Version: Budget

            Measure: Amount

            Date   202501   202502     .... 202503

L1   M1         100           

       M2         200

       M3         300

L2   M1        150

       M2        250

       M3        350

Once saved, we would like to have the following in the database (model data) with Account valued derived from the Material's property: Account

Version  Location  Material  Account   Date      Amount

Budget   L1           M1           A1          202501  100

Budget   L1           M2           A2          202501  200

....

Budget   L2           M1           A1          202501  150

Budget   L2           M2           A2          202502  250

.....

Thanks,

SP

[William_Yu]

Hi SP9 , 

   I think it's not easy to achieve only with story. I would propose below: 

1. User input data in a table booking all data to a dummy account.
2. Instead of standard publish button(you can hide it via customized toolbar) , you create a button to trigger data publish via API.
3. Before you call the publish API, you trigger a data action which will book data to the target account based on the material property.

Best regards, William 

Best regards, William