About aishabhy05

aishabhy05 · ‎08-13-2021

@rob_marshall I tried the same filter, this is not working in UX Filter. If I select Result then Version is customised version ( Not anaplan Standard version) Thanks, Aish

aishabhy05 · ‎08-12-2021

@rob_marshall the filter module was by time(year) dimension and version and with display (boolean ) line item. The filter applies for only one version, however, I tried changing the summary methods yet it didn't work.

aishabhy05 · ‎08-12-2021

Hi Team, I have a scenario where I want to apply a filter on time (page selector) based on the Version which is also a page selector. I tried creating a time filter module and applied filter but it is not working. Example: If I select Forecast Version then the time page selector should show me FY21, FY22, FY23 If I select Budget Version then the time page selector should display FY 20 If I select Actual Version then the time page Selector should display FY19, FY20 Thanks, Aish

aishabhy05 · ‎07-26-2021

@Javvaji45 If i use saved view then will it not be fixed if I move on to next year? I want it to be dynamice, not as fixed view.

aishabhy05 · ‎07-26-2021

@ChrisHeathcote If I use pivot view by having version first how will I get for Result Version Apr 18, Apr 19 Budget Version, 20 Apr Forecast Version in sequence? The year should be in Sequence for the same month. I tried another view by time followed by version. Still not able to achieve. Any leads, please? Thanks, Aish

aishabhy05 · ‎07-26-2021

How to get Apr 20(Actuals), Apr 21 (Budget) , Apr 21(Actual) using the filter in the same sequence? actual and budget are versions.

aishabhy05 · ‎07-25-2021

Hello All, I would like to create a reporting module as follows (in the screenshot). Is it possible to have a view like the screenshot attached? Please note I have versions in the model and timescale as well. Versions: Actual, Forecast, Budget 20 Actual, 21 Budget, 21 Actual this should be in sequence as per the report. Would like to get a thought process/idea on the same. Appreciate your response. Thanks, Aish

aishabhy05 · ‎07-13-2021

@JaredDolich awesome!! This helps. Thanks 🙂

aishabhy05 · ‎07-09-2021

Dear All, I have a scenario as follows : I have a Module with SKU, Company as dimensions. Sales Volume is an input. List Items in Company are GST, TMB, BCC. Now, I want the data in line items to be copied to the company as follows: The output module should contain the input value as well as the copied data value. Thanks, Aish

aishabhy05 · ‎06-27-2021

Awesome!! This Works. Thanks

aishabhy05 · ‎06-26-2021

Hello All, I'm trying to solve the below logic but unable to; need your help on the same; The below module applies to the list SKU. and maps to the company which is applicable based on the boolean. I have input data sales price by SKU and by month and by all the company Now, I would like to get the sales price by SKU by month and by company Example: SKU Code 123 belongs to the company DFA and FGA. Hence the Sales Price 33681 should be divided between these 2 companies for Apr 20. SKU Code 789 belongs to only company DFA and sales price 34183 should be allocated only to Dec 20 SKU Code 356 belong to 3 company and sales price 32870 should be allocated to 3 companies (32870/3) for Dec 20. Output module applies to SKU,Month, Company list Any thoughts on how to solve this? Best Regards, Aish

aishabhy05 · ‎04-27-2021

Hi All, I have a scenario, as follows: Module 1 : To get Headcount in this module Dimensions: L6 hierarchy, L6 Flat List(same hierarchy as a flat list), Cost Centre Line Item: HeadCount Time by month Module 2: Dimensions: L6 Hierarchy, Grade, Contract Type Line ITem: HeadCount Time by month I wanted to get the headcount in module 1 by referring to module 2.the headcount in module 1 should be by the L6 flat list. ( Not by L6 hierarchy). Any inputs, please? Thanks

aishabhy05 · ‎02-28-2021

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 · ‎02-27-2021

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

aishabhy05 · ‎02-26-2021

@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 · ‎02-26-2021

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 · ‎02-26-2021

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?