-
Level 2 Model Building Conclusion - DEM04 Demand Export Demand values
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? My DEM04 blueprintview: Baseline Forecast: Thanks in advance!
-
Anaplan Level 2 Conclusion - Create Demand Export Module and Create a Saved View
Can someone help me why I am getting different demand number pulled up? Instruction: My Anaplan Blueprint Mode: My data Check your Work:
-
Level 3. QUO01 Territory Account
Hello, In the QUO01 module, I am using formula below to get target number, but I get 0.00; I even tries to add LOOKUP account names but still no luck. Also, for Assing>1 I am writing this formula, but it errors out: IF 'SYS07 Territory Account Details'.Count[sum:'SYS07 Territory Account Details'.Account> 1 THEN TRUE ELSE…
-
3.4.3 Activity: Create Country Summary Module formula is wrong ?
hello I have put the formula for Safety Stock Flag Count but in the exam it says wrong when i pasted it . i dont why couple of times it got rejected ? any advice will be helpful
-
Cloudworks Data Encryption
Referring to Anaplan CloudWorks guidelines (published in May 2023) :“Your cloud sources (such as AWS S3, Azure Blob, and Google BigQuery) must be accessible via public APIs. Make sure your data is not encrypted or compressed.”“CloudWorks supports these file types: csv, csv000, xls, txt, xml, and pdf.” Is there any plan or…
-
Filtering a subset
Anaplanners, Is there a way i can filter a subset ? So, we have Projects module, where each project can be either active, inactive or done. This is a list formatted line item. However, the option to select done should be based on another line item in the module, actuals uploaded : Yes/No ? If the boolean is true only the…
-
Level 2 Sprint 3 - 3.5.4 Percentage Full
It's funny how whenever I use None for Summary settings, I do not get anything populated. See below. But whenever I used "Average" in Time Summary, I do get some numbers. Why is that?
-
Link is no longer working 3.5.5 Activity
-
Superset Choice (from Time Ranges)
Could someone please explain what's the use of this particular time lookups function?
-
Route Rejection and Approval Notes back to Line item selected users
I may be overlooking something, but I can’t find a way to route comments collected by Workflow after approving or rejecting a Decision Task back to a specific user. This limitation complicates taking action on rejections. Since Workflow mandates a comment input, it would be beneficial to have the ability to send that…
-
PLEASE HELP !! IS THIS CORRECT ACTIVITY 3.4.4 !!
For this I created 3 saved views 2 from module INV-02 I pivoted them and synced them with page , 1) I made first view using Region(row) , Safety stock line item(page), Time(column) 2)I made second view using Product family (row) Now I made 3rd view using INV-01 module 3) I made it using SKU(row) after that I applied SYS00…
-
Anaplan level 2 sprint 1 exam passed but not count
-
'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Price & 'REV02 Volume Inputs'.Volumes * 'REV
I am facing problems with both formula's. Please help me i have been stuck cant move forward if anyone could explain what the problem would be and give me solution to it.
-
Add Notes/Comments on Management Reports
Users(Stakeholders/CEO etc) must have access to add Notes/Comments on the Management Reports they view for better understanding, similar way we have in powerpoint
-
Organizing templates for data imports
Author: Vinay Varadaraj Mirajkar is a Certified Master Anaplanner and Senior Solution Architect at Anaplan. I am sure many of us have seen the below message many times in our experience, and at times it may be very time consuming to retrieve the file which was used to create the import action. And there are also chances…
-
Alternatives to Rank in Polaris engine
Hi Community members, I am looking for some alternatives to assign sequential ordering in Polaris model as the default "Rank" function is unavailable there. Thank you!
-
Average of previous year and current year
Hello community, I need to calculate average of previous year end (e.g FY23) and current year end (e.g. FY24). Logic should be FY24 + FY23 / 2. How can I return these vales from a line item which has both FY23 and FY24 numbers. Any ideas much appreciated. Thanks Kal
-
3.2.11.1 Create Planning Period Filters
Confused on which Line Item I'm building a formula for, I'm assuming both. Also this is the formula I used to so that the weeks in that month are selected as well when you select the month are as follows. Please advise. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter), Kind of confused why would not want…
-
Lock Lookup. Possible?
Hi everyone is there any possibility to lock the lookup function when using offset? what i want to achieve is when i change my time period, the awarded will take the current period in module Construction Forecast-Awarded and will be place in Awarded column. same thing in Awarded 2nd Month, it will display the second month.…
-
What is the maximum number of dimensions (aka list) per each Anaplan module ?
-
Display next 2 period (month)
Hi everyone. I'm not quite sure if i'm using the correct formula in displaying the next 2 month period. if I selected Oct 24 in time dimension, the result would be display is Dec 24 in my column. is used this formula NEXT(NEXT(ITEM(Time))) which is running and no error. Just to make sure if i'm using the correct formula.
-
1.5.8.1 Create Saved View for DAT03 Module
This is my Module with no filter added My data disappears when I apply a filter and set the time summary to none. This is the formula I'm using I don't know what I'm doing wrong
-
Level 3. Account Review UX page
Hello, I created a saved view from the actual module and created a UX page for Account Review. In the Module "Country" and "Segment" are subsidiary. I can't figure out how can I use them as a page selector in UX page. Please advise. Thanks,
-
Level 3. Sum the stretch goal% in FY
Hello, Can you please help me to find a way to have 1% in FY. If I select "Sum" in Summary section it will add up the percentages to 4%. I would like to see 1% in FY total also. Thanks,
-
3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs
Hi all, I'm having difficulties with the Shipping Cost line item. I am getting an error on the formula below…Can someone kindly point me in the right direction Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: Shipping Methods]
-
3.3.5.4 Update INV01 Inventory Ordering to Allow Override of Order Amount
Is this the correct formula? If not, please help.
-
Selected Time from another module
Hi everyone. is it possible to get the selected time from module 1 to module2 as line item.? thank you.
-
Potential Typo in 3.3.5.2D Remaining Line Items
I thought it should be "less" instead of "plus" Thoughts?
-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
-
Source Model and moving model between workspaces
Hi All, In one of my workspaces (Workspace1), I have two models HubModel1 and HubModel2 where some of the lists in HubModel2 are created based off saved views in HubModel1 (meaning the imports in HubModel2 are pointing to HubModel1. Say, I want to move the models to a different workspace (Workspace2). Looking for options.…