2 weeks ago
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
Hi SP9 ,
I think it's not easy to achieve only with story. I would propose below:
Best regards, William
Best regards, William
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.