About Jsdeloria21

Jsdeloria21 · ‎02-19-2020

Hi Jared, Thank you this was very helpful and I was able to solve it.

Jsdeloria21 · ‎02-17-2020

Hi Guys, I have a simple one to ask. I am loading a Period with a Text format to a Year and Month with a Number format. Example: I loaded a date of Jan 13 to a Period column. Then I need to convert it to Month 1 and Year 2013. I tried loading it as Time period which is the right way but for some reason it is not loading successfully. See below Appreciate the help. Regards,

Jsdeloria21 · ‎02-16-2020

Hi Jared, Thank you for taking time in answering my query. Regards,

Jsdeloria21 · ‎02-13-2020

Hi All, I just need a little opinion whether excel is wrong or Anaplan. See below. So i only copied the values so there is no formula. Excel Driver Cumulate formula it adds the Excel Source value and Excel Source Plus value. So its like Sum(Value, PLus Value). The problem that I have is in Excel Driver when they cumulate Month 1 and Month 2 are both 25. In Anaplan, Month 1 is 25 and Month 2 is 38 (25+13). Which one is correct the excel or Anaplan formula? I just need to get some insights on this to understand better where my formula encountered a problem. Appreciate the response. Regards

Jsdeloria21 · ‎02-11-2020

Hi, Appreciate your response. Here is the formula from the Drivers module. Row 1 in the example. 'Row 6' * '(M) Actuals - Details (V)'.'SALES VELOCITY/MO. (NET)' Row 6 is in the same module which results to a sequential number (1,2...55). '(M) Actuals - Details (V)'.'SALES VELOCITY/MO. (NET)' - Is part of the assumption module which is inputted (Constant value 5).\\ Row 2 in the example IF 'Row 7' < '(M) Actuals - Details (V)'.'SALES VELOCITY/MO. (NET)' THEN 0 ELSE IF CUMULATE('(M) Actual Monthly - OPStat (V)'.'(B& FP) Units') + CUMULATE('(M) Actual Monthly - OPStat (V)'.'(R& w/ DP) Units') < '(M) Actuals - Details (V)'.'TOTAL NO. OF UNITS' THEN '(M) Actuals - Details (V)'.'SALES VELOCITY/MO. (NET)' ELSE '(M) Actuals - Details (V)'.'TOTAL NO. OF UNITS' - (CUMULATE('(M) Actual Monthly - OPStat (V)'.'(B& FP) Units') + CUMULATE('(M) Actual Monthly - OPStat (V)'.'(R& w/ DP) Units')) It basically adds the cumulative value of two line items in the FS report from Jan 13 to a specific date base on the drivers module. total number of units is 448 which is a formula. Countif Module IF '(M) Actual Monthly - Drivers (V)'.'Row 7' <= 0 THEN '(M) Actual GENCOM - (V)'.'Count Resi (Res,DP)'[SUM: 'Driver Module - Gencon (V)'.Period RS] ELSE '(M) Actual GENCOM - (V)'.'Count Resi (Res,DP)'[SUM: 'Driver Module - Gencon (V)'.Period RS] (M) Actual GENCOM - (V)'.'Count Resi (Res,DP)'[SUM: 'Driver Module - Gencon (V)'.Period RS] = Is the formula to count units from the source module depending on the date (Driver Module - Gencon (V)'.Period RS). Regards,

Jsdeloria21 · ‎02-11-2020

Hi Guys, I need help in figuring out a workaround for Circular Reference. I recreated the modules the best I can and I hope its enough to understand. See below: This is the driver module and this is already working fine in Anaplan. Lets say Row 1 and Row 2 and then Time Dimension. This is the countif module, this also working fine in Anaplan. This is the Target Module. This is where the Circular reference is appearing. The formula here is IF Driver Module Row 1<=0 THEN Countif Module ELSE Countif Row 1+ Driver Module Row 2 the logic here is when Driver Module Row 1 is valued at 0 then it should capture Countif Module Row 1 and if Driver Module Row 1 is more than 0 then it should capture Driver Module Row 2. This part of the formula has no problem IF Driver Module Row 1<=0 THEN Countif Module ELSE Countif Row 1 but when I add + Driver Module Row 2 in the formula that is where the circular reference comes up. Any idea? Thank you in advance. Regards,

Jsdeloria21 · ‎02-06-2020

Hi Amaya, Appreciate the response and sorry about the confusing explanation. Regards,

Jsdeloria21 · ‎02-06-2020

Hi Jared, Appreciate the response. So the formula of your Target Sales Cumulate is Cumulate(Sales) i just need to add the identifier as a condition? Regards,

Jsdeloria21 · ‎02-06-2020

