About aishabhy05

aishabhy05

Hi All, Is there any limitation of numbers that have to be assigned to a process? Ideally how many actions a process can run via Anaplan? Thanks, Aish

aishabhy05

@JaredDolich But still the same error. Any inputs please?

aishabhy05

@ben_speight , @Misbah I have to reupload the source file with "Set as Default" to everyone to avoid the error? Is my understanding correct?

aishabhy05

Hi All, I have a process named "Import From Data lake SP SG FOM" where lots of actions were placed. For instance, My actions in the following order . Today date.csv and import stock Expiry DC-9205,9209,9207 are to be uploaded files. When I publish the process in the dashboard and click to upload the files, the upload sequence got jumbled as follows What should be the upload sequence to be followed for anaplan connect import? However, i tried uploading the sequence as follows via anaplan connect. I got the following error. What could be the cause of error? any suggestions please? _2021-02-26 17:35:07 INFO [c.a.client.Service :83 ] 1532 |-- > Initializing Service..._ > _2021-02-26 17:35:07 INFO [a.BasicAuthenticator:26 ] 1532 |-- > Authenticating via Basic..._ > _2021-02-26 17:35:11 INFO [c.a.c.l.LogUtils :44 ] 1532 |-- = = > = = = = = = = = = = = = = = = = = = = = = = = = = = = =_ > _2021-02-26 17:35:11 INFO [c.a.c.TaskFactory :118 ] 1532 |-- > Running Process: Import From Datalake SP SG FOM (id=118000000058)_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :207 ] 1532 |-- Run > status: Failed._ > _2021-02-26 17:35:14 INFO [c.a.c.l.LogUtils :56 ] 1532 |-- > -----------------------------------------_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :230 ] 1532 |-- !!! > The operation failed !!! =(_ > _2021-02-26 17:35:14 INFO [c.a.c.l.LogUtils :60 ] 1532 |-- - - > - - - - - - - - - - - - - - - - - - -_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :3880 ] 1532 |-- The > uploaded file is no longer available; please upload the file again_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :3880 ] 1532 |-- The > uploaded file is no longer available; please upload the file again_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :3880 ] 1532 |-- > errorMessage - The uploaded file is no longer available; please upload > the file again_ > _2021-02-26 17:35:15 DEBUG [c.a.client.Program :1726 ] 1552 |-- Thanks, Aish

aishabhy05

Hi All, I have an issue while uploading the file via Anaplan connect. Following is a snippet of the error. > > _2021-02-26 17:35:07 INFO [c.a.client.Service :83 ] 1532 |-- > Initializing Service..._ > _2021-02-26 17:35:07 INFO [a.BasicAuthenticator:26 ] 1532 |-- > Authenticating via Basic..._ > _2021-02-26 17:35:11 INFO [c.a.c.l.LogUtils :44 ] 1532 |-- = = > = = = = = = = = = = = = = = = = = = = = = = = = = = = =_ > _2021-02-26 17:35:11 INFO [c.a.c.TaskFactory :118 ] 1532 |-- > Running Process: Import From Datalake SP SG FOM (id=118000000058)_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :207 ] 1532 |-- Run > status: Failed._ > _2021-02-26 17:35:14 INFO [c.a.c.l.LogUtils :56 ] 1532 |-- > -----------------------------------------_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :230 ] 1532 |-- !!! > The operation failed !!! =(_ > _2021-02-26 17:35:14 INFO [c.a.c.l.LogUtils :60 ] 1532 |-- - - > - - - - - - - - - - - - - - - - - - -_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :3880 ] 1532 |-- The > uploaded file is no longer available; please upload the file again_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :3880 ] 1532 |-- The > uploaded file is no longer available; please upload the file again_ > _2021-02-26 17:35:14 INFO [c.a.client.Task :3880 ] 1532 |-- > errorMessage - The uploaded file is no longer available; please upload > the file again_ > _2021-02-26 17:35:15 DEBUG [c.a.client.Program :1726 ] 1552 |-- However, the file is available in the storage location. Any suggestions? Please note that source label names are matching. While I was configuring the import action, I made as Keep private. Will this impact? If yes, any possible ways i can change back to admin? Thanks, Aish

aishabhy05 · ‎07-12-2020

Thanks @nathan this helps.

aishabhy05 · ‎07-09-2020

@Misbah you are mentioning to convert to native timescale and use the previous function?

aishabhy05 · ‎07-09-2020

@Ani , this works to get the previous week, but I would like to get the calculated line item previous weeks data

aishabhy05 · ‎07-08-2020

Hi All, Any suggestion for using the previous formula in a custom time scale? Scenario: Using Previous of same line item in Custom Timescale Module : Products as Dimension, Current Week and Future Weeks (Custom Timescale) Line Items : Planned Order Purchased Order Final Forecast Inv Projection Inv Projection line item logic should be- If current week then Planned Order + Purchase order - Final Forecast if not current week then Previous(Inv Projection)+ Planned Order + Purchase order - Final Forecast Thanks & Best Regards, Aish

