source with more dimension than target

Miia · 2024-02-15T10:54:38+00:00

There was an error rendering this rich post.

Miia

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

Accepted answers

All comments

ChrisAHeathcote

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

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?

ChrisAHeathcote

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

Miia

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…

ChrisAHeathcote

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

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.

akashsingh

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

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…