Importing Data at multiple level

Hi,

I am trying to build a model which contains 7 different levels of product from the region, country, .., brand, to SKU level. The problem is whenever a user adds an SKU for a perticular city it is also automatically added to every other city and occupies a lot of space. How do I solve the space issue and give users ability to process data at different levels?

Accepted answers

All comments

Misbah

@Nachiketa

If SKU is part of the same hierarchy then I don't think that is even possible. Can you share a screenshot of your hierarchy and the creation of SKUs

Misbah

Nachiketa

It is a multi-dimensional model. 3 different dimensions are location(containing 4 child), Customer (3 child) and product hierarchy(7 child).

ankit_cheeni

Hi,

What I understand is that you have a separate location list/hierarchy and a separate product hierarchy. When you add a new SKU, you are ideally adding it to the product hierarchy independent of the location hierarchy. Since you are using location and Product hierarchy as dimensions in the same module, you are creating a matrix of (locations) X (SKU).

Basis your list setup, it doesn't seem like SKU is City dependent so I am slightly confused on what you mean by adding an SKU for a city. The way you've setup your module, you will see the SKU for all locations and customers.

Using so many lists as dimension will explode your model size. I would recommend turning off the summaries on each line item and checking if some of them can do without all the dimensions being present for them. If your use case really requires you to have a City - SKU mapping, maybe create a separate concatenated list of City and SKU.

Cheers!

ChrisAHeathcote

@Nachiketa

If you would like to remove the sparsity the most effective way to achieve this is to create a fourth list which contains only the valid combinations of the three lists.

Create list formatted properties in the list to contain a reference back to each of the separate lists for mapping purposes.

This approach will contain a very dense list and minimise the amount of empty space and you can then use the list properties to map data back out to the separate list if required.

Nachiketa

Can you please elaborate.

Nachiketa

Yes that what I am doing creating a matrix of location X SKU and every time I add new SKU model just blows up.

ankit_cheeni

Hi @Nachiketa

Lets try to think about it using this:

If I know that not all SKUs need to be mapped to all cities, my matrix will be very sparse. If you see the table, we have 25 cells being used (5 SKUs * 5 Cities) out of which I actually only need 6.

What you can do is create a separate concatenated list of the form SKU_City to define all combinations of SKU and City. This will reduce you module size from 25 to 6 in our example and helps you reduce the size drastically.

Let me know if this makes sense.

ChrisAHeathcote

@Nachiketa

This fourth list would contain as properties only those combinations of the other dimensions which are valid.

As an example;

Customer1_BrandB_Product10_SKU1

This list item is the combination of customer, brand, product and SKU lists. As properties you would have list formatted items assigned to each of the individual lists so you could map data out of this combination list into any combination of the other four dimensions.

If you were to add these as separate dimensions you would be creating combinations of all four lists which do not exists.

Nachiketa

Yes this exactly what I want. Now how do I do this.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385