-
How to delete "filter" drop down selections - case: driver -> filter/driver -> filter
I have three drop downs: Division (driver), Area (filter/driver), Type (filter). At first Division is supposed to be selected. Area drop down list members are defined according to Division selection. And Type drop down list members are filtered according to Area selection. Now: 1) If I change Division → Area and Type drop…
-
Custom Date Format while exporting
Anaplanners Currently I have a grid at a day wise granularity. While exporting the grid the day is shown as follows: 1) As row header [here time is pivoted at a rows] - format comes as '1-Apr-2024' 2) When i bring it as a line item [with formula- ITEM(Time)] format comes as '4/1/2024' I would like to get a custom format of…
-
Months as Line Items
Background I need to design a UX view for our finance team that shows the entire year Jan-Dec, with past months showing actuals and future months showing forecast. I already have sales actuals and sales forecasts sitting in modules that I can reference, but to get the other pieces required I need to bring in and store the…
-
Model is Busy (Running exports while people are trying to use the model)
Hello, wondering if it's possible to somehow use a model when someone else is running a heavy export action. We currently have exports scheduled at night but sometimes we need to run them during the day. However, when this happens anyone using that said model is locked out basically because the model is busy. The exports…
-
Snapshot Challenge with #list
My scenario today, Integration runs everyday and clear the below numbered list with data. Since the build has been done without the code i'm struggling to create the code with unique combination. My objective is : I want to copy the current data before the delete process will execute. and compare it against the data that…
-
How to populate current year and last/previous years' months booleans
I have boolean type 'Current Year Month?' and 'Last Year Month?' line items. To how populate them easiest way without huge amount "support rows". Attached pic. (in the pic the green ones. Now they are manually fed)
-
Summaries of properties within numbered lists
Hi, We have a numbered list for sites , and within this numbered list, we have a property of regions). Regions sit above sites (E.g., Manchester consists of Site A, Site B, Site C). We want to be able to see this from a region basis. I was wondering if there is a standardised approach to getting this summarization? Thanks…
-
automatically include quarters and months when adding a new fiscal year
Hi everyone, I'm working with Anaplan and have encountered an issue with my setup. I've created a list with a parent-child relationship: Fiscal Year > Quarter > Month. However, I'm having trouble ensuring that each year contains the same information for months and quarters. When I add a new year, I can't parent the months…
-
Can I add in Cloudworks a Delete Process using Selection?
Hello, I want to do the dete function automaticly with Cloudworks. Can I do it with slelection? if Not, what options do I have? thanks
-
Summary Reporting
We currently have our model set up in the hierarchy ‘Shop > Customer > Products for volume planning. Currently, users can see their total volumes on a ‘Shop basis, with them being able to go down to see volume on a customer and material level under the shop. How would we go about creating customer summary reports, where…
-
Formula to return a certain email address
Hello, I have a list with several emails address. I want to have a formula to return only emails adress from the company Test (so that ends in @test.com). I avoid hard coding as not best practice. I have already my formula that can retrive only the "@test.com" part. To resume, I just want a formula to excude everything…
-
Makelink Length Constraint
Hi, I'm trying to link through from Anaplan to a Power BI report which has pre filters applied based on Anaplan context, so that the user goes directly to the correct view. There are a number of Power BI filters baked into the URL that I've added in and as such the URL is over 60 characters. When I then do makelink("Click…
-
Bulk changing a main list
Hi. We want to update #customer list to include customer numbers, for example: Current #Customer London Manchester Birmingham Required #Customer London (1000) Manchester (1200) Birmingham (1400) How is this done, and will this have impact on history? Thanks
-
In Number list name should not be mapped, I have not mapped even though giving Error. PFA
-
I NEED HELP ASAP
Hello, I am creating a model " Production" from the revision tags of model " DEV" . my question is how to import the production data (lists and models ) easily without passing by export data from Dev model in CSV file and create an import action to load this data and pass the revision tags to the Production model ? Can…
-
First Occurence Boolean
Hello Everyone, I was wondering about the use of first occurence. I have a line Item called IsfirstOccurenceAlerte and i want to retrieve the first boolean that was ticked in my boolean above called "Alerte Stock". The dimension is PP7 here so i thought i would be using isfirstoccurence but it seems not to work? The idea…
-
Clear Filer
Hello Community I have a list of BU's which is selective access enabled For example: If user have access to only 2 BU's Is there any possibility to clear data related all BU's Is Possible How it is done? Thankyou in Advance
-
Sort in page with two dimensions in rows
Hello, I have a module with this configuration in a page: Columns: Line Items Rows: Products, Markets I need to sort from highest to lowest my line item "Sales" but the icon to sort is greyed out. I figured this is because I have two dimensions in Rows. Is there a workaround to sort with this configuration ? Product comes…
-
Sorting - List Members
Is there a certain trick or a set of procedure to handling sorting list members. I can control the first creation of list and import the record in sorting order but how does future addition to the list should be done so that they are always alphabetically sorted. I notice that after the first load, newly added members gets…
-
Filter by table
Hello, I hope you're all doing well. I'm seeking guidance on implementing a filtering mechanism for a table on a UX page. I have a table containing multiple parameters. My objective is to enable filtering such that whenever I modify a parameter in the first table, all subsequent tables are filtered based on the selected…