About aishabhy05

aishabhy05 · ‎03-30-2022

Hi All, I want to make a boolean check after every two months. (Based on estimate and budget customized version ). How this can be achieved via formula? (It should not be static when the year changes automatically the boolean should move according to time range) Thanks

aishabhy05 · ‎03-15-2022

I found a solution, in source module i was using Subset of Custom version list. In target module i used Custom Version list. when i change the target module dimension to Subset of Custom Version List it worked!!! Thanks for your support !! @ogilkons @M.Kierepka

aishabhy05 · ‎03-15-2022

It is true only for the actual version. Has it anything to do with a summary of the source module? The summary has been set to Any for filters of actual, estimate, and budget versions. And no other filter condition has been given in the target module apart from the below condition

aishabhy05 · ‎03-15-2022

It is false for Feb 22 and JAn 22 for Estimate and budget

aishabhy05 · ‎03-15-2022

Hi All, I have 2 modules, Module 1- Dimensions - Entity, Custom Version, Time Period, Department Line Item - A,B,C Module 2- Dimensions - Custom Version Line Items as Follows: When i apply this filter in source module (module 1) , It still shows me the estimate and budget. which i wanted to hide. (Jan 22, Feb 22 for estimate and budget versions are blank by using DCA) I want to filter only Actual Jan 22 and Febb 22. Not sure whats going wrong here, can help on this please? Thanks

aishabhy05 · ‎03-14-2022

Thanks!!! This Works

aishabhy05 · ‎03-13-2022

Hi All. I'm facing an issue in solving the Opening Base Calculation. Please help to resolve it!!! Custom Versions - Actual, Estimate,Budget Time Period (in Months) Country List Department List GL Accounts In the below screenshot, closing base is the sum of Opening Base,Gross Activation and Churn Rate. When i try to calculate the opening base ( first month of the calendar year will be input following months will be previous month data to be copied (which includes custom versions)) it s throwing me circular reference error. However i try to create staging module, I'm not able to achieve the desired result as per the below screenshot. Thanks in Advance !! Aish

aishabhy05 · ‎03-11-2022

Hi All, I have a scenario where i wanted to hide the blank cells. (Blank cells - switchover versions using DCA). As Per my below screenshot,i want to hide JAN 22, FEB 22 , OCT 22, NOV 22 AND DEC 22. Thanks, Aish

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

@ChrisAHeathcote 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