Platform

VIGNESH.M · ‎10-09-2019

Hi @elaine.novel , Try this Formula, MID(Concatenated string, FIND("-", Concatenated string) + 1, FIND("-", Concatenated string, FIND("-", Concatenated string) + 1) - FIND("-", Concatenated string) - 1) It is best to divide the formula to small ones and use them. Example: Find out "1st - Place" and "2nd - Place" Regards, Vignesh M

VIGNESH.M · ‎10-02-2019

Hi, Try this Regards, Vignesh M

VIGNESH.M · ‎09-30-2019

Hi, #E2 Employee is a number list, so we can't use the name for mapping. We should use code for the import. Your mappings are right, please download the file again and try to load it. Regards, Vignesh M

VIGNESH.M · ‎09-30-2019

Hi, Yes, we have a unique id for the modules. try this I tried same for the line items, but didn't get the unique ID. Regards, Vignesh M

VIGNESH.M · ‎09-26-2019

Hi Mark, See the screenshot, there is a mismatch in the command. Change the Import to Process. Here is the script I tried, this is working fine for me. @echo off rem This example runs a Process that contains multiple Export actions set AnaplanUser=vignesh.com:password set WorkspaceId="8a81b09b599f39sds159be1157d87218" set ModelId="59362461744sdsd89A33D634942F3E0F" set Operation= -file "Account List.CSV" -put "C:\anaplan-connect\Account List.CSV" -file "Country.CSV" -put "C:\anaplan-connect\Country.CSV" -process "Upload Account" -execute 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 Regards, Vignesh M

VIGNESH.M · ‎09-25-2019

Hi Mark, I can see you have separated Process & Get as separate rows, can you keep those with Set Operation command and try to run the process. Set Operation = -File " " -Put " " -File " " -Put " " -Process " " -execute -get " " ~Vignesh M

VIGNESH.M · ‎09-25-2019

Hi @naveed.bakshi , Can you check the formula scope column in the blueprint view for the line item in target module, Formula scope should be ALL VERSIONS. ~Vignesh M

VIGNESH.M · ‎09-25-2019

Hi @rikdebruyn @jcheng We have created the DATA02 SKU VOLUMES module as part of the LEVEL 1 Certificatication exam, this is one of the question in the level 1 exam. Sorry for the confusion. Thanks @ChrisMullen Regards, Vignesh M

VIGNESH.M · ‎09-23-2019

Hi, If you are using this grid for reporting purpose, then add User Dimension in INPUT MODULE and CALCULATION MODULE. Adding a user dimension will allow each end-user to select the list they want and can see the result based on their selection. You only have 3 dimensions in Calculation Module, it won't take much size. It's better to create a module with these 3 dimensions and remove the input module. Thanks, Vignesh M

VIGNESH.M · ‎09-22-2019

Hi, The Actual and Forecast numbers are getting summed and loaded into your target module. To only take forecast numbers, Option 1: Direct Formula Use the formula to pull the data, Use SELECT Function =SOURCE MODULE.VALUE[SELECT: VERSIONS.FORECAST] Option 2: Import Step 1: Create a line item in your target module called Staging and use formula to pull data from the source module, =SOURCE MODULE.VALUE[SELECT: VERSIONS.FORECAST] Step 2: Import Value from Staging to Target Line Item. Regards, Vignesh M

VIGNESH.M · ‎09-16-2019

Use Dynamic Cell Access to control write access on time period. Give only write access to APR month and use ask each time import option.

VIGNESH.M · ‎09-16-2019

Hi, You can use "ASK EACH TIME IMPORT IS RUN" option. This will reduce the number of actions needed. Regards, Vignesh M

VIGNESH.M · ‎09-15-2019

Hi, Try this, Step 1: Create a line item(Previous Year) in the Target Module and format it as Time Period.Month Format and Use the below formula Step 2: Write the logic to pull data from Source to Target Mod, use the formula highlighted below Note: Keep the previous year line item in a separate system mod. Regards, Vignesh M

VIGNESH.M · ‎09-12-2019

HI @ChrisMullen , Yes, Now I can see the text at the bottom. Thanks.

VIGNESH.M · ‎09-12-2019

Hi Fredrick, If you want to apply this rule only for the set of data, then apply the rank only to the transaction which meets the criteria. In my below example, I want to only apply the rule to UID- #5 data sets, so created flag line item and right a logic to flag only the records which you want and include that flag condition with Rank. Correct me if I understood differently the requirement. Regards, Vignesh M

VIGNESH.M · ‎09-12-2019

