About ankulkarni

ankulkarni · ‎08-13-2021

I am trying IF ELSE condition with LEFT/RIGHT function to spot the 3rd character

ankulkarni · ‎08-13-2021

Well Substitute function won't work as it is a series of projects and we have to remove the 3rd character specifically if 0

ankulkarni · ‎08-12-2021

I want to create a new filed and a logic where the input will be project name which is a combination of letter and and digits. The new input field should replace '0' in the 3rd place of the project. E.g- PROJECT NAME: PR120 then new calculation field should remove '0' in the 3rd place what can be the syntax to remove or not consider 3rd digit if '0' Thanks Ankur Kulkarni

ankulkarni · ‎08-12-2021

Hello All, Currently our team is new to Anaplan and thus have hired a vendor to build a solution for our company, the challenge is that there is no document in place which explains the technical and functional aspects of solution that has been built so far ( Model building/ user guide) can anyone help us with a template or document sample so that we can modify and ask our vendor to update it Objective:-1) Model builders ( Beginners) should be able to understand how the model was build and maintaining solutions if some challenge comes up 2) This document should help end user to understand the process (SOP Draft) Currently the vendor does not have any document in place Thank you

ankulkarni · ‎08-12-2021

Thank you for replying @abhay.kanik currently we have 3rd party contractors using Anaplan for business purpose, as of now every employee logs into Anaplan via SSO and business wants to set a rule for termination of user license for certain period and this can be based on No Activity / or even if a straight rule of license deactivation for those users is set is also ok. Secondly, if we proceed with automation of licensing is this achievable? Thank you Ankur Kulkarni

ankulkarni · ‎08-11-2021

Hello all, I am looking for a solution wherein we set a specific time period ( 6 months) for certain users and post 6 months their access should be automatically terminated? is it achievable ? Thank you Ankur Kulkarni

ankulkarni · ‎03-22-2021

Thank you Jared, upon checking my DAT02 module in level 2 model had 0 values so re imported and everything works fine. However, assignment view has 'ending inventory values different from week 5 onwards compared to what i got. 1st screenshot is of assignment 2nd screenshot is of my model building result and 3rd screenshot is of the formulation. I happen to check the source file as well for values. I am confused as my ending inventory is positive 2nd screenshot- my results 3rd screenshot - line item formulation

ankulkarni · ‎03-22-2021

For Shipping Time weeks, below was the logic i applied and it went through, however the data i am getting is '0' 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] to further break down i searched for other modules for shipping method dimension but no luck, the shipping method within INV01 module is not a numbered format unlike others so may be it must be an error, got stuck. Can someone please help me understand Best Regards Ankur Kulkarni

ankulkarni · ‎03-22-2021

Correct, checked again and worked, Thank you

ankulkarni · ‎03-11-2021

My DEM03 gROWTH RATE% FORMULA: 'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family] It went through, however in further training 2.4.7 of Sprint 2 it is asking me to create a saved view which should look like ( below screenshot as per the course) But this issue is my DEM03 contains PRODUCT FAMILY and not SKU ( as per above lookup) hence not allowing me to get the sku details, the view I have is as below can someone please guide on how to fix this issue? Best Regards Ankur Kulkarni

ankulkarni · ‎11-04-2020

Hello, The csv file contains country name, code and parent, but needs to be imported as a flat list. A) There is no way we can leave the fields blank while importing as it is throwing errors B) Can i make changes in the source file itself to just get the countries? We do not want the parental hierarchy c) I have just mapped parent to country name ( import completed, but with errors) Is this the right way? Kindly advice, Best Regards Ankur Kulkarni

ankulkarni · ‎07-16-2020

I just tried by re importing the data and it worked, even though for one answer i cannot make edits. Thank you for giving me the perspective

ankulkarni · ‎07-15-2020

Data was successfully imported, mapped and formulation was correct as well in EMP02 module W.r.t EMP03 and SYS08 however, the value for Dec 2020 is not the right answer. Now I am confused as in what exactly went wrong. Can somebody please guide? Thanks

ankulkarni · ‎07-14-2020

The issue was with one of the dimension which i corrected and was able to solve. Thanks Einas!

ankulkarni · ‎07-14-2020

I need to set Employee drivers by Role, so i created a list and imported roles data into it. 1) what should be my parent hierarchy in this case - All roles? or All departments? since i had initially created Employee hierarchy with E1 departments - (All Departments being at the top level) then #E2 Employees with E1 department as parent hierarchy. 2) What is a remove time dimension? do I have to delete the time dimension or is this something else, need clarification Thanks

