About Misbah

Misbah

@TanishaSharma No, there wasn't any as far as I know. Misbah

Misbah

@Shanlovin There was platform maintenance release during the weekend and services are usually down during that window. See this Upcoming Maintenance: January 15 2022 - Anaplan Community Misbah Miz Logix

Misbah

@1635834 Is it always going to be two texts in a line or could it be any number of texts? And if any then what would be the maximum number of texts that you may receive Misbah Miz Logix

Misbah

@jimfeng5 Instead of OFFSET can you try LAG(Final Revenue,y,z) and see if that works. Usually when there is a circular reference with OFFSET we use LAG. Hope that helps Misbah <Miz Logix>

Misbah

@Livy You can use NAME function to get the #ID's of Numbered list

Misbah

@JaredDolich I wish and hope that you do it way before than I do. You are a gem of a person. @JamiesonC Quick Chat Option on Community, More accurate search functionality on community, taking our Groups "Modelers Forum India" to new heights. And yeah, Non repeatable goodies for Community bosses: P

Misbah

@1635834 There is a function "COMPARE" which can compare Texts but that will not tell you what is the difference, it is only going to tell you that there is a difference by returning values like -1,0 or 1. You can leverage COMPARE function with other functions to get to your result Hope that helps Misbah Miz Logix

Misbah

@vaishnavip933 Until Mr.Murphy responds to you, here is what we know . There is a waiting period of a week or two due to huge demand. I would say wait for few more days - You will receive an update from Anaplan. Misbah

Misbah

@Shawnm No, you don't have to pay extra if your organization has Professional or Enterprise edition license. Big query Indeed is supported by Anaplan CloudWorks. Read more here https://help.anaplan.com/96f951fe-52fc-45a3-b6cb-16b7fe38e1aa-CloudWorks Misbah Miz Logix

Misbah

@JaysonCFormentera Are you using Custom Views or Module Views? If Custom Views then you will have to apply the filter directly in the NUX. If Module Views then it should work the way you are describing it. If the problem persists then it may be worth opening a ticket with anaplan support Thanks, Misbah Miz Logix

Misbah · Re: Level 2 Sprint 1 1.3.10.3 Import Data into G3 ...

@zoecassell Can you please check “Configure” tab of G3 list and see if you have parent field updated? If not, make sure it’s updated and re run the action. Misbah Miz Logix

Misbah

@JaredDolich Thank you! And you don't let me sleep over it, you keep chasing me :D. Your contributions to the community is priceless. @DennisL Absolutely! Everybody deserves a shout out. Let me add few more, these too have been great in contributing towards community @einas.ibrahim @DaanishSoomar @ChrisAHeathcote @anand.shekhawat @AntonMineev

Misbah

@anjacksonms If you don't have overrides then it will show only 0's which means there won't be any color formatting. Try Input any override and see if it works. Misbah Miz Logix

Misbah

@Kanishq17 It obviously has to RANK first, otherwise CUMULATE will work in an order in which the list items are arranged. So rank comes first and then it cumulates all the values corresponding to the ranks. This function is really helpful in Allocation. Let us know if you still need more explanation. Misbah Miz Logix

Misbah

@EmmaPF As far as I know I don't recall any activity which asked us to change OFFSET to LAG in INV01 Module OFFSET to POST is what I could recall - that there was an ask for it. But anyway LAG and OFFSET should work as intended The only difference is that if you use positive numbers in the syntax of OFFSET you will have to use negative number in LAG syntax. Here I have tried to explain LAG with diff scenarios, see if this helps Understanding LAG Function - Anaplan Community Misbah Miz Logix

Misbah

@jasonfortunato You are very close. I see there are a few issues here since you are trying to use all LOOKUPs in one formula. That might not work. Follow this Shipping method needs to be pulled from SYS07 module into INV01 Module in its own line item. Call it Shipping method and format it on Shipping method list. Use the formula = 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Distribution Center] Now you don't need three mappings - you only need two i.e., on Product and Shipping Method You need to type "LOOKUP:" before each mapping. So in your case you will have to write additional LOOKUP just before your two mappings and remove third mapping from your formula. So the formula will look like - Shipping Time Weeks[LOOKUP: Product, LOOKUP: Shipping Method] Note: This is logically right formula but not necessarily technically. Hope that helps Misbah Miz Logix

