2.4.7 Activity: Create Saved Views for UX

ankulkarni
ankulkarni
in Academy Discussions

My DEM03 gROWTH RATE% FORMULA: 'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family] It went through, however in further training 2.4.7 of Sprint 2 it is asking me to create a saved view which should look like ( below screenshot  as per the course)

ankulkarni_0-1615495357472.png

But this issue is my DEM03 contains PRODUCT FAMILY and not SKU ( as per above lookup) hence not allowing me to get the sku details, the view I have is as below 

ankulkarni_1-1615495441061.png

can someone please guide on how to fix this issue? 

 

Best Regards

Ankur Kulkarni 

 

Comments

  • JaredDolich
    JaredDolich

    @ankulkarni 

    Good question and you're not alone. You'll need to go back to the course where you build out DEM03. I think you'll find, with careful examination, that the module should be dimensioned at SKU and Account. I'm guessing the instructions aren't super obvious. So, change from Product Family to SKU and you should be good to go. 

  • ankulkarni
    ankulkarni

    Correct, checked again and worked, Thank you 

  • kunle
    kunle

    Hi @JaredDolichPlease can you help?

    I have created a saved view as required for this activity but my work is markedly different from the example provided and i have not been able to figure out why.

    Here is my saved view as opposed to the example

    1.PNG

     

    2.PNG

    Here is how i set up the Pivot for the Saved view

    3.PNG

     

    However i think the issue may have to do with my DEM03 Demand Forecast Model and here is how i set it up:

    4.PNG

    5.PNG

    6.PNG

     

    Thank you for your help.

     

     

     

  • JaredDolich
    JaredDolich

    @kunle 

    You're in great shape! You just need to apply the filters or remove the levels. Me personally, I use filters because I may want to change my mind later or have it be dynamically filtered.

  • kunle
    kunle

    Hi @JaredDolich ,

    i have tried to apply filters as advised but struggling to achieve the screen. Please can you help with how i need to set up the filters.

    This is the view i am trying to achieve:

    2.PNG

     

    Thank you.

  • vfrank
    vfrank

    Hi @kunle @JaredDolich 

    Even I am stuck at the same point, did you happen to find the solution for this.

    I am unable to get the view specified .

     I need Initial demand Forecast and Final Forecast columns to be shown  by month.

    Currently I see a full list of Initial demand forecast and then to the extreme right I see full list of Final Forecast Columns.

     

    Any help would be appreciated.

Categories