About mburdak

mburdak · ‎06-29-2022

Hi @neg177 To achieve this, you need to make a lineitem that only has values for the rolling 5 days. It's formula will be ' IF Rolling 5 days Forecast THEN Max cash demand ELSE 0'. The MAX of this lineitem will be your desired result, it can be achieved by setting the summary for this lineitem and MAX and referring the top level in the target lineitem. Hope this helps. Regards, Mandeep

mburdak · ‎06-23-2022

Hi @riteshshah There is a level mismatch on the Time Dimension, you need to use YEARVALUE() function to bring the yearly value to monthly level. There is no lookup needed for Product Family. Regards, Mandeep

mburdak · ‎05-25-2022

Can you share some screenshots of the problem you are facing with your module design, as well as the desired results.

mburdak · ‎05-25-2022

You have included an extra list in your 'Applies To' field. Remove the '---Subsets---' list from there and it would show as desired.

mburdak · ‎05-25-2022

Hi, This is the exact use-case for ISFIRSTOCCURENCE(), I think you have misunderstood the function. You don't need the concatenated list for this. Your formula will be ISFIRSTOCCURRENCE(Concatenated Values, ID List) , where 'ID List' is the list with 'ID1', 'ID2',.... as members. See the example here: ISFIRSTOCCURRENCE - Anaplan Technical Documentation Regards, Mandeep

mburdak · ‎05-20-2022

Glad to help. Can you click on Accept as Solution for my comment, for the one that helped you solve your issue. Regards, Mandeep

mburdak · ‎05-20-2022

Go to your DEM03 Module, Pivot it as: Set the time selector to Week 1 FY20 After that apply a filter as : And then uncheck the 'Override?' boolean for all rows that are visible.

mburdak · ‎05-20-2022

Change the summary for Beginning Inventory also, after that show where the values are not matching.

mburdak · ‎05-19-2022

Hi @gomathiv1411 If you are talking about the monthly numbers then, that is due to summary settings of the Opening Inventory and Closing Inventory lineitems. You have the summary as SUM, you should change the time summary to Closing Balance. Click here: and change it to: Other than that your forecasted demand is also 60 higher than expected in the first week, you would have to look into that also. Regards, Mandeep

mburdak · ‎05-19-2022

Hi @Mahesh839 This is happening because the format of your 'Size' lineitem in SYS06 Product Details is not set as the Size List. Please check the format and change it accordingly, you will need to import the size data again after changing the format. Regards, Mandeep

mburdak · ‎05-10-2022

Hi Jared, One approach for this can be creating a separate line item which transforms your data to a known scale and use that to CF your original lineitem. For example I have transformed my 'Data' lineitem to a 0 to 1 scale: Blueprint: When I apply conditional formatting to both as: You can see we achieve the desired result: There are other way to achieve the same result: If we create a list formatted lineitem with format as a dummy list that contains only 1 member, and hard-code that list member into the formula. Then we an use the MAX and MIN aggregation function to find out the maximum and minimum values(They work in similar fashion as SUM). Depending on the use case, TIMESUM function can also used. You can learn about both of these here: Aggregation Functions Other than SUM - Anaplan Community Hope this proves helpful. Regards, Mandeep Burdak.

mburdak · ‎04-21-2022

Hi @1635834 I have designed the following solution as per my understanding. First we have the Account Details module: And we have the Access Control Module: From this we can find out which user has access to which account: Now we can sum these to get number of account at Account Type level for each user: And finally we can bring these back to account level as per their type: This final module can be published as a KPI, and when 'User 1' and 'A1' is selected in the context selectors, it will show that User 1 has access to 3 accounts which are of the same type as account 'A1'. Hope this helps. Regards, Mandeep Burdak

mburdak · ‎04-21-2022

HI @1635834 By 'User', do you mean to imply the Users List? Also, how is the user access to the accounts defined. Regards, Mandeep Burdak.

mburdak · ‎04-21-2022

Sure here's the grid view: and the properties tab: I have used the code itself but you can also create a property called Week Number to do this calculation if you need code for something else. Regards, Mandeep Burdak.

mburdak · ‎04-21-2022

Hi @riyazpasha , This post is very similar to yours, hopefully the same trick will be helpful for you too: Solved: Re: Use "Previous" with non-timescale dimension - Anaplan Community Regards, Mandeep Burdak

mburdak · ‎04-06-2022

Hi @GeorgeDuckett , You just need to change the formula for the Closing Balance. In order to calculate Closing Balance, you don't actually need to calculate the Opening Balance first. Blueprint View: If you need to incorporate an opening balance for the first period, that can also be accomodated using IF statements in the Opening & Closing Balance lineitems. Hope this helps. Regards, Mandeep Burdak.

mburdak · ‎02-27-2022

Glad this worked out for you. Although ISFIRSTOCCURRENCE() doesn't require size to be a dimension. Let us say you have 'Product' list as dimension and the input lineitem as 'Size Input', then you can do ISFIRSTOCCURRENCE(Size Input,Product). This will result in a boolean that will only be true for unique entries of size along the Product list, which can be used with your existing 'newsize' logic, and will eliminate all errors while importing. Example Blueprint View My 'Size' list only had S,M and L in it.

mburdak · ‎02-24-2022

Hi @rosmiller, Have you tried importing the size lineitem as text, then using a FINDITEM() on that lineitem to check whether that size already exists, if it doesn't(the result of FINDITEM() is blank) then ISFIRSTOCCURRENCE() can give you a boolean that can be used to filter only non existing unique entries. You can create 2 booleans using these 2 formulas and then create a saved view filtered by these boolenas to update your size list. Hope this helps, Regards, Mandeep Burdak.

mburdak · ‎10-11-2021

Hi, It has moved to the bottom of the left side bar. Regards, Mandeep

mburdak · ‎10-05-2021

Hi, I assume that you are already using Anaplan Connect, if so you can edit your import batch scripts to clean data before running the import. The easy way if your system has Powershell(Windows 7 or newer have this built-in) is to call the powershell command "-replace" from your batch script which will help you replace any characters/strings with your desired characters/strings. Eg: powershell -Command "(gc myFile.txt) -replace 'dog', 'cat' | Out-File -encoding ASCII myFile1.txt" This line will replace all the 'dog' that exist in myFile.txt to 'cat' and save the file as myFile1.txt. powershell -Command "(gc myFile.txt) -replace 'dog', '' | Out-File -encoding ASCII myFile2.txt" If we don't provide empty single quotes as the second string then it will remove 'dog' from myFile.txt and save it as myFile2.txt. The myFile.txt needs to exist in the same folder as the batch script for this to work. If they exist in different folders you can use 'cd' command before this command to go to your text file location, and then use 'cd' again to come back to your script location. I hope this helps, Good luck Mandeep