ankulkarni · ‎07-14-2020

IMPORTING STEP 1 STEP 2- I already tried using Date: YYYYMMDD ; FIxed position YYYMMDD and then chose match name. step 3 STEP 4 STEP5 FINAL OUTPUT Can somebody explain the correct way

ankulkarni · ‎07-14-2020

Data is present in all the hierarchy and I was able to apply the formula too Problem statement:- I did pull data ( volume) from DATAO2 into REV02 module and referencing REV02 module I need to find volume for cities w.r.t product In this case I want to check FY19 total CHOCOLATES consumed in Japan and I can even filter cities and products but the volume remains unchanged. E.g if you see first cell for Jan 19 the volume is 706,982 which is constant for every item.

ankulkarni · ‎07-13-2020

Hi, I have created a new list called 'SKU' which needs to be added at the bottom of product hierarchy for SKU's. I have denoted the hierarchy and tried importing the data. Can someone please correct what's going wrong. Thanks STEP 1 STEP 2 STEP 3 ERROR HIERARCHY Thanks

ankulkarni · ‎07-13-2020

Hello, My goal is to get the 'total volume' of product being used for certain year by different cities. Below are the two data set which have been successfully mapped into Anaplan I want to pull data from DATA02 into REV02 to achieve my goal. SOURCE DATA02- (data SKU Volumes) TARGET: REV02- (data Volume Inputs) I tried using LOOKUP function but somehow unable to use it. What is the right way to map data so that my goal is achieved? Thanks

ankulkarni · ‎07-13-2020

You are right! Thank you so much Einas. It worked

ankulkarni · ‎07-13-2020

Hi Einas, I have not changed the csv format and tried selecting dates instead of period per below. but, getting an error per below

ankulkarni · ‎07-13-2020

Hello Community, I am trying to import SKU.Volumes data into the DATA02 module However, I am facing issues while importing. Below is the step 1 STEP 2 STEP 3 STEP 4 STEP 5 FINAL OUTPUT Can someone please guide me? Thank you in advance

ankulkarni · ‎07-08-2020

level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. Open the REV03 Margin Calculation module. Toggle to blueprint view to enter the following formulas for each line item: Line Item Formula Revenue 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Sales Price * (1 + Sales Price Growth %) Cost of Sales 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %) Sales Price Growth % IF 'SYS00 Time Settings'.Forecast period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Sales Price %) ELSE 0 Cost Price Growth % IF 'SYS00 Time Settings'.Forecast period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Cost Price %) ELSE 0 Current formula:- Revenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price * (1 + Sales Price Growth %) Correct Formula:- Revenue'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Sales Price * (1 + Sales Price Growth %) Current Formula:- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %) Correct Formula:- 'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %)

ankulkarni · ‎07-08-2020

The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation. Kindly help ERROR: The formula for 'REV03 Margin Calculation'.Cost of Sales is invalid ;REV02 Volume Inputs'.Volumes is not a recognized line item or list member line item- Revenue Formula - 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price Line Item- Cost of Sales Formula- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs

About ankulkarni

Re: Removing '0' from 3rd place

Re: Removing '0' from 3rd place

Removing '0' from 3rd place

Anaplan Technical documentation

Re: user access automatic termination

user access automatic termination

Re: LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks

LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks

Re: 2.4.7 Activity: Create Saved Views for UX

2.4.7 Activity: Create Saved Views for UX

Sprint 1 : Import flat list for country

Re: EMP02 Module_ Level 1

EMP02 Module_ Level 1

Re: Correct mapping guide

Level 1 - Expense by Role

Re: L1MB Part 8: Data Import for REV02

Re: Correct mapping guide

Correct mapping guide

Formula error while pulling data from one module t...

Re: DATA02_LEVEL 1 model import issue

Re: DATA02_LEVEL 1 model import issue

DATA02_LEVEL 1 model import issue

level 1 Formula given in the activities is givin...

LEVEL 1 -Part 08 activity- Add Formulas to Line It...

Re: 2.4.7 Activity: Create Saved Views for UX

Re: 2.4.7 Activity: Create Saved Views for UX

Re: 2.4.7 Activity: Create Saved Views for UX

Re: Anaplan Technical documentation

Re: LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks

Re: LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks

Re: 2.4.7 Activity: Create Saved Views for UX

Re: Level 2 Sprint 2 Model Calendar question, data...