Bring weekly data into a daily module

debbie5154

this should be easy but I just can't get it.

I have a weekly module with inventory cases...snapshot is done on Wednesdays.

Anyway trying to take that snapshot and have it show up in a daily module on the Wednesday date.

Any help would be greatly appreciated. I'm trying to avoid making the inventory cases a daily module.

Thanks,

Debbie

Accepted answers

rob_marshall

@debbie5154 ,

I think I get it. First, I would not add a SKU line item in the source with Time as SKU will not be changing over time, so it is wasting space. So, in the source, say your code or unique list is 100_200_300_400 where one of those is SKU. Dimensionalize this by time, at the week level which is what i think you have.

Then, create a module by SKU and time, still at the week level and this is where you do the sum (data[sum:target module.SKU]). Now, for the target, you can create a module dimensionalized by SKU at the day level, and you can do a lookup using a SYS Time Filter module dimensionalized by Day with a line item showing the week (SKU.Data[lookup:SYS Time Filter Day.Current Week]) where current week is the line item in the SYS Time module.

Hopefully that makes since, if not I can put some pictures together to help here.

Rob

All comments

Tiffany.Rice

Hi @debbie5154

I believe you should be able to use the WEEKVALUE formula to pull data from your weekly inventory module into the daily module.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/WEEKVALUE.html

If you only want a value to display on Wednesdays you may consider using the WEEKDAY formula in conjunction with the an IF statement and the above formula. Roughly I would envision the formula to be: IF NOT the third day of the week then 0 ELSE WEEKVALUE(target line item)

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/WEEKDAY.html

Hope this helps get you pointed in the right direction.

-Tiffany

debbie5154

@Tiffany.Rice Thanks for the quick response. I tried the WeekValue but because the two modules don't have the same dimensions...I need to use a SUM

WEEKVALUE(Inventory Import Weekly.Cases[SUM: Inventory Import Weekly.SKU])

and get the following error:

"The WEEKVALUE function may not take an expression as it's argument, only a line item or property."

does this mean the modules have to have matching dimensions?

rob_marshall

@debbie5154 ,

To be able to help you better, it might be more helpful to give more details such as:

other than time, do either module share a list?
if not, are you trying to get the sum of the target (the one with multiple lists) or are you trying to get a certain weekly value by doing a lookup?

Rob

debbie5154

@rob_marshall

thanks for quick response...it always seems like a simple question but I understand wanting more info 😉

Source Module: Dimension by unique key...composite of SKU, Inventory Status, site, etc. I've add a row that looks up the SKU (list).
Time is week.

Target Module: Dimension by SKU (list); time is daily.

Need to bring row "cases" from source to target based on SKU. By adding the "sum by" the weekvalue() wont work. Ideally the value will only show up on target on a Wednesday...but I can always "lag" and "if" to get that.

Thanks!

rob_marshall

@debbie5154 ,

Hopefully that makes since, if not I can put some pictures together to help here.

Rob

debbie5154

You got it and thanks for the help from @rob_marshall and @Tiffany.Rice

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…