About debbie5154

debbie5154

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

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!

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?

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

debbie5154 · ‎03-04-2020

I'm looking for the link mentioned in today's broadcast...Anaplan Talent Builder. Thanks.

debbie5154 · ‎09-24-2019

So excited....I'm almost done with Level 1 and I'm really enjoying and learning a lot. THANKS!

debbie5154 · ‎08-14-2019

Thanks for taking the time on this article. You give me hope.

debbie5154 · ‎08-09-2019

From my father: Honesty. If you always tell the truth you don't need to keep track of your lies. From my son: Always live your life with positive intent.

debbie5154 · ‎03-21-2019

Love that when I change the name of a field it changes everywhere....I no longer have to live with a name that no longer makes sense. import from Excel, load & chart by generic week #, easy dynamic date filtering on charts....more chart formating options, more formatting options in general, ability to copy modules across models, ability to see which fields are being used by a field (like Excel)....sorry you just wanted one <sheepish grin>

debbie5154 · ‎03-21-2019

Thanks for sharing your experiences.

debbie5154 · ‎03-21-2019

YAY to customer 0! Did not know about this before. Good work.

debbie5154 · ‎03-21-2019

Sorry, I missed what you said about "When is Anaplan Appropriate?"...is it part of playbook? If so where? How Many "C" should be yes, to build solution in Anaplan? BTW really loved your presentation. Thanks, Debbie

debbie5154 · ‎03-21-2019

BTW survey done...just didn't find a place to put this comment. 🙂

debbie5154 · ‎03-21-2019

Seriously this was like 1/2 day of sessions at Hub in Vegas but I didn't have to travel. THANKS!!!!

debbie5154 · ‎02-07-2019

I live in Turlock, California and work in Modesto, California....that the central valley, for those that don't know. Started Anaplan training in August, 2017, but didn't start working in Anaplan until January, 2018. Really love the comment: 'every day is a school day' with Anaplan! Cause it's so true...wish I had time to start re-build what's been built. Hope to learn even more about Anaplan from the group.

debbie5154 · ‎01-31-2019

Lots of "stuff" rolls up to site, but they don't all relate to each other. For example: Fill rate rolls up to site but has no relationship to the grape programs, which also roll up to site. Also if there is an item that could possible roll up thru grape program to site, there would be tons of sparcity. So I'm currently sticking to the old hierarchy. Thanks!

debbie5154 · ‎01-28-2019

Based on suggestions from the last AMA Pierre Kerkinni & Jon Mavetz - Model Building Solutions I've changed my hierarchy. Now when trying to build modules that roll up to site sub sets I get an error about common anscestor...which was why I built the hierarchy the way it was before. We have several hierarchies that roll up to site but don't relate to each other. Any suggestions would be appreciated. I'm pasting the new & old hierarchy below: Old (works but is clunky): New (get common anscestor error):

debbie5154 · ‎12-10-2018

Thanks for taking my questions. relationships in my model: Region is 1 to many Sites. Site is 1 to many Grape Programs. Site is 1 to many Containers. Site is 1 to many Harvest Profile Types. Harvest Profile Type is 1 to many Grape Programs. Family is 1 to many Grape Programs. Grape program is 1 to many Draw Programs. Container is 1 to many Fill Rate Winelots. Data: Grape deliveries are tons by week by grape program, profile type, & site (I calculate down to Draw Progam level). Family is a way to group grape programs by site. Inventory is by week, container, & fill rate winelot. Here is the hierarchy I've constructed: Just wondering your opinion, best practices....should I make changes to my hierarchy? Thanks.

debbie5154 · ‎11-26-2018

Will I be able to attend thru WebEx? Thanks, Debbie

debbie5154 · ‎11-06-2018

This group looks like the closest one to me. Name: Debbie Leonard Company: E & J Gallo Winery Work Area: Rough cut capacity planning Anaplan Role: model builder What I Hope to Get From This User Group: meet folks that help each other use Anaplan

debbie5154 · ‎10-24-2018

Thanks Mr. Smith. I remember that from the HUB in Vegas! But good to remind all of us.

debbie5154 · ‎10-23-2018

Thanks to Surya.Arif and obriegr for taking your time to reply. I'm learning alot about what is needed when asking a question in the forum. I'll do some more trouble shooting based on your suggestions and post back to this thread. THANKS!

debbie5154 · ‎10-22-2018

I have the following nested if, for the highlighted line item (see picture): IF NOT 'exclude' AND 'Sum fill rate gallons actuals' > 0 THEN 'Sum fill rate gallons actuals' ELSE IF 'Sum fill rate gallons PY' > 0 THEN 'Sum fill rate gallons PY' ELSE IF 'fill rate gallons FOR movement avg' > 0 THEN 'fill rate gallons FOR movement avg' ELSE 0 The highlighted row should be returning one of the other line items and it's giving me complete different results. There is no version on this module or the module the original data comes from. Any thoughts, or is my formula too complex? Thank you so much for any suggestions.

debbie5154 · ‎10-16-2018

COOL! THANKS!

debbie5154 · ‎10-15-2018

Thanks so much for taking the time to respond.

debbie5154 · ‎10-12-2018

I have a module with imported data. Some line items need to be editable and some do not. to make a line item not editable It seems there are two ways to do this... 1. create extra line item that references, and then hide the line item i don't want to be editable 2. use dynamic cell access I'm wondering folks opinions of which is best or have I missed another alternative. Thanks.

debbie5154 · ‎10-11-2018

My sincere apoligies...I've seen answers from Anaplan employees so hoped they would participate. David Smith answered my other question this week. I also tried to contact Anaplan support, but no one has been available. My frustration got the better of me, and there is no excuse for my tone or words. I appreciate the community aspect of this and the helpful nature of the members. Thanks for calling me out!

debbie5154 · ‎10-10-2018

Are we going to get more functionality for charting? I really don't like having to show EXCEL charts with my Anaplan dashboard.

debbie5154 · ‎10-10-2018

Ok let's try this again. Here is the chart I've been able to create...however the time scale is not generic week numbers....so the prior year data labels reference the current year...it can be very hard for the user to see the data value and know which year the data belongs too. That's why I took the approarch of setting up a list of "week numbers" to use in place of time scale...and I almost got it to work but can't get my data to map to the gerneric week numbers. It seems like I'll have to tell my director that Anaplan CANNOT chart year over year and have accurate data labels. I've spent another five hours searching the Anaplan community today, but cannot find an answer....plot 2018 values overlayed with the 2017 values. Been trying to solve this on and off for over a year...guess EXCEL is still better at some things. I hate having to make one chart in Excel....maybe we move all the charts back to EXCEL. Can someone give me the true word....can this be done or not...and if so who can show me? Sorry for my tone but I'm so frustrated that I can't get help....and lately every time I try and chat with support NO one is available.

debbie5154 · ‎10-10-2018

Sorry but I still need an answer to this thread....thanks.