4 Replies Latest reply on Jan 26, 2019 6:22 AM by 3792291

Unable to load multiple UDA's to a Planning Dimension using Data Management.

3792291 Dec 27, 2018 5:46 PM

Hello Experts,

I have a issue with loading Multiple UDA's into planning.

One UDA is coming from source file and other UDA is common for all the members which I have defined in Import Format. I have provided the data load mapping as (* to "*") but no luck. I had tried with comma and semi column but none worked.

What should be the delimiter for loading multiple UDA's from DM and Can I add the second UDA in import format?

Thanks in Advance,

Manoj

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)

An example of the format is in the following post - Load multiple UDAs to PBCS

Cheers

John
1 person found this helpful
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 3 Likes(3)

Actions
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.
Like Show 0 Likes(0)

Actions

Go to original post