aishabhy05 · ‎07-01-2020

Thanks @rob_marshall . This is in line with my thought as well. I tried another method, not sure the following method is efficient Steps: Input module Past Data in Custom Time Step 2: Calculating Avg for Current Period Step 3: Rolling the calculated forecast to future periods. Using Subset every week it moves when the data will be uploaded. Calculated the Avg Sales Twice, not sure whether this method is efficient. I suspect calculating Avg twice may affect the performance. Welcoming Suggestions. Thanks

aishabhy05 · ‎06-30-2020

Thanks @jasonblinn for your swift response. The average is running, but I have an issue from next week/day the current week Average should be Considered. The above formula works well for moving average. But for forecasting the sales data Clients requesting the last 90 days average and for forecasting days it should include the Current Day Average. Any workaround for this, please?

aishabhy05 · ‎06-30-2020

Good Day!! I have a scenario where I'm trying to calculate the moving average from actuals in Custom Day time scale. In a module, I have sales data to be uploaded, from the sales data I have to calculate the moving avg of 90 days at the day level. Dimension in the module Article, Custom Day scale. Line Item -Sales Qty, Sales Value. I tried using the formula - Line item 1- CUMULATE(Sales Qty, FALSE, Custom Day)) / 90 Line Item 2- 'Line Item 1' - 'Line Item 1'[LOOKUP: Custom Day.'Current Day-90'] The Above formula gives average but not moving average. Any suggestions, please? Thanks.

aishabhy05 · ‎06-30-2020

@jasonblinn In case if I would need to get moving average then the lookup is working for Particular Week. Example : I tried using lookup Current Period -1 but somewhere I'm lost. Can you help with this? Thanks.

aishabhy05 · ‎06-24-2020

Thanks for your swift response. Will try out.

aishabhy05 · ‎06-24-2020

Hi All, My model Calendar is 4-4-5. So Dec 30-12-2019 is falling on Jan Month. I want to get Jan month 31 days, Feb - 29( and Feb 2021-28 days), march -31 days,apr -30 days..and so on. The Model calendar follows 4-4-5 Total number of months is not giving the right answer.

aishabhy05 · ‎06-22-2020

This works! Thanks

aishabhy05 · ‎06-22-2020

Hi All, I have a module with customised timescale. In Module A, dimensioned 24 Week Custom Timescale. In Module B with no dimension, I would like to get Sum of 12 Weeks from Module A. Any leads, please? Thanks.

aishabhy05 · ‎06-18-2020

@sharmagh Are you using customised weekly timescale? If you are using standard timescale you can cross-check that the logics or calculations are not using select: current time period?

aishabhy05 · ‎06-18-2020

Thanks @jasonblinn . Gave me a good insight into the thought process (about performance) and will try to figure out the solution with the inputs shared.

aishabhy05 · ‎06-17-2020

Hi, I have a scenario where I have to take a snapshot every week(forecast periods) -max 6 weeks forecast period. Source Module -Standard Time Scale, Article List, LineItem(which I want to take a snapshot) Target Module- Standard Time Scale, Weekly snapshot LIST(Contains list member of Lag 1, Lag 2, Lag3..6), Article List, LineItem(Where the snaps will be stored) Every week when I run the Action to capture the current week data it has to be in lag 1 always. Lag 1 data should be moving. Instance, this week when I'm running the action to copy the data to fixed list member of lag 1. I want the previous week data to be moved to other lags. Current Week - Lag 0 (Fixed) Previous Week- Lag1 A week before Data-Lag2 I want help on how to move the data from one lag to other lag (Lag is a list member).

aishabhy05 · ‎12-04-2019

Will this work for two numbered list without code?

About aishabhy05

Number of Actions assigned to Process

Re: Anaplan Connect Error

Re: Anaplan Connect Error

Jumbled Process

Anaplan Connect Error

Re: Previous of Same Line Item in Customized Time ...

Re: Previous of Same Line Item in Customized Time ...

Re: Previous of Same Line Item in Customized Time ...

Previous of Same Line Item in Customized Time Scal...

Re: Moving Average in Custom Timescale

Re: Moving Average in Custom Timescale

Moving Average in Custom Timescale

Re: Customised Time Scale

Re: Custom Time Scale - Calendar Month Mapping

Custom Time Scale - Calendar Month Mapping

Re: Customised Time Scale

Customised Time Scale

Re: Current period data gets deleted when i change...

Re: Snapshot

Snapshot

Re: FINDITEM on Numbered List Without Code

Re: Current period data gets deleted when i change...

Re: Anaplan Connect Error

Jumbled Process

Re: Snapshot

Re: Anaplan Connect Error

Jumbled Process

Re: Snapshot

Re: Anaplan Connect Error

Jumbled Process

Re: Snapshot

Re: Previous of Same Line Item in Customized Time ...

Re: Previous of Same Line Item in Customized Time ...

Re: Moving Average in Custom Timescale

Re: Moving Average in Custom Timescale

Re: How to get the average of the last 3 month fro...