About VIGNESH.M

VIGNESH.M · ‎02-03-2021

Hi All, I am seeing this error for a long time, so I thought of sharing this here, there might be a solution which I don't know. if there is a solution pls share it. Let's assume I have an import template as follow Column 1 - Display Name of the List Items Column 2 - Unique Code Column 3 to end - TIME(JAN 21, FEB 21,...) Since my module using a numbered list dimension, I have to map the unique code for the import. So I map Column 2 to the module dimension, Column headers to the Time dimension. After running the import, we always get the following error "Expected month name or number in date/period". the reason is that the system thinks my column 1 also time formatted. By just having only code detail in my import file, we can avoid this error, but I need both code and name in my template. By giving the Column header starting column detail as optional, I believe we can avoid this error. Assume if we can say the column header starting column is column 3 in this example. As a Anaplanner, I know this error won't cause any issue but not many end users know this and feel that something is not right with the import. Regards, Vignesh M

VIGNESH.M · ‎02-03-2021

Hi Johan, You have to Rank the Salary by the department(L1) to start over the ranking for each department. In the system module, first find the L1 of each employee and use it for ranking. The formula will look like this, RANK(Salary, DESCENDING, SEQUENTIAL, TRUE, L1) Check the Rank function in Anapedia for more detail. https://help.anaplan.com/en/4f94f2e7-e7d9-4bae-ba6f-2b872e8d9189-RANK Regards Vignesh M

VIGNESH.M · ‎10-14-2020

Hi, if both the lists are identical then try this, NAME(ITEM('ENTITY LIST1')) = NAME(ITEM('ENTITY LIST 2')) ~VM

VIGNESH.M · ‎10-14-2020

Yes @Misbah, SUM on Pursuits is not required, as it will auto aggregate at Parent(Pursuit) dimension. Pursuit Team Split.Amount[SUM: Pursuit Team Split.Split]

VIGNESH.M · ‎10-14-2020

Hi @michael.chefer , You are trying to bring data from the child(Pursuit) to the parent( Team Members) list, but you want to aggregate based on Rank. To make it simple, I suggest you create a list called Split(Split 1,2&3) and create a line item(Split) in the Pursuit Team Split module and map items based on the rank line item. For Rank 1 -> Split 1, 2- -> Split 2...so on. you can create this mapping by a formula. Your Target module should have (Pursuit, Split) dimension and line item called Amount. Now you just have to aggregate the Split amount by Split and Pursuit dimension. Amount = 'Pursuit Team Split'.Split Amount[SUM:Pursuit Team Split.Split, SUM: Pursuit Team Split.Pursuit] Regards, VM

VIGNESH.M · ‎09-11-2020

Thanks @MagaliP, I have raised a ticket with Anaplan support.

VIGNESH.M · ‎09-11-2020

Hello All, Our users are having SSO access to Anaplan, but we are getting a non-sso login page while log-in into the Excel-add-in. We already tried to uninstall/install the package a few times and we follow the same installation procedure for all the users. Only 3 users are facing this problem and they were able to log in using SSO till last week. Any suggestion what could be the reason for this? Thanks in advance for your help. Regards, Vignesh M

VIGNESH.M · ‎08-04-2020

Hi, Could you share some screenshots to get an idea? ~VM

VIGNESH.M · ‎08-04-2020

Hi @LVermunt , Try this, 1. In the Blueprint view, find the Users List column and change it to the Show All Users: Off 2. Bring User Dimension to the rows and keep line items in the columns and save it as a saved view. Is your employee list is a Numbed List? If YES, Map Parent to Parent, Employee Code to Code and run the import If Not, Map Parent to Parent, Employee Code to Name, Employee Code to Code, and run the import. ~VM

VIGNESH.M · ‎08-04-2020

Hi, Can you share screenshots of your Target list grid view, source module view, and blueprint view? Try this, 1. Create a saved view in the source module with Parent, Code, and List Name details. 2. Import into the Target list. Also, apply a filter in the source module saved view to load only the new employees. ~Vignesh M

VIGNESH.M · ‎08-03-2020

Hi @tompatrick.ting, We should use CODE only to import between 2 models, not NAME. You are mapping it correctly. I think initially you mapped it to the Column 2:Building Code Name, then later you mapped it to Column 4: Building Code, but the system is still referring Column 2:Building Code instead of column 4. You can fix this in 2way, 1. Simply delete the action and recreate it, or 2. Map Column Headers to the Building code-Dum and check the Building code-Dum tab, all the previous mapping are gone now. Go to the Mapping tab and this time map it to the Column 4: Building code. Now check the Building code-Dum tab, this should work. Regards, Vignesh M

VIGNESH.M · ‎07-31-2020

Hi, Currently, we only have the option to choose 3 colors. It would be good to have more than 3 colors, but unfortunately, we don't have. ~VM

VIGNESH.M · ‎07-31-2020

Hi, Check this, the same question was answered. https://community.anaplan.com/t5/Anaplan-Platform/Level-2-Sprint-Activity-import-Data-into-DAT03-Historic-Volumes/m-p/55885#M9066 ~VM

