Platform

VIGNESH.M

Hi, Assume we have L1->L2->L3 In this case, each list item present in L2 is a branch, list item in L1 is a branch. Lowest level of hierarchy is not a branch, in this example L3 is not a branch. ~Vignesh M

VIGNESH.M

Hi, We can get the %contribution at different levels. Please see the screenshot. Try this Hierarchy I have : Product L1->Product L2->Product L3 if you want a line item that returns the value at the next level up a multi-level hierarchy(Example Product L2), I think this will clear your doubts, Regards, Vignesh M

VIGNESH.M

Hi, Please check the below link. https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Setting-up-dynamic-list-of-values/m-p/41973#M4455 I hope this can clear your doubt. Regards, Vignesh M

VIGNESH.M · ‎06-18-2019

Hi Rahul, Include list item name in the Checksum condition. So in this way without any manual change , the data will go to spoke model. Please read the attached link, point 7 for clear picture. https://community.anaplan.com/t5/Best-Practices/Building-a-Data-Hub/ta-p/33593#toc-hId--214315258 ~Vignesh M

VIGNESH.M · ‎04-13-2019

Hi John, Check the summary of the line item, I assume you are seeing the data in Higher level with the summary as NONE. ~Vignesh M

VIGNESH.M · ‎04-11-2019

@saurabh.raheja , Check the role of the person whom it's working with WSA access. I assume the person has Full access with WSA. You are not getting any error and its working for WSA full access, so it must be an Access issue. Check the selective access. ~Vignesh

VIGNESH.M · ‎04-11-2019

@saurabh.raheja , Can you share the screenshot of the error? It's working for Full access role, but not working for end users? ~Vignesh

VIGNESH.M · ‎04-11-2019

Hi Saurabh, Check all the below items, 1. Action Access 2. List Access 3. Source Module Access 4. Target Module Access ~Vignesh

VIGNESH.M · ‎04-03-2019

Hi Vamshi, Unfortunately, we can't bring this in one line. we don't have the option to increase the column width. We have only these two option, you can publish the grid directly by hiding other line items. ~Vignesh

VIGNESH.M · ‎04-03-2019

Hi Sasi, To make it dynamic, try the below steps Step 5: Create a module as below, Mark the boolean as shown above. Step 6: In Quota subset filter Module, add 2 more line items(PY, CY) and write the formula as shown below. Finally, your filter logic will be this, IF Filter Test Mod.PY THEN PY ELSE CY in this way, you can achieve the dynamic filter. Thanks @LipChean_Soh , I learned something new about line item subset. ~Vignesh

VIGNESH.M · ‎04-03-2019

Hi Sasi, I have tried to create the scenario you are working on, Input Module, with 3 line items Pls try this method, Step 1: Create a line item subset using the "Quota input" module as shown below. Step 2: Create a module(Quota subset Module) as shown below, use the Quota subset, Time as dimensions. Step 3: Manually Mark the respective Quarters, I am not able to right logic in this module, because of using the line item subset, so I marked it manually. Step 4: Apply the filter in your Quota Input modules, ~Vignesh

VIGNESH.M · ‎04-02-2019

Hi Sunil, You can achieve this through "Formula Scope" Also, your Forecast version should be the Actual Version. Check this link for more info, https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Blueprint.html?Highlight=blueprint%20view&_ga=2.61357164.1332292970.1554096830-917818843.1551254900#FormulaScope ~Vignesh

VIGNESH.M · ‎03-27-2019

Hi Sk, In your conditional format line item, check whether Active boolean is true or not? Try the below method, ~Vignesh

VIGNESH.M · ‎03-27-2019

Hi Edward, Your Role line Item "Applies to" should be Reps L4, not Roles. Change applies to Reps L4 as shown below. Role Line item is getting the role of each rep, so it should be calculated at rep l4 level. ~Vignesh

VIGNESH.M · ‎03-27-2019

Hi Edwards, Can you check your Region, Role line items are formatted correctly as shown below. Region - Geos L1 Role - Roles ~Vignesh

VIGNESH.M · ‎03-26-2019

Hi Pradeep, We have the option to apply logic only for a particular version, Check the Formula scope in the blueprint view. in this example, I want to write logic only for Forecast version, so I selected "All versions except Actual" if you see, my Actual version is editable now, the formula I have entered is only applicable to Forecast version Check this link for more information https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Blueprint.html?Highlight=blueprint%20view#FormulaScope ~Vignesh.

VIGNESH.M · ‎03-26-2019

