About ashish.banka

@Misbah Thanks for the quick response. I got below files as part of L3 Tech Exam   and the Baseline file which I got was during L3 Model building activities. Do I need to use that file for L3 Tech Exam?   ... View more

@CommunityMember128917 Unfortunately if you are using Anaplan Connect for integration and automation of data file loads, the "Operation" statement does not have an option to generate log file, however it does provide an option to generate error logs if [[ "$ANAPLAN_CREDS" != "" ]] then     AnaplanUser="$AnaplanUser:\"$ANAPLAN_CREDS\"" fi Operation="-debug -service ${ServiceUrl} -auth ${AuthUrl} -workspace ${WorkspaceId} -model ${ModelId} -chunksize ${ChunkSize} -file '${FileName}' -put ${FilePath} -process '${ImportName}' -execute -output '${ErrorDump}' "   Now if you want to generate log files, you need to output the execution of Anaplan Connect script into a file. So if you are using UNIX OS, you can use ">>" operator to output the execution of the Anaplan Connect into a file.   Hope this helps.   AB ... View more

Hello @praba71  It seems that you are looking for Time Setting setup for the module. As your data is for rolling month, you can setup the Time -> Model Calendar -> Calender Type as "Calendar Months / Quarters / Years, set up the Fiscal Year Start Month, Fiscal Year Label, Current Fiscal Year, along with Current Period and Select Quarter Totals      Hope this helps   AB ... View more

@rspector I am just wondering, why you need to create a line item "Customer Type" when the list item members does have the "Customer Type".   So, even you want to keep the "Customer Type" Line Item, as values of "Customer Type" Line Item and and List Item values are same, so to publish Customer Type Values and the corresponding "Select" boolean line item to dashboard, you can select "Select" boolean Line Item, Right Click, Select Show. Create a view for the selected "Select" Line Item and "Customer Type" list and publish it to the dashboard.   Hope this helps AB ... View more

@NSH To learn and work on Anaplan platform, you need to have access to Anaplan workspace.    As @naushad786 mentioned, you can get a trial period access to Anaplan platform. However this trial period access is available for specific individuals within an organization   *Anaplan is only considering non-profits, government agencies, health care providers, pharmaceutical companies, and academic institutions for this free trial. Anaplan will review all applications before granting access to workspaces.   Regards Ashish  ... View more

@NSH Are you trying to login as Single-Sign-On or by providing email id and password?    Generally once you click on the download link, it takes you to Anaplan login page and then you can login the same way (SSO or by email authentication). The model would get download in the workspace which you have access to. Go to Manage Model, look for the model which you have downloaded and click Open to open the downloaded model.   Ashish  ... View more

@Kaho You are right as per import mapping is concerned. You might need to look at Time mapping as the file has different format than the model calendar. You would like to use specific Date Format pattern to load the data into the module.   Hope this helps Ashish  ... View more

@tlemond You need to look for a module which has product details so that you can map Source module to Target module. And just to add for the lookup to work, you need to look for line item which is source list item formatted. You can find more details in Anapedia: https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Formula%20Usage%20Tips.htm ... View more

@rachelwatsky For complete the training, you just need to know the instructions. I guess, if the instructions are suggesting to create a module and load it data from the csv file, you first need to create the required list, load data in the list from csv and use the list in the module to load the data. This is the process to load the data in any module: 1) Create List 2) Load Items in the List 3) Create a module using the list as Applies to 4) Load data in the module   Regards Ashish    ... View more

@sguptatalkingrain Glad to know.   Keep learning and keep sharing!!!   Ashish Banka ... View more

@sguptatalkingrain Not sure I understand the screenshot which you attached. Looks like you are trying to load data into a module for Region Code. Do you really need to do that? If you already have a code for Regions in a list, you should try to refer the code of the list in the module using a function rather than loading the code. Hope this helps Ashish  ... View more

@Srivaths123 Performance of the data load depends upon how optimal is your Data Hub Model design. I would highly recommend to go over the best practices for designing Data Hub: https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866   Generally I would design my Data hub load following best practice scheduling jobs to run at off-peak hours, split large volume of data in smaller chunk and load data in sequence. This has given me better performance for data loads. Another practice which you can follow is to load only incremental data which would reduce the volume of data load processing providing better performance.   Regards Ashish ... View more

@Srivaths123 You may want to look at ways to optimize the Data Hub. Few things to consider: 1) How much historical data needs to planning purpose? Identify the Modules and use Time Range feature in Model Calendar to reduce the transaction data module size. 2) Look at the possibilities to check whether the modules, having max cells, can be limited using List Subsets. 3) Look at the possibilities to create Lists based on transaction data and use those lists in the modules to reduce sparsity.   Regards Ashish   ... View more

@cpalm You can leverage List Subset capability to control the list items which needs to be displayed in the modules and the  corresponding dashboards.   Regards Ashish Banka  ... View more

@einas.ibrahim  I agree with you on the  professional ethics and the training exam rules. However I was just making sure the training steps were followed and was referring to the error message attached. ... View more

@SourceIT if you want to learn the platform, you can use 90 days trial license https://www.anaplan.com/anaplan-helps-trial/     ... View more

@Gita It seems that the list which are being used ' EMP03 Employee Drivewrs by Role' module does not have Top Level Item specified in Config tab of those lists. Hopefully once you add the Top Level Item to those lists, you can get rid of the error.   Hope this helps   Ashish  ... View more

@neg177 You are so close. While updating the formula from EMP01 module to EMP03 module, you need to look for a mapping between EMP03 module role with SYS08 Employee Details module.   Hope this helps   Ashish ... View more

@sprender Using Form in NUX does help on Numbered List. However if the Form uses a module which has "dependent list", the form breaks the dependent list mapping.   ... View more