I already mapped the building code in that screenshot.
We are now thinking of creating a staging module in our FPA removing building code in the applies to and replace by #Numbered list then put the building code in the line item.
I created a concatenate of GL Code and Building code to create the #Numbered list staging to store the data and will just link from the staging to the reporting module.
Thanks for the support.
I am sorry. I know that i am late to this discussion but i replicated your scenario and it works well for me
which means Numbered list codes in my data hub are automatically mapped to Numbered list Codes in my spoke model.
I am not sure why are you facing this.
But one question to you
1. Have you first loaded the numbered list to your FPA model...?
I think you might have forgotten to load numbered list.
Before loading to the values or data to the module first you have to load the list.
DM me when you get up and running and we can figure this out.
Guys, thanks for helping. We decided to convert the list to a normal list instead of using a numbered list. We limited the character to 60 to avoid errors.
Booo!!!!!! Offer still stands if you need it or want it.