Hi, Your source module is at Month Name list dimension, target module is at Anaplan Time. To connect this, Create an intermediate module to make a connection between Month Name list and Anaplan TIme Dimension as shown below. Manually select the respective month Name from the dropdown for now. Bookings = ReservationSequencing.ResToBook %[LOOKUP: Time Map.Month ] ~Vignesh

VIGNESH.M · ‎03-20-2019

HI Tsugumin, In your CSV Template file, the time format is YY-MMM. Try the below mapping. ~Vignesh

VIGNESH.M · ‎03-20-2019

Hi Karank, As per my understanding, the source table should be always more than 1 dimension. if it's 1 dimension, then this is how the grid appears in the import tab. ~Vignesh

VIGNESH.M · ‎03-20-2019

Hi Karank, if the source and target table dimensioned by line item, then it won't work, you have to add Dummy dimension in your source table. Follow the below steps, Step 1: create Dummy List, with 1 list item. Step 2: In your source module, add this "Dummy Import" Dimension. Note: Add this extra dimension only in your source table, not in Target Table. Step 3: Create the import action as shown below ~Vignesh

VIGNESH.M · ‎03-19-2019

Hi, It seems the date format you set for the line item is incorrect. If its a model to model import, then it's not necessary to set the date format. Uncheck the Target Date Format, and run the import. ~Vignesh

VIGNESH.M · ‎03-14-2019

Hi Gregory, I assumed the data in NUM 1 and NUM2 can be any numbers, so I tried it in a different way, if the NUM1 and NUM 2 are random numbers, then try this solution. ~Vignesh

VIGNESH.M · ‎03-14-2019

Hi Gregory, I Assumed your model contains 2 years data, So total quarterly no will be 8(2*4) records. I created a list as shown below, Then Create a module with 3 line item and Quarterly Count list to find the quarter, as shown below Formulas in Line item, A = PERIOD(START()) + VALUE(NAME(ITEM(Quarterly Count))) B = Retrieve time period.'Num 2' = Retrieve time period.'Num 1'[LOOKUP: A] C = IF B THEN A ELSE BLANK In Final Module, pick the data from the "C" line item. Grid View, Try this solution. ~Vignesh

VIGNESH.M · ‎03-13-2019

Hi Jessica, Try the below method, Check the link for more detail, https://community.anaplan.com/t5/Anaplan-Discussions/Need-Formula-Help/m-p/41894#M4432 ~Vignesh

VIGNESH.M · ‎03-13-2019

Yes, Vamshi.

VIGNESH.M · ‎03-13-2019

Hi Vamshi, What I suggested will load data for one record based on the Item in the filter. Next time, select the different record and load data for that record only. Your previous record data will be still the same. ~Vignesh

VIGNESH.M · ‎03-12-2019

Hi, In your Source Data, you have Date Dimension, So you need to include Time in your Formula Try the below Logic, Source Module.Production Vol[SUM: Source Module.Product, SUM: Source Module.Time, SELECT:VERSIONS.Forecast] OR If Forecast version is your Current Version then you don't need to include Version in the formula Source Module.Production Vol[SUM: Source Module.Product, SUM: Source Module.Time] ~Vignesh

VIGNESH.M · ‎03-12-2019

Hi Vamshi, In your case, "Ask each Time Import is Run" will import the sum of the records data into 1 particular record. Example, the Sum of all records loaded into ITEM 1 which I selected. Try the alternate way to achieve the same, Create a filter line item to select which particular record needs to be copied. Apply the same filter in your import view and map the dimensions. ~Vignesh

VIGNESH.M · ‎03-11-2019

Hi, Create a line item(Number Format), then Use the below logic, Logic, IF ISBLANK(TEXT(Rank)) THEN 0 ELSE Rank Rank is my source line item in my example, Rank final is FInal Value. In your example, Forzen TAT is Source. if you dont want to see "0" in final value, change the zero format to Blank. . ~Vignesh

VIGNESH.M · ‎03-10-2019

Hi Greg, Please follow the below steps, #1. Create a line item (Zero Month), set format as month and set Summary as last non blank Write the below logic in Zero month Line item #2, I have created another module to count the zero month, There are there line item in the module, dimensions are Lists A and Line item Zero Month = Zero Count.Zero Month[SELECT: TIME.All Periods] Current Month = PERIOD(CURRENTPERIODSTART()) Count = YEAR(Current Month) * 12 + MONTH(Current Month) - (YEAR(Zero Month) * 12 + MONTH(Zero Month)) ~Vignesh

Platform

Academy

Master Anaplanner

Programs

About VIGNESH.M