About anirudh

Agree entirely, my method should be used only if source data correction is not possible. However, I would assume the disadvantages you mentioned are reduced as I suggest deleting the staging list as a final step in the process. Would like to know more if I'm wrong here! Thanks, Anirudh ... View more

Hi mooreta,   As pointed out by Misbah, it would be advisable to stay away from your approach number 3 as it is not recommended to have text formatted line items unless absolutely required. Absent any solution from the data source and in the vein of approach #2, I would suggest the following:   Create a numbered list for staging the styling data in this list  Import all rows of your file into this list using combination of properties of Style and Pieces (Action #1) Create a module with the dimension of the list created and have 4 line items, Style, Pieces, Style IFO and Delete All. The last 2 line items should be Boolean formatted. Formulas   Style: Staging List.Style Pieces: Staging List.Pieces Style IFO: ISFIRSTOCCURRENCE(Style, Staging List)​ Delete All: TRUE​   Now create a saved view in the module with all rows and columns exposed and then apply the Style IFO line item as a filter to this saved view Import into your actual Styles List and Module using the saved view (Action #2) Create a delete using selection action and delete the Staging List using the Delete All Boolean (Action #3) Create a Process and add the Actions #1, #2 and #3 Going forward, use this process to update the list and module  This should give you your desired result and avoid unnecessary calculations and space consumption. Let me know if this helps! Regards, Anirudh ... View more

Hi,   Can you please share a screenshot of the date that you are trying to import into Week Date, so I can look at how the source date is formatted? ... View more

Hi Asha, Please follow these steps:   1. In L6 module create 2 line items:      a. Count - Number formatted with the formula as 1      b. L3 Parent - L3 List formatted with the formula as PARENT(PARENT(PARENT(ITEM(L6 List))))   2. In L3 module create 1 number formatted line item called Count with the formula L6 Module.Count   3. Now in the L6 module create a line item with the formula: (L6 Module.Data[LOOKUP: L3 Parent] * Count)/Count[LOOKUP: L3 Parent]   Please let me know if this helps   Regards, Anirudh   ... View more

Yes, with Anaplan connect you can use an argument to specify a permanent destination. Then just click the batch script and the export will land in the folder where you want to execute the macros Here's an example export script:   @echo off set AnaplanUser="Anaplan.User@anaplan.com:Password" set WorkspaceId="8a1234567897c12b014bf01234567890" set ModelID="CD1234D60CA84E9A123C1C5D061C1234" set Operation=-export "Employee by Department.xls" -execute -get "C:\Employee.xls" rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model%ModelId% %Operation% @echo %Command% cmd /c %Command% pause   You can define the destination using the get part of the script However, you will need Java for Anaplan connect to run   Let me know if you need addtional help setting this up   Regards, Anirudh   ... View more

Hi Mark, Are you using Anaplan connect? ... View more

Hi Inoue, To get around this, just create a line item in any module and delete it. This will register as a change in Anaplan and the option to create a revision tag will also appear Regards, Anirudh ... View more

Simple!   Create a new module dimensioned only with the list you want to delete and create a boolean formatted line item called Delete. Set this formula to TRUE Then go to actions and create a new delete action. Pick the list you want to delete and the line item as the line item created above   Run the action and this will truncate the whole list     ... View more

Glad I could help! If you don't mind please mark my reply as the solution so it helps in the future if others have the same question ... View more

Try this Create a number formatted line item with the formula called Color: IF 'Boolean' THEN 5 ELSE 0   Then go to conditional formatting options and use these settings   If the parents are highlighted too brightly as compared to the other list members, set the Color line items summary to Average. Set it to none to avoid colors at the parent level entirely   Regards, Anirudh ... View more

@VarshniR  In the destination module, when you're saying SUM is applied it means that the list to which it is applied, in this case your BU list, is a dimension in the destination module and a property/line item in the source module.   Refer this part of your formula to know which list is being used for SUM [SUM: 'Capacity - Analysis (Input/Output) - Actual'.BU] And check which list is being used as the format for the line item referred in brackets   Essentially, SUM converts data from a flat format into a multi-dimensional format   I hope this clarifies   Regards, Anirudh ... View more

Hi Inoue,   I see you have applied 2 filters: Filter Product and Filter ETD/DO   1. If you want both the filters active: The caution mark indicates that the filter is not working anymore. This is probably due to the 'Filter Product: Product' line item having dimensionality that does not match the rest of the module. Please check the dimension of this line item and make sure it is the same as the rest of the module (an extra user dimension is ok and will not cause the filter to fail)   2. If you want only the Filter ETD/DO filter active: Simply click this button highlighted in red and the filter causing the error will disappear along with the caution mark   Regards, Anirudh ... View more