About PavanKumar

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 ... View more

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  ... View more

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        ... View more

@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   ... View more

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   ... View more

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 ... View more

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 ... View more

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  ... View more

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 ... View more

Cheers ... View more

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 ... View more

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 ... View more

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

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

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 ... View more

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  ... View more

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  ... View more

* 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 ... View more

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

Yes. You are right Harish. Regards, Pavan ... View more

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  ... View more

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

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      ... View more

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 ... View more

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

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      ... View more