About Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @johan.marketoft, I hope this is what you are looking for: Step 1: I created a system module with 2 flat list as dimension(Store, Product) A Line item To be sold -> if you want to sell product in that store you should mark it as true. Code is generated only if (To be Sold) is marked as True else product combination code won't be generated. Step 2: Create a saved view, Only (To be Sold is set as True) Step 3: Import into numbered List as i suggested in my previous post. Step 4: A new Module with the numbered list as dimension. With the help of new code, product name and store name are generated. Let me know if you need more clarity or send some screen shots for better clarity. Thanks, Sorna Raja Prabhu.

Sorna Raja Prabhu

Hi @Sravan_Kumar , You should learn Selections and Synchronizations. Read this article. https://help.anaplan.com/anapedia/Content/Modeling/Working_with_Data/Selections/Selections_and_Synchronization.html Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @johan.marketoft, Whenever you want to import into your numbered list, you have to import the code first. I have assigned code for Product and Store. Second i have created a module, with product and store as dimension, and a line item which is the concatenation of product and store code. While importing into a numbered list, map the code which which u have generated previously. Final numbered list I tried to replicate your scenario and gave you a overview of numbered list import function. if you have any doubt let me know.

Sorna Raja Prabhu

Hi @mikeng, I am not aware, how to bring parent using selective access. But i have a idea of using SELECTIVE ACCESS and DYNAMIC CELL ACCESS. Step 1: Create a System Module with user list (Custom User List) and budget List(Child Level) as Dimension and 1 Boolean formatted line item(lets say "ACCESS"). Change the summary for ACCESS to Any. Step 2: Provide selective access to Custom user List. Step 3: Enable(Mark True) the budget list (Child Level) that the particular user can view/edit in System Module. Step 4: Apply the filter to your corresponding module. Step 5: After publishing in the dashboard, You can dis-enable Data->Filter access for the module form Menu option in Dashboard design settings, so that business users cannot remove or change the settings. if you like this let me know i can give some visual example or let us wait for some better suggestion from Anaplan Team. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Yes, I misunderstood. I Thought he is asking for Link.

Sorna Raja Prabhu

Hi @LucaFilippi, Answer for your Question 1: There is a section to get your certificate. go back to learning portal to get. Answer for Question 2: Refer @Misbah Comments. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @CommunityMember125605, You can read these link. https://community.anaplan.com/t5/Best-Practices/Reduce-Calculations-for-Better-Performance/ta-p/33667 https://community.anaplan.com/t5/Best-Practices/Good-Practices-to-Improve-Model-Performance/ta-p/33550 https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Optimizing_Time_Calculation_Performance.html?_ga=2.22076146.877218290.1585554782-1689807040.1585554782 In Anaplan Community use the search bar and search "Performance", you will get more useful links Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

@ravish106 - Try Using Different Browser. if you still face the same issue in different browser, First -> then inform to your Tenant administrator. Second -> write your issue to Anaplan support team (support@anaplan.com). Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @ravish106, Wait for 5 mins and refresh the browser and search "Level 2 Data Hub". Finally you will see like this. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @KMc , Try this way, Mark Column 2 Code for Employees and check. Step 2: Then import, Mark Column 2: Code for #E2 Employees Now it should work, if you are still facing same issue try to clear your cache & cookies then try to upload again or try at some different browser Thanks

Sorna Raja Prabhu

