About JaredDolich

JaredDolich

@Stacey_Gibbens How you discovered the issue is mind-blowing! When you say you removed the filter, do you mean the filter on the saved view or that you deleted the Boolean line item? If its the filter then that would be very puzzling because imports are agnostic to any view. Also, if it's a filter, is it on the default view or a saved view? As for the Excel limit, @MagaliP will soon be announcing the next Excel Add-In upgrade will have an Excel limit increase to 5MM from 1MM rows that may also help with the export challenge you've got. Anxious to hear what others have to say and what support comes up with. Thanks for posting this!

JaredDolich

@khooton You're on!! Will reach out and discuss with you. Thanks!

JaredDolich

@YelenaKibasova @VictorB + @ChrisWeiss @Beauram @Ameneh @AaronW @HannahT @emilydunn Question for Victor. Given the pipeline is so sparse, is there a way to leverage the existing programs at Anaplan that would help encourage an interest from a broader population? Some ideas: Master Anaplanner Mentor/Coach University Connect Outreach Expedited access to the free 90 day trial program Discounted Level 1 training (scholarships?) Anaplan Group targeting diversity? We have a lot of specialty groups but maybe this is one that can be used just for conversation as well as Anaplan Or, maybe nominating some people to help co-lead the groups. This one is probably rather controversial, but was wondering if we can leverage the Anaplan Partners to build a consortium to open up some internships. The thinking here is that we need to move people up to the front of the line by providing opportunities and access to decision makers. An internship could provide both. I have many more ideas. Would be happy to discuss if appropriate.

JaredDolich

@cpalm @Rahul_Rathod @dennyp This has now been logged as a known issue. https://community.anaplan.com/t5/Known-Issues-and-Workarounds/In-the-NUX-Header-labels-on-grid-don-t-wrap-on-white-space/m-p/99318

JaredDolich

@Katya This has now been logged as a known issue. https://community.anaplan.com/t5/Known-Issues-and-Workarounds/In-the-NUX-Header-labels-on-grid-don-t-wrap-on-white-space/m-p/99318

JaredDolich

@dennyp @rob_marshall This has now been logged as a known issue. https://community.anaplan.com/t5/Known-Issues-and-Workarounds/In-the-NUX-Header-labels-on-grid-don-t-wrap-on-white-space/m-p/99318

JaredDolich

