About VIGNESH.M

VIGNESH.M

Hi Sravan, You need to create a system module to identify the year of the weeks and then use the lookup to bring the yearly data to weekly. It's not an import, you need to pull the numb er through the formula. Regards, Vignesh M

VIGNESH.M

Hi @LipChean_Soh @ArunManickam , I totally agree with you, we should not do the hardcoding like this and instead use the system module as mentioned in Planula for the best practices. Thanks, Vignesh M

VIGNESH.M

Hi Ricardo, Formula Correction, try this IF ITEM(' Volumes ')= Volumes.Retails THEN X ELSE Y ~Vignesh M

VIGNESH.M

Hi, I think it's not because of Anaplan. Try this, #1. Delete the file source in Import data source #2. Create a new one.CSV file and load it. Regards, Vignesh M

VIGNESH.M

Hi, There are no limitations, we can add N number at a time. ~Vignesh M

VIGNESH.M · ‎12-18-2019

Hi Prabhu, Use the "Previous" function to get this, see the screenshot below. Regards, Vignesh M

VIGNESH.M · ‎12-15-2019

Hi, We should not map List item Name to number list, Numbers list name will come from Display name properties. #1. Remove the Employee Name mapping from column 1(#E2 Employees) #2. Remove the formula in Display Name Properties and map Employee name to Display name. ~Vignesh M

VIGNESH.M · ‎12-11-2019

Hi Prabhu, I tried your scenario, it's working fine. Please see the screenshot. I didn't mark any version as current. Regards, Vignesh M

VIGNESH.M · ‎12-11-2019

Thank you for being such a wonderful teacher @DavidSmith, We all gonna miss you in the forum. Thanks, Vignesh M

VIGNESH.M · ‎12-11-2019

Hi @karank , Step 1: Create another Read line item with subset in applies to in the 1st module Step 2: Use this new line item in your 3rd module to control the access. The module dimension and DCA Read access dimensions should be same. Regards, Vignesh M

VIGNESH.M · ‎12-04-2019

Hi Usha, You don't need the FIRST OCCURENCE to applies kavin's solution. when we load data into the text format line item, the system will take the first unique record only and ignore the duplicate records., So You don't need the FIRST OCCURENCE. To implement my solution, Yes, you need staging modules. Let say you have 3 data loading modules, then you need 3 staging modules. Regards, Vignesh M

VIGNESH.M · ‎12-03-2019

Hi Usha, Try this, Load the file into the one Staging module and use first occurrence to find the first valid record and load it from the saved view to the target module. Regards, Vignesh M

VIGNESH.M · ‎12-03-2019

Hi, Try this, We have the option to cumulate the value based on the list. Formula = CUMULATE(VALUE, FALSE, 'Country') Check this link, https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CUMULATE.html

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