Hi @akprasa1, I have another approach, Step 1 : Create a System Module with 1 line item to manually enter the Calendar year's Starting date. Eg; 29th December 2019 as First Staring day for calendar year 2020 Step 2: in Your Main Module create 4 Line items. Formulas are : Today's Date : Manually enter the date, which you have to calculate the week for. Total Days : 'Today''s Date' - System Module.First Week Starting Date (To Calculate number of days between Today's Date and Year Starting Date) Remainder : MOD ( Total Days, 7 ) Week Number : IF Total Days = 0 AND Remainder = 0 THEN 1 ELSE IF Total Days < 7 AND Remainder < 7 THEN 1 ELSE IF Total Days > = 7 AND Remainder < > 6 THEN ROUND ( Total Days / 7 , 0 , DOWN ) + 1 ELSE ROUND ( Total Days / 7 ) easy logic -> let me know if u didn't understand. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Thank you Misbah, for the suggestion.

Sorna Raja Prabhu

Hi @akprasa1, You can achieve this using PERIOD() Function Step 1: Line item - Date(Date Format), Week Number (Time Period - Week Format), and a number formatted line item. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @BahalR, The Best part of Code is - even if the List item name is different but code are same, then mapping happens automatically in Anaplan. Code Represent a single unique entity, But this entity can be called by different names -> here in your case P2 and R3 SKU. If the code is not same, Mapping won't happen and you have to do manual work (Doing Manual Work is not the best approach). You can read this article https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Lists_and_Roll-ups/Numbered_Lists/Working_with_Numbered_Lists.html#Import%20-%20Code

Sorna Raja Prabhu

Hi @BahalR, Yes it is Possible. Point 1: Make sure that, the code for P2 SKU and R3 SKU are same. Point 2: L2 Country is a addon Dimension in Module 2. You can either select Fixed item or Ask each Time import is run -> based on your requirements. Hope it Helps,

Sorna Raja Prabhu

Hi @krw6, The error "Not Recognised as a Line item or List member" means, There is a spelling mistake either in your module name or Line item name or (Module or Line item is not exists). Instead of copy-past, Try to select the line item by double-clicking the formula. Hope it helps,

Sorna Raja Prabhu

Hi @krw6, Anaplan is easy to learn. First, love your work and Don't Get Frustrated. Case 1: Source Module (List A as Dimension) and Target Module (List A as Dimension) ---> Direct Relation. In This case, Direct reference is enough. Case 2: Source Module (List A, List B) and Target Module (List A) ---> Partial Relation In this case, You can directly refer to a Source Module, but Think What you want from List B -> now you have to use either Sum, Lookup, Select and etc to select a particular List item from List B. Case 3: Source Module (List A) and Target Module (List B) ---> No Relation In This Case, you have to create another Line item or look for another Module to make some relation between Source and Target. Eg: Create a new Line item in the Target Module of List A format, now relation is established via Line item in Target Module. First, establish a relation and Write Formula. Study the link suggested by @Jared Dolich Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @Sravan_Kumar, Sorry I failed to add some points. If you Feel more Products are there and you don't want to do more manual work. Then you can set parent-child Hierarchy for Country-Product. and Set Selective Access (True) for Parent(Country). Then in Users Setting, Under Country Write Column You can Select only Parent (Country), Products will automatically appear. Hope it Helps.

Sorna Raja Prabhu

Hi @Sravan_Kumar, Yes it is possible Step 1: In General List, Select the List which you have to do selective access(Filter - as you mentioned), in your case Region and Fruit. Step 2: Go to users, Select the Region Read, Region Write and Fruits Read and Fruits Write which the users can only see in Dashboard Hope it Helps. See Selective Access in Anapedia for more info. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @HendrikDeCuyper, Can i assume, you are trying to calculate, number of days between the line item Days you can order - Which is set as True. Eg: in your example Days you can order is set as true on 9 and 14th April 2019. -> 4 days is between 9 and 14th April.....? Is that the result that you are expecting on 9th April....?

Sorna Raja Prabhu

Hi Jared - I am interested to know your approach, can you give some visual example 🙂

Sorna Raja Prabhu

Hi @krw6, Currently what you are doing is correct. Your mapping is also correct. Point 1: if you want to hide unnecessary columns, -> "Yes you can". Right click on any line item or column or Row and use Show or Hide or Select Levels to Show or Select Items to Show features. But what i mentioned in Point 1, is not required, Just letting you know that this is possible. Thing you can concentrate now, how to map Time.

Sorna Raja Prabhu

Hi @Star , On Modules there is a versions column, you can change from Not Applicable to ALL Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Thank You Filip for suggesting best way.

Sorna Raja Prabhu

Hi @Ana_M, Yes it is Possible. Step 1: You have a Time Dimension Module and amount line item. Create another Line item(last non blank) of Text format and write the formula as mentioned below. Step 2: Change the summary for Line item(last non blank) as mentioned below Step 3: Your new module with no time as dimension. write the formula as mentioned below. Rename the line item name as per your business case Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @takushimozuru, I am proposing 2 suggestion for your question. Step 1. Displaying only current month Lets say out current period as "Mar 20" Step 2: I am retrieving current date (If you want to write a formula you can or you can select the date) Step 3 : i am writing logic to filter current month, current and past month and current and future month Step 4 : You can apply this filter to your main module. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @krw6, Error is in your line item name. Double click your current line item or the line item which you are trying to write the formula and select the appropriate line item from REV02 Volume Inputs Module. In this approach you won't be writing, instead Anaplan will help you in fetching the name. Thanks, Sorna Raja Prabhu

Sorna Raja Prabhu

Hi @jairam, In this Scenario, What should be the output (C) ...? Scenario-4 Jan-20 Feb-20 Mar-20 Apr-20 A TRUE FALSE FALSE TRUE B 78 34 56 93 C I am little confused, in the previous post you have mentioned, (get the previous value in same cell not previous period). In this Scenario, what is the previous value in same cell for the Period - Apr-20 ?

Sorna Raja Prabhu

Hi @jairam, As you mentioned Logic earlier: IF A then Previous(C) else B and considering your scenario 3 Scenario-3 Jan-20 Feb-20 Mar-20 Apr-20 A TRUE FALSE FALSE FALSE B 200 200 200 200 C 100 200 200 200 Your Previous question : " Now changing Values in B. The C should retain 100 (previous value in same cell). - Ignore the calculated value." and i didn't understand how and why C should retain 100. can you explain in detail....?

Sorna Raja Prabhu

Hi @Star, 1) For best practice, I would imagine it is better to import Codes rather than Names, right? Yes you are right. Reason is : If you have a numbered List, you may have Some duplicates List item name, Only code will be unique and only codes can differentiate between the duplicates. 2) For Size, any difference between defining Fixed Line item and Column 4: Size? Yes, There is a difference. Consider this case, I have a module which has Rank (First, Second, Third, Fourth......) and Day (Monday, Tuesday, Wednesday, Thursday.....) as a Dimension and Value as Line Item. While Importing Data(Value Line Item) into a module, See the difference between fixed item and Column Here i have Defined Column 1 for Rank As a Result, All Ranks are Mapped Accordingly. This is the output. Scenario 2: Marking Rank as Fixed item Here to the Note : If i mark as Fixed Item, i asks me to select any one Rank So only your business case/requirements decides whether fixed item or column is suitable. Hope it Helps.