Platform

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 · ‎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.

debbie5154 · ‎10-08-2018

I do believe that you've uncovered the reason Mr. Smith. Thanks so much for your response.

debbie5154 · ‎10-05-2018

Oh my, an example would be fantastic. Thanks.

debbie5154 · ‎10-05-2018

Thanks again for all your help. Your suggestion did not work but got me to an answer....by changing in blueprint to version not applicable, I get the result i need see pixs below:

debbie5154 · ‎10-05-2018

and here is the version info Why would one come as actual and one as plan....they are coming from the same import and how to fix it???

debbie5154 · ‎10-05-2018

Weird....here is the drill down for the other field from the same module:

debbie5154 · ‎10-05-2018

ok let's give this another try. Import file: I need this transaction data and then i need summarized data for reporting. I need a line chart with current year gallons and prior year gallons as seperate lines x axis = week y axis = current gallons, and prior year gallons Please let me know if you need more info....and please make the answer best practice...and simple so i can understand. thanks for your patience....with my tired, and very old brain.

debbie5154 · ‎10-05-2018

Yes weird....

debbie5154 · ‎10-04-2018

. I have two modules with the same dimensions. I’m bring fields into the calculation module from the import module. I’m bring fields into the calculation module from the import module. This works fine for tons but not for percentage distribution. I created a test field and change time scale to year and the values show up (summed for the year 100% or 1): Here is the import module the data is coming from: I can’t find a reason for this to happen and like I said I tried to chat with support but my chat kept getting canceled. This works fine for tons but not for percentage distribution. I created a test field and change time scale to year and the values show up (summed for the year 100% or 1): Here is the import module the data is coming from: I can’t find a reason for this to happen and like I said I tried to chat with support but my chat kept getting canceled.

debbie5154 · ‎10-04-2018

sorry but what does this mean? providing your row list has a top level (you should have one) Also I was instructed to make everything that I've made for this example. I'm beginng to believe that the one way, and maybe only way to make Anaplan work is to add every possible field you need to your data import. I've tried reading thru this complete thread, a couple of times, and I just get confused and when I ask a question it is not always answered....I appreciate that you all are trying to help me...but you're just confusing me....and asking me to post additional pictures seems like a typical IT delay tactic.

debbie5154 · ‎10-02-2018

time scale on activity data import module = week = i.e. Week 11 FY18 "weeks of year" is the list I created per instructions below to have a generic "week Number" (with no date)

debbie5154 · ‎10-02-2018

I can see where me having "extra" fields trying to figure out how to make this work...could confuse. BTW I removed the fields I didn't think you'd need to see. LOL Ok so how do I get: "In your module activity numbers (the one with the rows), this is where you need to have a line item "week number" where you do item(week of year)." week of year is not a dimension, row numbers are by adding a field as part of the data prep OR is there some formula to bring it in from list = weeks of year? Thanks!

debbie5154 · ‎10-02-2018

you are correct...my issue is how to get the gallons to show up in module from the import module, please see pictures I posted earlier....how can i reference the week number when it's not in the import? What is the formula? sorry but this has been very frustrating for over a year now....I keep trying and setting it aside and trying and setting it aside....anytime I've tried to map data from an import like this activity one...where row number is the dimension...i get error regarding no hierarchy. but then sometimes it works and i find a way around it by adding yet another column to the data import. It's sounding like that's the only way to map from modules with row numbers is by ever increasing the imported columns.I'm starting to doubt that this the right way to build...so that's why I'm attempting to get a better answer, again. THANKS and I apoligize for my frustrated tone. I do try to find my own answers on the forum but hours/days of looking and here I am. I would have posted before but until the recent redo of the community I had not been able to find a place to post a question...and I have asked...just never got an answer.

debbie5154 · ‎10-01-2018

So when I import my data I need to include a column for week number? BTW I'm only going to import the file once and then I'll use LAG to get prior year. Thanks for helping with this.

debbie5154 · ‎09-27-2018

Thanks so much for the response. I'll busy today with the weekly data load so may not get a chance to review until tomorrow , but I will get back to you.

Platform

Academy

Master Anaplanner

Programs

About debbie5154