About jonathanpascual

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

Hello,    I would like to ask and gather some feedback on the situation I am having regarding the above subject line.    I find it strange that a module which has a line item that does not need a time dimension (it's set to Not Applicable) shows the information and the other module does not.    For example, in module A, I have a line item "CS1", it is a text, and therefore does not need time dimension so I set it to Not Applicable, it is showing the "CS1" on each row, this is fine. However, I also have a module B, which has the same setup as a line item, I also set it as Not Applicable for the Time, but it's NOT showing the information.    This is affecting model optimization since Time Dimension when used increases the size of the module. In addition, it's affecting the list being generated because I'm using the said line items as well as part of unique identifiers in the schedule I'm generating text files for. A lot of times, I'm getting the error, "A same key has already been added" - it's because the line item in issue does not show the information in the module which causes the information to be not unique.    For illustration:   This is the module that shows the information even if the line items are set to Not Applicable for the Time:     Here's how it looks in the grid view, it has the information for the said line items:     And this is the module where the line items using the same setup as the above Time Scale, they do not show in the grid view:      Any ideas?    Thanks a lot.   Jonathan   ... View more

Hello,    I would like to seek some feedback on this issue that I'm having with Anaplan Connect 1.4.3 Export Process.  My hunch is that, maybe it's related to Java -- I have this Java version on my Control Panel:         =============================================== Currently, I have the below basic export script:   @echo off set AnaplanUser='username:password' set WorkspaceId='my workspace ID' set ModelID='my model ID' set Operation=-service 'https://api.anaplan.com' -auth 'https://auth.anaplan.com' -export 'ACHFM001' -execute -get 'C:\Users\jspas\Desktop\ANAPLAN CONNECT\anaplan-connect' 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% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd/c %Command% pause ===============================================   I am getting this error when I run the script:   '-execute' is not recognized as an internal or external command, operable program or batch file. '-workspace' is not recognized as an internal or external command, operable program or batch file. .\AnaplanClient.bat -user 'my username:password' Absolute path to JAVA 8 or Java 11 or OpenJDK8 executable not provided. Will attempt to figure out path from JAVA_HOME or Windows registry... JAVA_HOME is not defined, will attempt to fetch value from registry... Checking Windows Registry for Java Version... Checking Windows Registry for JAVA_HOME... JAVA_HOME is C:\Program Files\Java\jre1.8.0_241 Found Java executable from JAVA_HOME "", at C:\Program Files\Java\jre1.8.0_241\bin\java.exe... Current Java version = 1.8 Current Java version is valid for Anaplan Connect. Running Anaplan Connect... Using Class-Path: C:\Users\jspas\Desktop\ANAPLAN CONNECT\anaplan-connect\anaplan-connect-1.4.3-jar-with-dependencies.jar 2020-01-30 15:43:12 ERROR 3864 |-- Options are: General: -------- (-h|-help): display this help (-version): display version information (-d|-debug): Show more detailed output (-q|-quiet): Show less detailed output Connection: ----------- (-s|-service) <service URI>: API service endpoint (defaults to https://api.anaplan.com/) (-u|-user) <username>[:<password>]: Anaplan user name + (optional) password (-auth|-authServiceUrl) <Auth Service URL>: Anaplan SSO server.(-c|-certificate) <CA certificate filepath>: Path to user certificate used for authentication (an alternative to using a key store) (-pkey|-privatekey) <privatekey path>:<passphrase>: Path to user privatekey used for authentication (an alternative to using a key store) + passphrase (-k|-keystore) <keystore path>: Path to local key store containing user certificate(s) for authentication (-kp|-keystorepass) <keystore password>: Password for the key store (if not provided, password is read from obfuscated file 'C:\Users\jspas\Desktop\ANAPLAN CONNECT\anaplan-connect\.anaplan\api-client\keystore-access.txt', or prompted for) (-ka|-keystorealias) <keystore alias>: Alias of the public certificate in the specified key store (-v|-via) <proxy URI>: use specified proxy (-vu|-viauser) [<domain>[\<workstation>]\]<username>[:<password>]: use proxy credentials (-mrc|-maxretrycount): Max retry count for API calls (-rt|-retrytimeout): Retry timeout for Http client calls (-ct|-httptimeout): Http client connection timeout Workspace Contents: ------------------- (-w|-workspace) (<id>|<name>): select a workspace by id/name (-m|-model) (<id>|<name>): select a model by id/name (-F|-files): list available server files in selected model (-f|-file) (<id>|<name>): select a server file by id/name (-ch|-chunksize): upload chunk-size number, defaults to 1048576. Data Transfer: -------------- (-g|-get) <local path>: Download specified server file to local file -gets Write specified server file to standard output -getc Write tab-separated server file to standard output (-p|-put) <local path>: Upload to specified server file from local file -puts Upload to specified server file from standard input -putc Upload to specified server file from tab-separated standard input Server Actions: --------------- (-I|-imports): list available imports in selected model (-i|-import) (<id>|<name>): select an import by id/name (-E|-exports): list available exports in selected model (-e|-export) (<id>|<name>): select an export by id/name (-A|-actions): list available actions in selected model (-a|-action) (<id>|<name>): select an action by id/name (-P|-processes): list available processes in selected model (-pr|-process) <id/name>: select a process by id/name (-xl|-locale) <locale> Specify locale (eg en_US) to perform server opertion (-xc|-connectorproperty) [(<source>|<type>)/]property:(value|?): specify import data source connection property (-xm|-mappingproperty) [(<import id>|<import name>)/]dimension:(value|?): specify prompt-at-runtime import mapping value(-x|-execute): Run the selected import/export/action/process Action Information: ------------------- (-o|-output) <local path>: Retrieve dump file(s) for completed import/process -emd: Describe layout of an export (metadata) JDBC: ----- -loadclass <class name>: Load a Java class -jdbcproperties: Path to JDBC properties file. Press any key to continue . . . ===============================================   Thanks a lot! 🙂     ... View more