About ashish.banka

ashish.banka · ‎02-02-2022

@philip.austin It has worked for me. The only issue with "Tabular Multi Column" is that it brings in all the line items while exporting.

ashish.banka · ‎10-01-2021

wow!!! Neat and Clever. Awesome @Hayk . And I agree with @JaredDolich to have TODAY() function in Anaplan lists of functions.

ashish.banka · ‎09-25-2021

This is amazing. This opens up immense possibilities for people to know and learn about the importance of connected planning. Highly recommended.

ashish.banka · ‎09-14-2021

Hello Group, I know you must have faced this but wanted to check whether there are any plans for Model Archival APIs in the roadmap. It would be a great time saver for Admins.

ashish.banka · ‎09-14-2021

Thanks @kevin.cho for sharing. This would make life much easier for Admin jobs.

ashish.banka · ‎09-06-2021

@aakash Although I have not encountered this issue but I can say that the error messages in Cloudworks are somewhat misleading. Also I have seen that it takes a bit of time when you try to create an Integration process and connect to Workspace / Model / Process for the actions to show up but it does show up after a bit of wait. I would say, you can try couple of times to see if the issue still persists and then raise the issue with support@anaplan.com as suggested by @alexpavel AB

ashish.banka · ‎09-06-2021

@Scorina This is interesting. I haven't experienced this with my user base. Although most of my user base are SSO enabled, but few are "exceptional" users and they never complained about this. I would raise a support ticket at support@anaplan.com to get more details about the issue. AB

ashish.banka · ‎08-31-2021

@ninja247 It seems that you are looking at the toggle button on the home screen. As you need to change the view of the models, either you click on the "Model link" or "View all models" for the toggle screen to show up. AB

ashish.banka · ‎08-29-2021

@capitalsteev @angomez @Manikantaap29 Email to academy@anaplan.com. They should be able to help you out related to your training accounts. If the issue is related to your organization tenant, check with your organization tenant admin. Ab

ashish.banka · ‎08-29-2021

@Jacob3 That's a great question. Look at the screenshot below: On your Point #1: Mapped To column values do align with "Target Item" values (the green color confirm that the values in "Target Items" are mapped to one of the source values. You can also confirm by checking the code of "New York" in G3 Location list and seaching for the same code in Source module G3 Location column). The reason the do not see New York as the first value in "Mapped To" column due to sequence in which source values are displayed. As source values as "codes" of G3 Location, Anaplan automatically maps it to the Mapped To values code. Hence the Green color. You can also the the radio button selected in above sreenshot which might help your understanding. On Point #2: Target Item shows all the values which are part of the hierarchy (rollup) but grays out the items which cannot be mapped as part of the rollup. As the mapping is between G3 Location code of Source to G3 Location name of Target, the rollup values in Target Items are ignored. On Pivoting: The Line Item which you see while pivoting is a container of all the line items created in the module. Once you drag the Line Item to Pages, you should be able to see the values in the Line Item container which would be "Volumes" as suggested by @ChrisAHeathcote AB

ashish.banka · ‎08-28-2021

