About PavanKumar

PavanKumar · ‎01-30-2020

Hi @elaine.novel Try the following: 1) In a system module with no dimensions create a lineitem ‘Select Month’ and format that as time period month and publish it to DB for selection 2) In a time filter module create a Boolean lineitem for filter. Formula should be : ITEM(Time) = select month OR ITEM(Time) = PERIOD(ADDMONTHS(START(select month), -12)) By doing this, If Jan 20 is selected in the (1) above Jan 20 and Jan 19 will get checked. 3) In the DB use step (2) as a filter. Which will filter for Jan 20 and Jan 19 only. Regards, Pavan

PavanKumar · ‎01-30-2020

Hi Madhu, Only way you can achieve this without Time dimension is using 'Lookup'. In the list, used as dimension in the module you are referring, create a property formatted as the same list and create a manual mapping. E.g: List Members Lookup Property A B A C B D C Formula for your second line now will be 'Line 1[Lookup: Lookup Property] Your next question should be, can't we automate this using a formula? Answer is no. Manual mapping and using lookup is the workaround. Let me know, if i misunderstood your question. Regards, Pavan

PavanKumar · ‎07-31-2019

Hi @Ravil There's no straightforward formulation to solve linear regression, whereas there's a functionality for linear programming. Check this https://help.anaplan.com/anapedia/Content/Modeling/Optimizer/anaplan-optimizer.htm for better understanding of the same. Hope this helps. Regards, Pavan

PavanKumar · ‎07-23-2019

@Tsuyoshi_Inoue1 Sometimes it happens with the ALM. I would recommend delete the filter and add it back again in development model and sync the models creating a new revision tag. Regards, Pavan

PavanKumar · ‎07-22-2019

Hi @iosman123 I noticed that you have posted the same query earlier. I presume solutions presented in earlier post didn't work for you. If you post new reply on the earlier post, it will float to the top of forums again. Please don't create multiple posts on same query, which might confuse the learners who may have same question. Regards, Pavan

PavanKumar · ‎07-19-2019

@GaryPage You can use the native 'brought-forward' functionality of Anaplan with 'PREVIOUS' formula. Checking the 'brought-forward' Boolean in blueprint view, will activate the functionality and a new time period will get auto-added which holds your opening balance. In the screenshot attached, 'Dec 17' will auto- create when you check 'brought-forward' in blueprint. However, your actual time starts from 'Jan 18'. @DavidSmith This will minimise your workaround effort 😉 Regards, Pavan

PavanKumar · ‎07-19-2019

Hi @kdoan After the recent infrastructure updates in Anaplan, i had observed similar kind of problems in existing dashboards in few models. Just re-create the dashboard by publishing the module again in new DB. It should work fine. Regards, Pavan

PavanKumar · ‎07-16-2019

Hi Amanda, I haven’t faced this kind of situation, but if ever it needs to be build in Anaplan, you can consider the following. If I understood your requirement right, Sales title 1 is mapped to Territory A Sales title 2 is mapped to Territory B Now, sales title 1 and 2 needs to be consolidated, though they are mapped to two different territories. And quota should be same as it was calculated based on their territory. If this is the case: Create a separate list which holds all the consolidated plans. Call it ‘List A’ Have the mapping of list A in ‘Sales title’ list. Ex: In Sales title list map sales title 3 to title 1 & 2. Sum your quota values by the property created in step 2. Hope this helps. Regards, Pavan

PavanKumar · ‎12-19-2018

Hi Mohammad Husain, You are trying to build a very unique thing, very nice. Unfortunately, this cannot be done, for the reasons listed below: 1) A dashboard will not have "Read-Write-None" access directly but modules, lists and actions used in that particular dashboard will have "Read-Write-None". Further, you can control whether a particular role can see the dashboard or not through contents panel. 2) There are two ways by which you can pull data into the module which you created: a) Through formula : Not possible as Anaplan will not take actions in the formula. b) Through an import process : No option to import from actions to a module/list. But as a workaround solution, you can update the module which you are creating manually. So that, an admin will have to update this whenever he provides an access to new user. Hope this helps. Regards, Pavan Kumar

PavanKumar · ‎10-09-2018

Hi, Create a module in hub model to capture all the details of the list. Then, import from that module of hub model to your list in target model. Hope this helps! Regards, Pavan

PavanKumar · ‎10-09-2018

Hi, This could be because of name exceeding 60 character limit. Workaround : Use numbered list, but ensure code does not exceed 60 characters. Regards, Pavan

PavanKumar · ‎10-04-2018

Cheers

PavanKumar · ‎10-04-2018

If the dimension is "Account Hierarchy" and the lineitem format is "Account Hierarchy Deleveled", then the formula "FINDITEM(Account Hierarchy Deleveled, NAME(ITEM(Account Hierarchy)))" should work fine. Regards, Pavan

PavanKumar · ‎10-04-2018

