Platform

VIGNESH.M

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

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

VIGNESH.M

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

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

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

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

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

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

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

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

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

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

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

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

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

VIGNESH.M

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

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

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

VIGNESH.M

Hi @Takamasa , Try Custom pattern as shown below, Regards, Vignesh M

VIGNESH.M

Hi callum, Sorry, I misunderstood the question. Yes , Am also getting it as Number instead General. Please raise a ticket to Anaplan support, they will help you with more detail. ~Vignesh M

VIGNESH.M

Hi @CallumW I am using excel add-in 3.2 versions, recently downloaded. If I understood your question correctly, you are telling that you are getting Number instead of Boolean value. I tried your scenario, I am getting boolean value correctly. Not sure where is the issue, please try uninstall and install it back. Regards, Vignesh M

VIGNESH.M

@harsangeet , Your excel contains YYYYMM time format, you can use periods options to map the time. Use it either Y-M option or YYYYMM. Regards, Vignesh M

VIGNESH.M

HI, Choose Fixed line item option from the dropdown, then go to the Line item tab and select volume line item. ~Vignesh M

VIGNESH.M

Hi Your data should be consistent(Y-M-D OR D-M-Y). if your data contains both, then you ill get an error. ~Vignesh M

VIGNESH.M

Hi, Use the option given in Date Line Item If the format is not available use custom format, in your case use the highlighted pattern below which matches with your excel date format. Regards, Vignesh M

VIGNESH.M

@barryallen1337 , Try this to get almost perfect size calculation for each module. Module 1 has cell count of 90M and boolean format, the Actual size is 0.83 GB, as per yours 3.7 GB Module 2 has cell count of 90M and Number format, the Actual size is 6.6 GB, as per yours 3.7 GB Information provided above by David is the best way to calculate the accurate size. Regards, Vignesh M

VIGNESH.M

Hi, Gm as % of Revenue is a part of line item subset here and Line item Actuals is number format, not percentage format. So we will get only the number formatted output. Try this, 1. You can change the list(Revenue, Gm as % of Revenue &...) as line items and line items as List(Actuals, PY &..) and use the lookup to get data from source module instead of using select. or 2. Create % conversion module and include with formula as shown below. But getting % option is not available in your case. Regards, Vignesh M

VIGNESH.M

Hi, We can only change the data in Anaplan using Excel Add in. To answer your question, NO it is not possible to add new list items to dimension using Excel Addi n. Regards, Vignesh M

VIGNESH.M

Hi, You need uniques key to import data, so create unique key combining Project & Employee info and load this into Code in the list. 1. You can create code while loading these Lists into Anaplan from Excel, create a unique key column and load it, or 2. In Anaplan, create a module and Combine Product & Employee information and load this into Employee Code via action. After code is generated, use that in your import file for mapping and load into Anaplan, Regards, Vignesh M

VIGNESH.M

Hi, You can achieve this using "Numbered List". Please go through this link https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Lists_and_Roll-ups/Numbered_Lists/Numbered_Lists.html?_ga=2.28539576.505145796.1566702539-1190542673.1559538714 ~Vignesh M

Platform

Academy

Master Anaplanner

Programs

About VIGNESH.M