1.4.4.1 Create Build SKU Saved View (Product column)

mimi816
New Contributor

1.4.4.1 Create Build SKU Saved View (Product column)

Hi, for the following activity, I should have product names shown in the "Product" column. However, my result doesn't have product names showing, but it has product names showing when clicking the arrow. Could anyone help me figure out what am I missing here?  

 

mimi816_0-1659209640162.png

mimi816_1-1659210007875.png

 

mimi816_2-1659210135296.png

 

7 REPLIES 7
JaredDolich
Moderator

@mimi816 

You're on the right track. Almost there.

  • For the system module you will import the product value.
  • SYS12 uses the "SKU Flat" list
  • Make sure the line item is formatted as "Products Flat" which from your description sounds like you got already.
  • Once the data is loaded you can create your saved view for your "Try it" hierarchy that uses P3 SKU list and has a parent of P2 Products.

 

JaredDolich_1-1659211058498.png

 


Jared Dolich
mimi816
New Contributor

@JaredDolich it seems that I met all the criteria that you mentioned. However, I do not quite understand"

  • Once the data is loaded you can create your saved view for your "Try it" hierarchy that uses P3 SKU list and has a parent of P2 Products." Could you please include a screenshot of this step?? Thanks! 

mimi816_1-1659220179263.pngmimi816_2-1659220200069.png

 

 

JaredDolich
Moderator

@mimi816 

Terrific news! The first step is to get the data loaded into that system module SYS12, so you're good to go. Soon, you will be asked to build a structured hierarchy using the product system modules. The first step is to create a saved view that allows you build the P3 SKU hierarchy, so you'll need three values: The name, the code, and the parent. Of course, when you load the "Try It" hierarchy you always load structured hierarchies top to bottom as you will soon learn. In a real implementation of Anaplan the data hub has no structure. All the properties are saved in system modules including the parent level. The reason is we don't need to plan in the data hub so there's no point in taking space up for aggregations. Way to go!

JaredDolich_0-1659222599401.png

 


Jared Dolich
mimi816
New Contributor

@JaredDolich my general list is the same as yours but there's the Product line below that is still not picking up the products...

mimi816_0-1659223565759.png

 

JaredDolich
Moderator

@mimi816 

You're closer than you think. Just check your mapping.

JaredDolich_0-1659223792850.png

JaredDolich_1-1659223816102.png

 


Jared Dolich
mimi816
New Contributor

Bingo! I didn't map it correctly before. Thank you for the screenshot, it's good now!

JaredDolich
Moderator

@mimi816 

Awesome job! Don't forget to mark the post as solved. This will help others find the answer if they have the same challenge.


Jared Dolich