Okay. If tht's the case, can you try the script in following manner: @echo on :: This script looks up the current date, writes it to a csv file, and sends it to Anaplan :: Here we set the file path of the csv file we will be writing the current date too set FileName="E:\anaplan-connect\CurrentDate.csv" :: rem This is a simple for loop that parses the date /t function FOR /f "tokens=1-4 delims=/ " %%a in ('date /t') do (set mm=%%a& set dd=%%b& set yyyy=% %c& (if "%%a:~0,1" gtr "9" set mm=%%b& set dd=%%c& set yyyy=%%d)) echo Todays date in Windows format is: %date% set mydate=%yyyy%-%mm%-%dd% echo 'Current Date': %mydate% rem The following is not needed unless you have specific requirements to strip characters, etc :: rem Remove leading Zeros from Day :: set d=%dd% :: set /a d=100%d% %% 100 :: rem Remove leading Zeros from Month :: set m=%mm% :: set /a m=100%m% %% 100 :: set snapshot=%d%-%m%-%yyyy% set snapshot=%mydate% echo 'Latest Snapshot': %snapshot% @echo "Current Date","Latest Snapshot"> %FileName% @echo "%mydate%","%snapshot%">> %FileName% rem ************************************************************** rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc set certificate="E:\anaplan-connect\certificate-304882231934460512329172813723037634997.cer" set WorkspaceId="workspace id" set ModelId="model id" set Operation= -file "CurrentDate.csv" -put %FileName% -import "Import todays date" -execute rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %certificate% == "" set Credentials=-certificate %certificate% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command% Regards, Pavan

PavanKumar · ‎10-04-2018

Hi, Change the lineitem format to "Account Hierarchy Deleveled". It will work as expected. Hope this helps Regards, Pavan

PavanKumar · ‎10-04-2018

Oh. To your previous script, just replace the follwing line if not %certificate% == "" set Credentials=-certificate %certificate% and try. Regards, Pavan

PavanKumar · ‎10-04-2018

Hi Elisa, Towards the end of the batch script, replace the following: if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% With this; if not %certificate% == "" set Credentials=-certificate %certificate% It should work fine. If required refer the attached script. @echo off rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc set certificate="C:\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\certificate-262107658004671057091197622572827278496.cer" set WorkspaceId="workspace id" set ModelId="model id" set Operation= -export "Avg Calculations - Total.csv" -execute rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %certificate% == "" set Credentials=-certificate %certificate% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command% pause Hope this helps. Regards, Pavan

PavanKumar · ‎10-04-2018

Hi, If there is significant changes between current tag and previous sync, and if we do not create a tag for very long, there is a very good chance that sync will fail. That is why, it is suggested to sync the models after every change to the model. Regards, Pavan

PavanKumar · ‎10-03-2018

Sheetal, 1) They are manulally mapped 2) While writing a formula, we should divide "No of days" by 7 for the value we are taking. (Its again like, giving weights) Regards, Pavan

PavanKumar · ‎10-03-2018

* Instead of using weighting(as explained by Peter), i have directly used no of days in a week. You can see 5 days of week 4 falls in Jan 18 and other 2 days falls in Feb 18. Pavan

PavanKumar · ‎10-03-2018

Hi Sheetal, Please check the following screenshot: Note : Refer SA model Let me know, if this helps or not Regards, Pavan

PavanKumar · ‎10-03-2018

Yes. You are right Harish. Regards, Pavan

PavanKumar · ‎10-03-2018

Hi, Got it. Both lines are refering to each other. This cannot happen. Please check with the business to take clarity on the requirement. Regards, Pavan

PavanKumar · ‎10-01-2018

Hi, Okay, got it. Then, how is the values calculated in Yield (Column E)? Pavan

PavanKumar · ‎09-28-2018

Hi, In summary of your issue, formula for first line is the previous value of 2nd line. And, formula for 2nd line = Line 1 * factor 'x'. Clearcut circular refernce issue. Prima facie, looks like there is something wrong with the logic, you are trying to build. Please check once. Regards, Pavan

PavanKumar · ‎08-23-2018

Hi, I coud not understand the exact use case. But from what i understood, you are trying to sort some records based on 2 different lieitems and anaplan will take sort based on only 1 lineitem. If that's the case, yes the base for sorting can come from only 1 lineitem. Only way out could be, try bringing the values in those 2 different lineitems into a single lineitem which will be the 3rd lineitem to be created (If possible) and use that for sorting. Sorry, if i have misunderstood. Regards, Pavan

PavanKumar · ‎08-23-2018

Hi, I guess you can use the users dimension to the list which is used. Regards, Pavan

PavanKumar · ‎08-23-2018

Emmanuelle, For Lineitem 2: Set the summary as "Max" in blueprint view For Lineitem 3: Formula = Lineitem 2 [Lookup: Parent ] For Lineitem 4: Formula = ROUND(Lineitem 3 / Two) Lineitem 4 will give us the median Rank. Then, wages corresponding to Line 4 will be our median wage. Hope this helps. Regards, Pavan

PavanKumar · ‎08-21-2018

Hi Peter, I agree with the concern you are facing and it feels annoying. But, when we create a parent list for the 'create action' to work. The parent list created can be deleted, once you create the action and publish it to dashboard.

PavanKumar · ‎08-21-2018

Hi, It can be acheived using RANK & MAX formulae. 1) Using RANK, give the rankings to your wages lineitem. 2) Select MAX rank from the previous line 3) Then max value calculated in previous line divide by "2" (Use ROUND function, if value is odd) 4) In line 3, you get MEDIAN RANK. Wages corresponding to your median rank, is your median wage. Hope it helps Regards, Pavan