Misbah

@jasonfortunato Error 5 Level mismatch on common dimension - I don't think I have mentioned "Line items are dimensions". What is written is all the line items of the module are dimensioned by "Transactions". "Transactions" is a list on which the module has been created meaning that list has been included in the module at the time of module creation or even after that. So whatever you see in the "Applies to" section of blueprint view of the module that can be considered as the dimension of the module along with Time and Versions (Time and Versions are also treated as dimensions of the module if they are included in the module) Hope that helps Misbah Miz Logix

Misbah

Thank you so much mentee/(s) and congratulations to all other mentors who have made a huge impact on other community members. Looking forward to another fantabulous year ahead! I would like to thank my mentor @rob_marshall for being such a great human being and nice colleague I wish I had known when I had started working a decade ago. Shout out to @JaredDolich for killing it.

Misbah

@neg177 All these are paid services. Anaplan too offers you good instructor led model building activities. We at Miz Logix too offer instructor led model building activities. To know more reach out to us at info@mizlogix.com Thanks, Misbah Miz Logix

Misbah

@Nishant20201 Please share the mapping window of an import Misbah Miz Logix

Misbah

@NISHI Welcome to Anaplan World and to this amazing group. People here are helping in nature and will surely help in your journey. Misbah

Misbah

@CommunityMember127578 You can take advantage of these options. There is no other way to change the font size of the text, although there are ideas that have already been submitted regarding this. On pdf exports, I don't think that Reports can be exported out. However it can be presented directly without taking the exports, that's the beauty of report page Hope that helps Misbah Miz Logix

Misbah

@JPani To answer your questions correctly you need to make sure that the name of the module as well as name of the line item is exactly matching with that of Training. Spacing, naming convention plays important role, so go back to the training content and make sure that everything is as per the training. Hope that helps Misbah Miz Logix

Misbah · ‎12-17-2021

@gulmuneer As far as I know they need to be imported. You don't have to select them manually although there is an option for you to do it. Just figure out where do you need to import it from Thanks, Misbah Miz Logix

Misbah · ‎12-17-2021

@gulmuneer Every Employee will not have Leave Date updated. There are only 14 Leave fields updated which I believe is already uploaded successfully. You can scroll right and check if Leave Dates are updated for those 14 odd employees. I think they are. Country should be Imported, double check in your source file if country is available or not Misbah Miz Logix

Misbah · ‎12-17-2021

@JagadeshNarayanan Well, I am not sure if it is being imported from PLAN IQ or calculated within Anaplan once PLAN IQ results are out. Let me tag one of the best @timothybrennan . Misbah Miz Logix

Misbah · ‎12-17-2021

@gulmuneer First of all go back to the import window and come to below screen and hit this button so that you ignore what is not mapped. Second, Go to SYS08 module, double click on Name line item so that the formula bar gets activated and reference Display Name of Employees list. Make sure that the format of Name line item and Display Name Property is same. Formula that you will have to write in Name Line item of SYS08 module may look like this 'E2 Employees#'. Display Name. Misbah Miz Logix

Misbah · ‎12-17-2021

@hyudolee I don't think there is any work that has been done on the comparison of the performance of these aggregation functions. I have a feeling that these two will perform almost similarly. Misbah Miz Logix

Misbah · ‎12-17-2021

@gulmuneer Go to Employees list and search for Display Name Property. Use that property into "Name" line item of SYS module. Misbah Miz Logix

Misbah · ‎12-17-2021

@hyudolee There are only 5 exceptions given by Planual in order for us to create Subsidiary views. Read more here 2.01-06 Avoid Using Subsidiary Views - Anaplan Community Yours does not qualify for any exception. As @JaredDolich mentioned create another module for it. Hope that helps Misbah Miz Logix