-
1. Re: Unable to load multiple UDA's to a Planning Dimension using Data Management.
JohnGoodwin Dec 27, 2018 6:31 PM (in response to 3792291)1 person found this helpful -
2. Re: Unable to load multiple UDA's to a Planning Dimension using Data Management.
3792291 Dec 30, 2018 8:48 AM (in response to JohnGoodwin)Hello John,
Thanks for the inputs.
I have tried hard coding the second UDA into the flat file as below and none of them worked. (My delimiter is |)
"UDA1|UDA2" & "UDA1| UDA2".
Tried Mappings as (* to *) & (* to "*")
The UDA is getting loaded a literal string in all scenarios. I am not sure what else I am missing.
Thanks,
Manoj
-
3. Re: Unable to load multiple UDA's to a Planning Dimension using Data Management.
JohnGoodwin Dec 30, 2018 3:03 PM (in response to 3792291)The output from Data Management for multiple UDAs will need to be enclosed in quotes, the UDAs will need to be split by either a comma or a tab depending on the load rule target option - "Member name may contain comma"
If "Member name may contain comma" is set to yes, Data Management will create a tab delimited file that is loaded to PBCS, if it is set to no it will be comma delimited.
Here is an example with it set to no.
source file, split by PIPE and the UDAs are split by comma, if you want separate columns for the UDAs then you could join them using a mapping and a lookup dimension
Rule target option set to no so the output file generated from DM will be comma delimited.
Mapping to add quotes for the UDA
Workbench
File generated by DM before loading to application
Multiple UDAs created in application -
4. Re: Unable to load multiple UDA's to a Planning Dimension using Data Management.
3792291 Jan 26, 2019 6:22 AM (in response to JohnGoodwin)Thanks a lot John.
In my file I had the pipe delimiter between the UDA's. I had changed it command as you suggested and it is working.