Hi Fredrick, Try this solution, but you need to create 1 list and 2 modules. Step 1: Create a Rank List as shown below Step 2: Create 3 New line item(Next Item, Rank List & Next Rank List) and format the line item as shown below Step 3: Create a module as Rank Mapping 1 and Add line item as Rank Applies To: #Transaction List and Rank List Format: #Transaction List : Summary: FIRST NON BLANK Use the below formula Step 4: Create a module as Rank Mapping 2 and Add line item as Rank Applies To: Rank List Format: #Transaction List : Summary: NONE Use the below formula Step 5: Write the formulas now and check the result. If you find any other alternate solution please pass it here. Regards, Vignesh M

VIGNESH.M · ‎09-11-2019

As Fredrick mentioned, am also facing the same situation. I have watched the video, but still the progress bar is in RED color. Also uploaded my model history, but did not get any confirmation that level 2 is completed. Thanks, Vignesh M

VIGNESH.M · ‎09-11-2019

Hi, You scripts look fine, there is no issue. The error you are getting is "Upload file no longer available". To fix this, load the file into the import data source and set the Default file option to ADMIN only so that the file will be available always in Anaplan. NOTE: The file name should be the same as the file name present in Anaplan, rename the file accordingly.(Ex: Distribution+Center+Capacity) After you done this part, run or edit the action and validate whether you are able to see the file now. you are getting this error because while creating this action the default file format was set to "Private", the private file will be available only for next 48 hrs. Regards, Vignesh M

VIGNESH.M · ‎09-10-2019

Hi, It appears to be a bug. Please go through the attached link, we have discussed the same topic in this post. https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Formulas-Not-Adhering-to-Subset-Formatting/m-p/50781#M7475 Try this workaround solution, 1. If you have code in your Country List FINDITEM('Country Subset' , CODE('1')) 2. If you don't have code in your Country List FINDITEM('Country Subset' , NAME('1')) Regards, Vignesh M

VIGNESH.M · ‎09-10-2019

Hi, Check the details of the import, you will get the exact reason behind the error. Might be Column is not mapped correctly or Item in one of the list is not populated yet. ~Vignesh M

VIGNESH.M · ‎09-10-2019

Hi, You are right, if we want to see SKU level data then we need SKU list as page selector. I think DEM03 will also get update based on the selection we made in DEM01 module. DEM01 as product family dimension, so if we select any product family on 1st grid, 2nd grid will show that product family data. Instead of creating a module with product family(L1) dimensions, we are using the existing module which contains the same data at a higher level, just an assumption. We cannot hide the lower levels(L2 & L3) from the grid, then synchronization will not work. Regards, Vignesh M

VIGNESH.M · ‎09-08-2019

Hi @SwagatZS , Yes, ALM sync will work in this case as well. You are just changing the location of the model, the model still contains the same structure as PROD model, so it will work. I am curious to know, how you are going to copy the model from one customer to another customer workspace, we can copy the model from one workspace to another workspace within a customer, but between 2 customers how? Thanks, Vignesh M

VIGNESH.M · ‎09-08-2019

Hi John, #E2 Employee list is a number list, We should not map a column from the source data to act as the name and unique identifier should be the CODE. Check this link for more information, https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Lists_and_Roll-ups/Numbered_Lists/Working_with_Numbered_Lists.html?_ga=2.102153161.93144093.1567878147-1190542673.1559538714#Import%20-%20Code Regards, Vignesh M

VIGNESH.M · ‎09-08-2019

Hi Mark, Try this, Create another line item to exclude NAN as shown below and use Final Rank to calculate the MAX Check this link for more ideas, it has a similar question. https://community.anaplan.com/t5/Anaplan-Platform-Discussions/NaN-formula/m-p/42400#M4539 Regards, Vignesh M

VIGNESH.M · ‎09-07-2019

Hi, Yes, ALM sync will work in your case. You are moving Dev model from Workspace Dev to Workspace Prod, So there won't be any issue in ALM sync. Regards, Vignesh M

VIGNESH.M · ‎09-05-2019

Hi Fredrick, I think action 1.3/1.4 is same as T1.3/T1.4, we need to include these actions in the process "T1 Build Product Hierarchies". Regards, Vignesh M

VIGNESH.M · ‎09-04-2019

Hi @Takamasa , Year should be formatted like 2018,2017.. So concatenate 20 with Year. Regards, Vignesh M

VIGNESH.M · ‎09-03-2019

Both the Column Header and Fixed-line item does the same job, we use these options based on the target count in import. if we have only 1 target, then we can use the fixed-line item or Column header option. If it's more than 1 target, we have to use the column header. ~Vignesh M

VIGNESH.M · ‎09-03-2019

Hi, Don't change your line item format to text in module. After you made format change in excel, have you tried to import? Line item keep it as Date format. Are you still getting error? Regards, Vignesh M

VIGNESH.M · ‎09-03-2019

Hi, Can you format your Date column in excel as shown below and try the import. Regards, Vignesh M

Platform

Academy

Master Anaplanner

Programs

About VIGNESH.M