on 09-15-2014 6:16 PM
Has anyone utilized HCI to populate Key Figure CAPASUPPLY in S&OP? If so, what was your source of data? Did you use ECC SAP tables? how did you populate future periods?
Hi Laura,
You can populate future buckets using add_month function for KEYFIGUREDATE mapping:
1/ add_months ( to_date ('01' || to_char($G_LOAD_DATE, 'mmyyyy'), 'ddmmyyyy'), 'Number_Sequence')
- where 'number_sequence' is the column name from a flat file where you store records from 1 to n (n - depending on the number of buckets that you need)
This only works in case of a flat file import as you need to add this helping file to your data flow as a second source and map it to the target query.
We hope that having 2 different sources in one dataflow (ECC and file in this case) will be available in the next release.
2/ you could generate values for KEYFIGUREDATE in the preload script
Hope this helps,
Alecsandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.