Hi Guys, I have been working on this formula for quite a while now, I hope you can give me an idea on how to do this. I will explain it as much as I can since I cannot provide a screenshot of the actual report from the client. I have 2 tables with Line Item and Time Dimension. "Value 1" row has the value, "Identifier" row , and "Target Result" row is the target module. so the formula is that IF Identifier is greater than 1 then I need to add the values from previous months. In the Target Result row, May 2013 has the value of 50 because the condition should add values from Jan 13 until Apr 13 which results to 50. Same thing with Jun 13 since Identifier is 1 it will add values from Jan 13 to May 13 and so on. It means the formula is moving as the months progress. I hope you can give me an idea on the approach as to how to do this. Regards,

Jsdeloria21 · ‎02-05-2020

Hi Guys, I have an issue that I put in a document since for some reason I cannot paste a picture here on the body of this screen. I am sorry if I cannot provide the actual screenshot since it is the clients data. But I recreated it as much as I can. Please see the attachment for details. And again I appreciate the help Regards

Jsdeloria21 · ‎01-31-2020

Hi Misbah, Appreciate the help on the issue. I just want to know how can I continue the numbers 1, 2, 3, and so on. Apparently the clients requirement is continuous counting until the end of the time range. Regards,

Jsdeloria21 · ‎01-30-2020

Hi Guys, I just want to ask help on the formula. I was able to create a formula and got the values but the succeeding time does not show no values. This is what it looks like in excel I also included the formula on the sheet for col K, L and M. Row 7 will just add values. I got the first two values correctly. See below Row 6 line item is the one that needs the formula for the SUM in excel. Appreciate the help Regards,

Jsdeloria21 · ‎01-29-2020

Hi Misbah, I tried to change the Set ExportName to SetProcessName and it still just flashing then disappear. Also, upon checking the document it is more confusing since it has a different approach.See below I did this approach the first time and it did not also worked. But I will try to recreate this script and run it. Regards,

Jsdeloria21 · ‎01-29-2020

Hi Misbah, Below is the latest script I made. It is just flashing for a moment and disappear. @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html set AnaplanUser="joseph.sherwin@scanomi.com:Jsd@deloria20" set WorkspaceId="8a81b09d56620c0301566b60d0cc496f" set ModelId="49D024CFA14B44BDBA976B4BB00B3ACA" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set ExportName="Sample Export" set DumpName="C:\Users\User\Desktop\Anaplan Connect\Anaplan Connect 4.3\anaplan-connect\Dump.txt" set Chunksize=1 set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -process %Sample Export% -execute -file %INV01 Inventory Ordering - Beginning Inventory.csv% -get %C:\Users\User\Desktop\Anaplan Connect\Anaplan Connect 4.3\anaplan-connect\Sample.csv% -output %C:\Users\User\Desktop\Anaplan Connect\Anaplan Connect 4.3\anaplan-connect\Dump.txt% 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% %Operation% @echo %Command% cmd /c %Command% pause Are we suppose to use " " on set operation or %.? Regards,

Jsdeloria21 · ‎01-29-2020

Hi Misbah, I entered the get command in the line. Did I do it right? Or I have some space issues? @echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html set AnaplanUser="" set WorkspaceId="" set ModelId="" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set ExportName="Sample Export" set DumpName="C:\Users\User\Desktop\Anaplan Connect\Anaplan Connect 4.3\anaplan-connect\Dump.txt" set Chunksize=1 set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %8a81b09d56620c0301566b60d0cc496f%49D024CFA14B44BDBA976B4BB00B3ACA% -chunksize %Chunksize% -export %Sample Export% -execute -get &C:\Users\User\Desktop\Anaplan Connect\Anaplan Connect 4.3\anaplan-connect\Sample.csv& -output %C:\Users\User\Desktop\Anaplan Connect\Anaplan Connect 4.3\anaplan-connect\Dump.txt% 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% %Operation% @echo %Command% cmd /c %Command% pause Regards,

Jsdeloria21 · ‎01-28-2020

Hi Guys, I am using Anaplan 4.3 and I am planning to do an export process I was able to run the import process successfully but I cannot seem to run the export process successfully. I tried to copy the contents on the Anaplan Connect Document but it is different from the sample script in 4.3 folder. Anaplan Document from Wikipedia: Sample Anaplan Script from the folder: My Script which does not work: Sample export is the Process Name I used. My apologies for removing the Model ID and Workspace ID. Hope you can help. Regards,

Jsdeloria21 · ‎01-23-2020

Hi Misbah, With regards to your question 422 can have 3 or more in the Gencon List but they won't have the 2 Fully Paid status. They can have 2 Cancelled status and 1 Fully Paid status. Once the status is Fully Paid 422 will no longer be available in their system as per our client. I think I found a way to manipulate the source data to push to inventory. I will try to do it directly in the source during initial import. Appreciate the feedback and your time on this. Regards,