@riyazpasha Awesome! How about one of these idea: Use Breakback Use a System Module BreakBack - use breakback if you need the allocated value to be editable. Here, I edit the parent "300" and it automatically allocates evenly since all the child records are zero. Use A System Module. Create a system module for your child list Add a list formatted line item for the PARENT Add a counter so we can sum up the children reporting to the PARENT. Put a "1" in the formula and call it "Count" (sorry, I didn't show this line item below) In your planning module use the aggregate values from your system module to properly allocate evenly to the children. Stand up and Cheer!! You did it! System Module

JaredDolich

@Katya Thanks for adding this. So, the New UX used to wrap on words. I've already filled out a support ticket and it's been escalated to Level 3. Hopefully, this will be considered a bug and be fixed soon.

JaredDolich

@saranshsaini There's something odd about your P3 SKU list. P3 SKU Flat looks okay though. Your DAT03 Volumes module should be dimensioned with Accounts Flat as well. Do you have that set up? Minor issues but I suggest you reload P3 SKU with the correct item values. Should look like this:

JaredDolich

@Misbah You're right! It says "Source Module" but takes you to the model. Good catch. Hope this is corrected soon.

JaredDolich

@aishabhy05 The error you're getting in both scenarios appears to be because the import actions were saved as "Private". That's why it asks you to choose a file. For each import run it again but this time save as "EVERYONE". Name your import with the same name as you have now and it will retain the ID. Then you can run AnaplanConnect scripts using the same file name. See if that helps!

JaredDolich

@riyazpasha Great question! One that Anaplan has two answers for. You can always use breakback and seed the lower level with your percentages. Try using the PROFILE functionality. Let me know if you need an example! You got this!

JaredDolich

@Rahul_Rathod Thanks for the suggestion. One that would be great if it wrapped on the word. But it doesn't. It's cutting words in half but should be wrapping on the spaces between words. Great callout though!

JaredDolich

@cpalm @Rahul_Rathod @dennyp This issue has now been raised to Level 3 support. FYI.

JaredDolich

@dennyp @rob_marshall This issue has now been raised to Level 3 support. FYI

JaredDolich

@Belson97 Take a look at grid view on the list. Make sure your Product Family codes are loaded. You may need to reload it. If that looks good lets take a look at the details of the errors as @rob_marshall suggests.

JaredDolich

@Belson97 Oh, so so close. Make sure you Product Family Line item is formatted as a list "P1 Product Family". Looks like its formatted as a number. Try it again. You got this!

JaredDolich

@lhidden My Pleasure. In this case you will need to create two modules. A monthly system module so we can calculate our monthly values in one place A daily system module so we can calculate the new date In the Monthly System Module - Here's the blueprint and grid. We will need both Month+2 and Month+3 for when the date is the first of the month. You will also need to create a time range that is one year past what you will need at the daily level. Your Daily Module will lookup the monthly values and bring them into the equation. Use your normal model calendar. Note: You'll need to account for the year change and I added the line items in the monthly system module that you'll need. I'll leave it as a puzzle for you to solve in your daily module. Results match your test script.

JaredDolich

@lhidden Ooooh, I like this question. I think you can do this with the DAYSINMONTH() Function. So add up the days in month for the next three months then subtract 1 day. Will that work? I can create an example for you if need.

JaredDolich

@Shawnm I don't think you can do that with the Anaplan native connector. I'm pretty sure that's possible using DirectQuery or using a data mart/data lake in the middle. So instead of sending your Anaplan data directly to Power BI, you first go to a data lake. Then put it on DirectQuery or use a scheduler to refresh the data.

JaredDolich

@Priyankakota159 One idea that might work is to clear your cache or try another web browser. Sometimes incognito mode with chrome will work too. Adding data integration pro @dsoomar002 - he may have an idea or two as well.

JaredDolich

@ankitaga2000 I've seen this before in other courses. As long as you can move on to the next lesson you'll be fine. Even if the checkbox is missing, it has recorded you as complete. If it's preventing you from moving on, then follow @Misbah suggestion by sending a note to academy@anaplan.com.

JaredDolich

@Shawnm I believe this will only work with Desktop because you need to create a data source. My recollection is that in cloud you can't go into designer mode. If you can find way in cloud to create a data source your all set.

JaredDolich

@vinaygvk07 Yes. Thanks for sharing this. I added this to my own list of best practices. I had a feeling there was a good solution. Nicely handled!

JaredDolich

@ujourney + @Misbah and @RAJASEKAR I believe this functionality is there now. Look for the ellipsis on the upper right corner of the card.

JaredDolich

@cpalm I just added a screenshot above - and also sent to support. Hopefully, they can put the header wrap back the way it used to be.

JaredDolich

@cpalm +Adding @rob_marshall @Misbah Yes, I thought it was me. But you're right something changed. Word wrap isn't wrapping on the words. It's cutting them in half. I'll fill out a ticket to support@anaplan.com. You may want to do the same.

JaredDolich

@akshaysawant Right! Because your TARGET doesn't use Product you need to have a top level so Anaplan can "SUM" the product hierarchy for you all the way to the top. It can't SUM product to the first level because you may have multiple P1's. Thank you for this very great question. Very advanced thinking!

JaredDolich

@akshaysawant Great call out. This happens if your structured hierarchy doesn't have a top level. Make sure your lists are arranged as shown below. Breakdown of the error: This is one exception where you don't have to use SUM Your TARGET module uses the same hierarchy as the SOURCE module so SUM is not necessary since Anaplan already knows how to aggregate the data. You just need to make sure there's a top level so Anaplan can sum it to the top if PRODUCT is not used.

JaredDolich

@titanic_neo Also another hint. You're very, very close. Use the SUM function on Region and Role from your SYS08 module. Breakdown: YOu need Medical costs from EMP02 which uses Employee as a dimension but your TARGET module, REP04 is dimensioned using Region and Role. So you need to convert your employee dimension to region and role. Your SYS08 does this! Remember, you always use SUM on a list formatted line item. So your formula will look something like this. EMP02.Medical Costs[SUM: SYS08.Region, SUM: SYS08.Role] You got this!