VIGNESH.M · ‎07-30-2020

Hi, Yes, you are following the steps correctly. I hope you are not trying to add the data source. After selecting the label--> Edit-->Select the source view. ~Vignesh M

VIGNESH.M · ‎07-30-2020

Hi, For numbered lists, the Name is actually the system-generated #ID number, so w e should not map the list name. The name of the list comes from the properties(Display Name in your case). Remove the column 1 mapping and run the import and make sure Employee Name Column is mapped to the Display Name property. Check this, https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Lists_and_Roll-ups/Numbered_Lists/Working_with_Numbered_Lists.html?&_ga=2.258965322.1378461551.1596125865-1405091778.1591079526#Import%20-%20Code ~Vignesh M

VIGNESH.M · ‎07-30-2020

Hi, I hope you have already changed the source model, but still you are facing the Import issue. You can map the right Source view of each action manually, Follow the steps, Step 1: Copy the Source Label of 9.1 action Step 2: Go to Import Data Source and search the copied source label Step 3: After selecting the source label --> Go to Manage Data source -->Edit and point to your right data source(Select the model and saved view. After these steps, try running the action 9.1. Follow the same procedure for others. ~Vignesh M

VIGNESH.M · ‎07-27-2020

Hi, Can you confirm DCA is not enabled in the target line items? If enabled pls check the user has the write access.

VIGNESH.M · ‎07-27-2020

Hi @Misbah, In this case, the simple grid or multiple column export will give the flat module data with CC Ledger ID & Time as separate line items/columns. ~Vignesh M

VIGNESH.M · ‎07-26-2020

Hi @prabhu @JaredDolich , Why should not we create 3 more(Cost Center, Ledger Code, and Time) line items in the existing module, and while export just simply exclude the dimension names from the labels, this will also provide us the flat export file right? Why are we creating another list and extracting the same information again in the line items? ~Vignesh M

VIGNESH.M · ‎07-26-2020

Hi DM, It appears the DIR COA list is a ragged hierarchical list. In the ragged hierarchy, lookup works at the child level, not at the parent/summaries. As an alternate for Lookup use Select function. Why do you not want to use Select function, Is it a production list? ~Vignesh M

VIGNESH.M · ‎07-26-2020

@kunal_311, we should not post questions/answers from the exam in the community. Since you cleared the exam, I giving the answer. check your private messages. ~Vignesh M

VIGNESH.M · ‎07-26-2020

@DMManalili , Could you share some screenshot of what you are trying with an explanation?

VIGNESH.M · ‎07-24-2020

Hi, You have to use FINDITEM function and hierarchial relations are not required between the lists to use this function. Try this, It is not best practise to use all 3 functions in a line item, suggest you to use 2 more additional line items and calculate the NAME, FINDITEM and ISNOTBLANK separately. ~Vignesh M

VIGNESH.M · ‎07-24-2020

@bolinl1, No you don't have to set this every year. All the provided solutions are dynamic and it doesn't require any setup.

VIGNESH.M · ‎07-23-2020

Hi @bolinl1 , Try this method, similar to Jonathan's solution. ~Vignesh M

VIGNESH.M · ‎07-23-2020

Hi @seshireddy , So you are having 2 Hubs(H1 & M1), and H1 has the right information but M1 still showing the old data. You need to check the source table of the list in M1 first, Step 1: Go to M1 model --> Go to Actions --> Imports ---> Identify the import actions which loads data into this list --> Check the Source Object I assume, the source object is a saved view of another model Step 2: Go to source model --> Saved view --> check whether the source has the right information or not. Also, check which is the source model of these Hub model.. ~Vignesh M

VIGNESH.M · ‎07-23-2020

Hi @Rcampbell , To pull the data from another model, the user must have access to the model. Create a new role(e.g. Data Load Admin) in the model and remove access to all the modules except the modules used as a source of the import actions. Also, remove everything from the contents for this role and remove Workspace Admin access. Now the user has access to the model, and he can see the model but cannot see/access anything in the model... or You can create another intermediate model and bring all the details needed for the import and connect this to the target model. Source --> Intermediate --> Target ~VIgnesh M.

VIGNESH.M · ‎07-22-2020

Hi @Rajasekhar , Try my above solution, it will work perfectly for this scenario. @~Vignesh M

VIGNESH.M · ‎07-22-2020

Hi @tgovekar , I think you have enabled selective access to the dimension which present in ROWS of the DAT01 Beginning Inventory module. To see the data in the module, go to users---> choose your ID-->give write access to that list. Check this link,https://community.anaplan.com/t5/On-Demand-Courses/Selective-Access/ta-p/64300 ~Vignesh M

VIGNESH.M · ‎07-21-2020

Hi Kunal, Override Line Item is a driver that indicates whether to take Initial Demand Forecast Value or Override Forecast Value and it is a manual input by end-user, not formula driven. Based on it the Final Forecast Value Line item will give the result Write the formula in Final Forecast line item, If Override is true, then take value from the Override Forecast Value line item else take it from the Initial Demand Forecast Value. . ~Vignesh M