level 2 model building sprint 3

Hi,

I am at level 2 model building where I would need to create a UX page. one of the requirement is to "create stock exception count by product SKU and total for parent product at monthly, half year and year time period". The time scale in the INV01 Inventory ordering module is weekly. I presume the UX page grid will be taken from this module. in that case, how can I create a saved view to show only the summary at month, half year and year level without the weeks please?

Thank you.

Accepted answers

ManjunathKN

Hi @Zhiying

you need to put filter in your INV module.
something like this.

Thanks,
Manjunath

All comments

ManjunathKN

Add a filter in that module from your system modules of time. Put the filter "any".

Can you save the view.

Thanks,

Manjunath

Zhiying

Hi @ManjunathKN,

Do you mean creating another line item to filter for month only in the SYS time system module by week? If so, what formula should i be using to create the boolean formula to have only the month, half year ticked?

Thank you.

ManjunathKN

Hi @Zhiying

you need to put filter in your INV module.
something like this.

Thanks,
Manjunath

Zhiying

Hi @ManjunathKN,

Seems to work well now. Thank you!

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…