Level 2 sprint 3 Build Distribution Summary Dashboard

In the activity following instructions were given, where I am confused with the highlighted one

1) Applying a filter to DAT01 Beginning Inv - I am confused as in how to show which Product SKU is stored at which distribution center, what i thought was in the line item Nutzo bar EN SKU & New york as distribution center should be equal. is that not correct?

2) SYS 07 & 08 want to show label of selected DC & Product. but I am confused about how to acheive that. As i am not seeing any option in DB to enable that

Comments

Misbah

@kunal_311

Pivot your SYS07 module and bring your Line items to Rows and Distribution Center to Pages

Pivot your SYS08 module and bring your Line items to Rows and SKUs to Pages

That should give you what you want

Hope that helps

Misbah

@kunal_311

On Point 1 - I think you can pivot it and bring SKUs and DC in rows and Line items in Columns and apply filter on SKU/DC combination and not on line items.

Note: It's been long since I have taken this course

kunal_311

Yupp got this one

kunal_311

Hi @Misbah

Pivot part understood, Coming on formula, still not able to encode it

The Excercise statement said - Filter to only show which product SKUs are stored at each Distribution Center

which means filter needs to set on the mapping of product SKU & DC. which I tried implementing filtering on SYS08 module as it has both DC as well as product details , but not getting the result, can you please help me with the understanding.

FILTER_0_80096.jpg

kunal_311

@Misbah

I was able to figure it out. Thank You for your guidance.

RemRemRem

I'm still stuck on this exact spot...any tips that helped you get past the hurdle? I'm now headed towards needing to make an additional line item, which doesn't feel right.

Thanks,

-R

swapnil_J

TRY with line items from SYS07 module, DAT01 module and SYS08 module

augustus.perera

appreciate some directions..

I bringing month ending, inventory balance values for different SKU's from Module INV01 to Module INV04 .

Here INV01 : Weekly Time, P3 SKU

Here INV04 : Monthly Time, Distribution centre locations

I wrote:

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Invent

The result I get is like below, i.e. Feb 20, inventory of New York reads 115,941...but the 115,941 is the ALL Product-All Location total for Feb20. Its duplicated.

source module

swapnil_J

Dimensions of INV01 module are Time, Distribution centre locations and INV04 module are Time, P3 SKU.

Mismatch dimension Distribution centre locations, P3 SKU.

You have Beginning Inventory Data in INV01 module.

In INV04 module T.B Inventory you need to sum the Beginning Inventory according to Distribution Center locations.

Since the dimensions do not match you need to make use of another module.

augustus.perera

Hi Swapnil

Thank you for direction, I tried below...

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Ending Inventory[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Distribution Center'] ELSE 'DAT01 Beginning Inventory'.Beginning Inventory gave an error msg like below.

However I need to bring...Monthly Ending Inventory (in other words Monthly Beginning inventory Feb 20, sku1 + sku2 + sku 3 to calculate the fill rate for Feb 20, based on the location capacity, refer target module screenshot)

with previous function I get the total All product i.e 115,941 total duplicated to each sku, any method to extend the formula?

my attempts.

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Beginning [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Distribution Center'] Inventory ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Beginning [SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center'] Inventory ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

swapnil_J

You have already created the formula for Beginning Inventory line item in INV01 module.

You don't need to rewrite that formula in T.B Inventory line item INV04 module.

try with this :

INV01.BEGINNING INVETORY[SUM: ......]

augustus.perera

Hi Swapnil

Appreciate the direction, Thank you.

mmanocha

@kunal_311 Please help me how to figure this out. I am stuck at the point of Distribution center - Product SKU Grid.

Thanks in Advance

ryan_kohn

FYI @mmanocha @kunal_311 I have moved this post to the Academy & Training forum.

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…