source with more dimension than target

Options

l

Line items: source-target ok

period: source-target ok

sales group: source-target ok

product group: source-target ok

order type: list exists only in source - OrderTypeTotal -value should be transferred to target

delivery channel: list exists only in source - DeliveryChannelTotal -value should be transferred to target

Problem: Errors generated from DeliveryChannel & OrderType

Expected month name or number in date/period: DL1 Delivery Channel

Expected month name or number in date/period: Order type

Answers

  • Hide these two columns in the source data.

    If they do not need to be mapped then remove them….you should also be using a saved view which has been created specifically for the data import action.

  • Miia
    Options

    Hi,

    "Hide these two columns in the source data" - they are lists, not column items.

    In the source module there are two more lists than in the target. How to hide lists in the source?

  • The alternative is to create a staging module where these lists are removed and then use this as your source.

  • Miia
    Options

    Yes - that could be one option. Always trying to save space so maybe one option could also be to "dublicate" / add extra line item with "the required dimensioty" into existing module and add the rule: new item = current item. Hmmm…

  • Try placing the unused lists into context selectors and in the mapping screen mark these as not required.

    Ensure that the saved view has these set at the top level.

  • Miia
    edited February 16
    Options

    Hi, This is something what I have already tried - even putting them in the context and selecting/defining only top-levels in the saved view… the same problem is faced when doing mapping in import.

  • Hi @Miia


    Conceal these two columns in the source data.

    If they are not required for mapping, delete them... Additionally, ensure you're utilizing a saved view tailored for the data import process.

    Thanks,

    Akash