About jonathanpascual

Hello,    I hope you are all doing well.   I need some help on my calculation.    Issue is, I need my ending balance of the prior period to be the beginning balance of the current period.  The thing is, these movements (beginning +/- movements = ending balance) are all members of the same list.  It just does not come forward.    The formula goes like this:   IF ITEM(PPE Cost Movements) = PPE Cost Movements.Beginning Balance THEN PREVIOUS(Line Item in Issue[SELECT: PPE Cost Movements.Ending Balance]) ELSE 0   It should take the 284M as the beginning for Jan 20 and not the loaded 295M anymore.   Thank you,   Jonathan   ... View more

Hello,    I hope you're all doing well.   I have this problem that's preventing me from proceeding on to the next steps.    I'm trying to rank the basic salary from lowest to highest, by position.  As we all know, even if employees have the same position, there are instances that they don't have the same salary. The idea is, I need to get the lowest salary per position.  The issue I'm encountering is that, if I do a rank formula, it does return the correct order when there are more than 1 employees.  But if the position is assigned to only 1 employee, meaning only 1 employee has that position, it always returns 2. I need the value to be 1 since that will be my basis of getting the salary amount: IF Rank = 1 THEN Basic Salary ELSE 0.    Thank you for all the inputs you may share.   Regards,   Jonathan ... View more

Hello,   Many of you have probably finished the Level 3 Model Building Certification.  As I start Level 3, Sprint 2, I got confused with the below instruction: My questions/clarifications:   1. In Sprint 1, the Level 3 Model is connecting with the Data Hub, and there was an option to download a New Data Hub or Use the Data Hub in Level 2 Model Building. I used the Data Hub in my Level 2 Model Building. There is no Territory List in Level 2 Data Hub. Where can I import the data? Do I have to create a new list for Territories in the Level 2 Data Hub? See screenshot below: 2. Do I really have to do it in the Level 2 Data Hub? It seems that it's already in the Level 3 Model itself, both in List and Sys module:       Thanks so much!   Jonathan ... View more

Hello,    I am having this difficulty since last night, I can't figure out how to address this issue.  If anyone has encountered this issue before, what did you do to solve this?    Situation:   1. I have created saved views inside the same module. I'm using saved views to import to the very same module.  2. The module has a custom version such as Budget Year and Forecast Year... and cuts such as Current cut and Previous Cut 3. The use of the saved views is to import the same information from Budget Year to Forecast Year , or from Current Cut to Previous Cut, into the same module 4. I have a specific line item in the module that I can't seem to import. It's the "Equipment Category" line item. It has a list Format and is a subset of another list, and it's a numbered List.  5. Issue is, when I try to import the populated Equipment Category, an error would occur: "Item not located in ss: MEQ Capex Element Leasing list: Air Compressor" --- but I know for sure that it's listed there.    Screenshots attached.    I'm trying to import the Equipment Category from Current Cut to Previous Cut for the same Budget Year:   In my mapping, I use connect to Anaplan model > Saved View and select that saved view I created. I'm only changing the custom version in the mapping because I want the information in the Current Cut to be imported to the Previous Cut:    The line items are mapped correctly as well: But when the import is ran, I'm getting the below error. Notice that it has 2 errors in it, and it looks like it does refer to the 2 populated equipment categories for "Air Compressor" above:    Here's the subset and Air Compressor is really in it, what am I doing wrong? 😞                 ... View more

Hello,   I'm getting an error when changing a line item's summary  from "Sum to Formula: Time, Sum":   "Invalid combination for line item 'Sales' of summary method 'Formula' with formula using LOOKUP and/or SUM (or other summary function)"   The formula of the line item does indeed have a Sum function, and I'm getting it from another module which has a "Formula: Time, Sum" summary. I would like to be able to get the same amount as that module summed by industry for example:    SourceModule.Sales[SUM: Industry]    But because they have the different summary, I'm not able to get the same results.    Thanks in advance for any input you can give.   Thanks,   Jonathan         ... View more

Hello,   Good day!   I hope every one is having a nice day.    I would like to ask for any information that may help in troubleshooting this issue.   I have a line item in a module called, "Credit Account". I have it in formula which basically says: If the Company is 'A' then use account number '12345', ELSE, use '67890'.  This is working fine, and the accounts are populated in the line item BUT only on the lower levels of the company hierarchy. If I go to the Topmost Level/ the Conso Level, it is not showing up -- it's just blank. The information must show up at the top level as per the requirement -- an output to a csv/excel.    What am I missing?    Thanks so much!   Jonathan ... View more

Hello,   I hope you're all doing fine.    I would like to seek help on  this issue that I'm currently having a challenging time accomplishing.    I am using Anaplan Connect basic Import authentication.  I am successful  running the script when only one file is in the script.  If I tried to include two files in the script, it is not recognizing the other one.  It is possible that I'm going to use the script and there will be a lot of files to be imported come production.  Is it possible? Please help.   Below is the script that I'm using with basic authentication, this is working fine.  But how can I include additional file in the script?   @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html set AnaplanUser="myusername:mypassword" set WorkspaceId="myworspaceid" set ModelId="mymodelid" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set FileName="file1.csv" set FilePath="C:\Users\myprofile\desktop\file1.csv" set ImportName="Import File 1" set DumpName="C:\Users\myprofile\Desktop\ANAPLAN CONNECT\Anaplan Connect Import" set Chunksize=1 set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import %ImportName% -execute -output %DumpName% rem * End of settings - Do not edit below this line * setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat %Credentials% %Operation% @echo %Command% cmd /c %Command% pause   ========================================================== I tried the below script in attempt to include another file in the import but it only processed the file2:   @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html set AnaplanUser="myusername:mypassword" set WorkspaceId="myworkspaceid" set ModelId="mymodelid" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set FileName="file1.csv" set FilePath="C:\Users\myprofile\desktop\file1.csv" set ImportName="Import file1" set FileName="file2.csv" set FilePath="C:\Users\myprofile\Desktop\file2.csv" set ImportName="Import File 2" set DumpName="C:\Users\jspas\Desktop\ANAPLAN CONNECT\Anaplan Connect Import" set Chunksize=1 set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import %ImportName% -execute -output %DumpName% rem * End of settings - Do not edit below this line * setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat %Credentials% %Operation% @echo %Command% cmd /c %Command% pause     Thanks a lot in advance... ... View more