Level 2 Sprint 3 Stock Exception Review Dashboard Help

Options
nsherman
nsherman Member, ALL USERS Posts: 2 New Contributor
in Anaplan Community

Hey! I've been trying to figure out how to create the 3rd grid for the Stock Exception Review Dashboard. This is the view with creating a grid that shows Safety Stock Flag Count by period at the SKU level.

 

I was thinking I need to create a new line item with a lookup, but thinking I'm over complicating things!

 

Any hints/tips appreciated to guide me in the right direction! 

Tagged:

Comments

  • nsherman
    nsherman Member, ALL USERS Posts: 2 New Contributor

    And that's when you realize you were looking at the wrong module to add. I was looking at INV02 and trying to build a look up there. No wonder I was struggling.

     

    Thanks @einas.ibrahim!

  • LinaCorrea
    LinaCorrea Member, ALL USERS, Partner, Community Member Posts: 5 Occasional Contributor

    @einas.ibrahim Einas, thanks for your contributions!

    Even tho the requirements for this dashboard, SKU Level and periods within a year, the INV01 module nees to be also connected with the country/region filter, right?  so I need to connect somehow the Region dimension so this last grid shows the SKU detail also by country/Region?

    Thanks for you help

     

     

  • cbeh
    cbeh Member, ALL USERS Posts: 5 New Contributor
    Hi Einas,

    I can show the INV01 sku exception for the selected product family and for the month period. But I cannot figure out how to show only the skus for the selected region from INV01. It is as if I need a filter somewhere. Am I understanding the requirement correctly? Would appreciate some guidance.

    Thank you.
  • rentiller2
    rentiller2 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 New Contributor

    Hi @einas.ibrahim 

     

    I am also struggling with syncing data from INV01 with the Region context selector on the card since INV01 is not dimensionalized by Region.  I initially solved this by creating a new module but it looks like that was not the correct solution and I'd like to correct it before the exam.  Is the intent that you don't sync that section or was it correct to create a new module.  Could you help me to think about this correctly?

     

    Thank you!

  • sbiswal92
    sbiswal92 Member, ALL USERS, Community Member Posts: 3 Occasional Contributor

    @einas.ibrahim 

     

    If I create a new view to accommodate for that 3rd grid & choose the time-scale to be month in this view, I notice that the parent INV01 module also switches from week to month ( which will affect my other dashboard pages)

     

    Is this behavior intended ? If so, how do I prevent INV01 from changing?

     

    Thanks.

  • sbiswal92
    sbiswal92 Member, ALL USERS, Community Member Posts: 3 Occasional Contributor
     

    <Pic1.jpg> In order to obtain this 3rd grid, I am building a new view based off INV01 and choosing the time-scale in this view to be Month.

    <S2.jpg> But when I make this Week to Month, the parent i.e INV01 also changes its time-scale from Week to Month.

     

    Is it okay for views to modify parent modules? This is not a question for this module but any module and view in general.

     

     

  • sbiswal92
    sbiswal92 Member, ALL USERS, Community Member Posts: 3 Occasional Contributor

    @einas.ibrahim 

    Ok that explanation helps.

     

    Now coming back to the issue that is problematic for me.

    After I create a module and import data, I am allowed to build different views based on this module I just created, right?

    If I modify one such view in terms of time-scale, the same change also reflects in the module from which I created the view (which you explained will happen)

     

    So, in that case,  creating a view on INV01 based on P3 SKU, Time (weeks) and Stock Exception  and changing the time-scale to Month is not the right way to go about it ?

     

    If this is not right, what alternative method do you suggest to load data onto the UX-Page?

Categories