About anirudh

Hi Jerin,   Create a properties module for your list with three text fields line items the boolean line item. Then in the form designer, point to this module in the highlighted area     When user clicks on the form, all the fields will show up   Regards, Anirudh ... View more

Hi Ishan, Page selector is a dimension applied to the module, whereas the Business Units is a list formatted line item. They are conceptually different things in Anaplan You cannot filter a line item based on a page selector To filter second module based on the Business Units line item, you should right click on the line item and use the Filter option. Alternatively, use boolean-type filtering on the module Regards, Anirudh ... View more

Hi Johan, In the Property Module, create 2 line items. One formatted by Quarter and one by year; name them Cost Start Quarter and Cost Start Year. Formula for both is PARENT(ITEM(Cost Start)) In the Calculation module, create a number formatted line item; formula: IF Property Module.Occurency = Occurency List.One Off     THEN IF ITEM(Time) = Property Module.Cost Start         THEN Property Module.Amount ELSE 0 ELSE IF Property Module.Occurency = Occurency List.Monthly     THEN IF ITEM(Time) >= Property Module.Cost Start AND ITEM(Time) < Property Module.Cost Start + Property Module.Number of Months THEN Property Module.Amount ELSE 0 ELSE IF Property Module.Occurency = Occurency List.Quarterly     THEN IF PARENT(ITEM(Time)) >= Property Module.Cost Start Quarter AND ITEM(Time) < Property Module.Cost Start + Property Module.Number of Months THEN Property Module.Amount ELSE 0 ELSE IF Property Module.Occurency = Occurency List.Quarterly     THEN IF PARENT(ITEM(Time)) >= Property Module.Cost Start Year AND ITEM(Time) < Property Module.Cost Start + Property Module.Number of Months THEN Property Module.Amount ELSE 0 ELSE 0 I'm assuming the number of months driver is applied at the month level. Ex: Cost start is set to May 2020, Occurency is set to Quarterly and Number of months set to 4. The amount will be populated for Apr 2020 to Jul 2020 Let me know if this works for you Regards, Anirudh ... View more

Of course!   Pivot the region dimension to page selector and publish your 2 pie charts to the dashboard with the region you need pre-selected. Then simply disable synchronization and change the Initial Page of each chart to the member you want it to be locked at       Regards, Anirudh ... View more

Hi Hannah, Although it does not contain a video demoing integration between ECC and Anaplan, this page documents hyperconnect integrations very well: https://help.anaplan.com/anapedia/Content/Data_Integrations/Anaplan_Hyperconnect.htm Regards, Anirudh ... View more

Hi Keerthana, What do you mean by using in real time? ... View more

Hi aevmajor, Looks like you added too many dimensions to that line item in the Applies To Regards, Anirudh ... View more

Hi Shadmani, For hierarchy purpose create a rank line item with this formula: RANK(Date, DESCENDING, MINIMUM, TRUE, Emp ID) By using the Emp ID in the rank group argument, the ranks will be split for each employee. So the first three entries will have the rank of 3, 2, 1 respectively. The next employee will have its own ranking as well Now to create the hierarchy, create line items that exclude the metadata without the rank 1. For example the dates line item would be: IF Rank Hierarchy = 1 THEN Dates ELSE BLANK. Create similar line items for Country, Dept and Salary. Then use those line items to create the employee list after excluding the blanks For the calculation create another rank line item called Rank Calculation with the formula: RANK(Date, ASCENDING, MINIMUM, Dates <= START(Time.'Nov 20'), Emp ID) Now this formula will automatically exclude the entries after Nov 20 (They will have a rank of NaN) and just as before all the entries before 11/01/2020 will have their individual rank. I have used November 2019 in my screenshot:   Again create line items which exclude all entries except rank = 1. Dates formula would be: IF Rank Calculation = 1 THEN Dates ELSE BLANK. Create similar line items for Country, Dept and Salary. Then use those line items to do your calculation 1 For calculation 2 use the same line items that you used to create the hierarchy Let me know if you need more help with this   Regards, Anirudh   ... View more

Hi robinsalk, Yes that's exactly the best practice approach. Ensure that only model builders have access to the test environment (model and new ux app) after go-live Regards, Anirudh ... View more

Hi veerendra, Cloudworks was just deployed and is available to all customers. It supports picking up files from S3 bucket Follow the guide here: https://help.anaplan.com/anapedia/Content/Data_Integrations/Integrations_framework/Create-a-new-connection.htm?cshid=a-321a1107-f790-415b-bd33-0d933dc6e82d Regards, Anirudh ... View more

Hi Chris, As far as I'm aware, there's no other way to add users into the Anaplan environment In my experience, most clients already have several service accounts for existing data integrations. We usually just use one of those existing accounts instead of creating a new one. A DL is definitely less secure and could circumvent the user dimension and other selective access enabled lists... Regards, Anirudh ... View more

Hi Shirisha,   What exactly are you expecting the result to be like after sorting? Do you want the sort line item to consider values in the other dimension as well?   Regards, Anirudh ... View more

Hi Karthik, Can you post the names of the apps? Regards, Anirudh ... View more

Hi Tharik, Can you explain what exactly you want to do with the Top Level in the level 1 list? Do you want to activate a filter if top level is selected? Or do you want to sum up all the children when top level is selected? Regards, Anirudh ... View more