Jsdeloria21 · ‎01-23-2020

Hi Misbah, The difference between Gencon List and Inventory List is that Gencon List is all of their transactional data. For example the 422 code, this code can have multiple transaction from different client. Their Inventory List is the same as the Gencon List except in this list they only filter the codes with with Fully Paid status and Codes with no duplicate whether and tagged it as Unsold. This was the challenge from the beginning because the data that they have is not clean. Regards,

Jsdeloria21 · ‎01-22-2020

Hi Misbah, Appreciate the help on this. I have one question on this, in the transaction ID line item the value present there came from the Code column in the General List? In my case I have a Code from the csv file to load in the Gencon List but since there are items with similar code it rejects it during import and only load the unique ones. Also I created the Count column and Find out Valid Transaction ID column in your example and I got a blank result. Regards,

Jsdeloria21 · ‎01-21-2020

Hi All, This issue is related from yesterday but with a different approach. We created a Gencon Module (transaction Data of client) and the Inventory Module (data from Gencon without the duplicates). Gencon List has duplicate RU text (Transaction Code) which will be imported to Inventory List eliminating the duplicates and only capturing the RU text with Fully Paid status. Codes with no duplicate and Cancelled status in Gencon will be tagged as Unsold. Below is the sample of the Gencon module. To forward this GenCon List and create an Inventory List the process we use is import action to eliminate the duplicates. Below is the expected result after the import process. Currently below is my result. As you can see the Status column got the wrong result on Transaction ID 422 and also the value for floor area duplicated. Is there a way for me to capture the Status column for Fully Paid only and also to get the floor area without adding the other items on the GenCon List. Appreciate the help in advance. Regards,

Jsdeloria21 · ‎01-21-2020

Hi Adris, Appreciate your feedback. I did flag the item from the source to determine which of the code has a status of Fully Paid. The result of the target module should return the status of the unique transaction code with only Fully Paid status and Transaction code that is unique whether it is cancelled. Regards,

Jsdeloria21 · ‎01-21-2020

Hi All, I have an issue that I may need some help with. Below is the sample table: Gencon Module (Source) - GenCon List Inventory Module (Target) - Inventory List Gencon Module is the transactional data of the client. In the Gencon Module it is normal to see multiple transaction code with different Start Date, End date and Status. Inventory Module is the filtered version of the Gencon Module. Only the Transaction ID with Fully Paid status and those transaction ID without duplicates and End Date will be displayed as Unsold. The Inventory Table above is the expected result. The Table below is the current result that we got: we tried using If else condition but we have an error level dimension mismatch. Appreciate the help. Regards,

Jsdeloria21 · ‎01-06-2020

Hi Community, I would like to ask this issue. I have never encountered this before so I hope you can provide me some insight. For example: This is the view of the file I am going to Import ini Excel mode(just a sample). I do the usual Save as "CSV format". I open the CSV format and everything is fine. I proceeded in importing it to Anaplan and this is what I got: I only have 1 column present. I tried to recreate the file over and over again and I still got the same issue. Is this an issue in Anaplan or Excel. I just finish loading the other csv files that I have and there seem to be no problem just this one. Appreciate the help. Regards,

Jsdeloria21 · ‎12-16-2019

Hi, I just want to correct the previous screenshot. Please see below Regards,

Jsdeloria21 · ‎12-16-2019

Hi Misbah, Appreciate that you take time in providing me some insights on my issue. I created a code so I can link it to the Target Module. Here is the scenario, the Source Module has the Source Mod List (transnational with duplicate entries) and the Target Module has a filtered version of the Source Mod List but without duplication. See below. So the issue I have right now is that the code that I use in the Source Mod List does not accept duplication there I cannot capture all RU TEXT(Code) to link it to the Target Module. I also provided the formula that I just replace it with a different name since I cannot use the original list due to confidentiality. Feel free to correct my formulas. Regards,

Jsdeloria21 · ‎12-15-2019

Hi, Please see details on the attachment. Regards,

Jsdeloria21 · ‎12-11-2019

Hi, I would like to ask something with regards to count with time dimension. The details are in the attachment. My apologies, i had to recreate the file since I was informed that I cannot post actual screenshot of data from client. Please see attachment for details. Regards,

Jsdeloria21 · ‎11-19-2019

HI Arun, Understood, will try to change the formula. Is there a reason why it is moving on Mar 20. Regards,

Jsdeloria21 · ‎11-19-2019

Hi Arun, Please see attachment. It includes the previous inquiry. Regards,

Jsdeloria21 · ‎11-18-2019

Hi Misbah, Please see attachment. Regards,