@Jacob3 On your first point: " Though I did not get any errors after importing the data and mapping, the G3 Location Tab does not look right", just wondering why do you think the G3 Location mapping tab does not look right. If you check G3 Location List, you must have codes associated with each List item. So we you can use the source data code to map to the G3 Location list item in mapping and this the the recommended approach. On your second point: "Secondly, the pivot table in the line item view has to be changed. The volume needs to be before the Nutzo Bar. See mark up on Line Item screenshot (attached file). I do not know how to change the line item view.", you can change the view by clicking on the pivot icon and moving line item (which stores "Volumes" to Page. AB

ashish.banka · ‎08-26-2021

@akssaju Look for the Forecast Year weeks. I guess it would be starting 1st week of FY20. You should be able to see values from FY20 1st week onwards and would be same as Volumes of 1st week of FY19 onwards. AB

ashish.banka · ‎08-25-2021

@JaredDolich @Misbah Finally I got my Anaplan Solution Architect 2022 certificate. And I cant thank much to the academy@anaplan.com team. They helped me with a "trick" wherein, after passing the exam, to download the relevant certificate, click on the relevant certificate link. It will open up a page with the status of the exam. You just need to click "Enter" button to generate the certificate and then user your browser "Print" option to save it to PDF. Hope this helps to all who are struggling to download the 2022 certificates. AB

ashish.banka · ‎08-24-2021

@hsich1020 I guess the L1, L2, L3 and the certificate exams should be the basis of the enablement program however, I would suggest, any enablement program is incomplete without functional / domain knowledge along with data analysis and data integration skill. I would definitely add such supplemental courses in the program. AB

ashish.banka · ‎08-24-2021

Thanks for sharing. This is a great hack / help 🙂 AB

ashish.banka · ‎08-23-2021

@Minhle246 Have you tried using LOOKUP for Account, Company code and Department while referencing the amount? AB

ashish.banka · ‎08-21-2021

@Misbah This is strange. For me 2022 Certificate Exam shows "Checked" however the 2022 Model Model Certificate And 2022 Solution Architect Certificate check box shows unchecked. When I click on any of the certificate link, it asks me to "Enter" and shows "Number of Attempts you have made as 0" Seems to be an issue with the whole certifications links. I have emailed the issue to academy@anaplan.com but it did not solve the issue. @ChrisMullen Can you help? AB

ashish.banka · ‎08-20-2021

@sarathkumar New UX is a great new addition to Anaplan Platform. I would suggest you go through the training course to get the details about the New UX and as per Anaplan, New UX is the way forward creating better reporting and dashboarding experience for business users New UX Courses link: https://community.anaplan.com/t5/UX/ct-p/platformux You might want to go through the feedback posted by the community members: https://community.anaplan.com/t5/Anaplan-Platform/New-User-Experience-Feedback/m-p/52909#M10306 AB

ashish.banka · ‎08-20-2021

@JaredDolich I just passed my SA recertification exam. However, I am not able to download the 2022 certificates. It takes me back to the Exam page. Is there a glitch in the certificate link. It used to be quite smooth earlier. AB

ashish.banka · ‎08-20-2021

Thanks @ChrisMullen . This was a great refresher of the new functionalities added within Anaplan platform.

ashish.banka · ‎08-13-2021

@Misbah Looks like you are looking for this link: https://community.anaplan.com/t5/Anaplan-Platform/Performance-Comparison-OFFSET-LAG-PREVIOUS-LOOKUP/m-p/51140#M7603 @KirillKuznetsov Hope above performance comparison can provide the details you are looking for. AB

ashish.banka · ‎08-13-2021

@KirillKuznetsov That's a great question. I guess for the scenario which you are looking for, PREVIOUS would work better when you need to refer to a numbered value around Time as I guess PREVIOUS has been designed to work best for Time. These are my thoughts and would like to hear from other experts too. AB

ashish.banka · ‎08-13-2021

Thanks @JaredDolich for sharing this. This is of great help.

ashish.banka · ‎08-10-2021

@PhilippErkinger Great question. I would love to know whether that is currently possible. AB

ashish.banka · ‎08-10-2021

@sophiedyason You need to leverage Anaplan functions to achieve these (You can try Lag, Offset etc) Please refer the functions available in Anaplan : https://help.anaplan.com/186d3858-241b-4b78-8aa5-006fc4260546-All-Functions AB

ashish.banka · ‎08-10-2021

@rtearp You need to be either an SSO enabled user or NON-SSO Enabled user. Just wondering whether you can change the SSO enabled user to a NON-SSO Enabled user for the training purpose. You can still be a WS admin as a NON-SSO enabled user. AB

ashish.banka · ‎08-09-2021

@ShekharGite I am trying to understand the requirement here. In a numbered list formatted line item, generally, business users would like to see the "display name" (which you might have defined in the Numbered List properties) to show. And when you copy the selected Numbered List from the line item, you would like to paste the "display name" not the code. If you want to copy the code of the numbered list, you might would like to create a line item, as text format, to get the code of the numbered list (code(item(<Numbered List Line item>))) and copy the code to the rest of the editable cells or use the "copy cells " across / down as suggested by @KirillKuznetsov AB

ashish.banka · ‎08-09-2021

@Shivanshu As Anaplan trail access needs to have specific amount of workspace allocation, it might take some time. I would wait for atleast a week for the access. However if you want to know the status, you can send an email to academy@anaplan.com or as suggested by @KirillKuznetsov AB

ashish.banka · ‎08-09-2021

@aakash It seems to be anaplan connect configuration / Path setup issue. Can you try navigating to the folder where anaplan connect file is stored and executing the anaplan connect for that path. It might help in figuring out the Path / configuration issue. AB

ashish.banka · ‎08-07-2021

@Dishank I am not an expert in batch scripting, however I would suggest to check the run the code in debug mode and check the value " userid" before assigning it to "AnaplanUser" variable. I just googled for how to read a file in batch script and found a link: https://www.tutorialspoint.com/batch_script/batch_script_reading_from_files.htm which might be helpful to consider. AB