-
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…
-
Looking for AppHub users to participate in a user research study
Anaplan's User Experience Research team is looking for model builders with experience using the App Hub to participate in an upcoming research study. In this study, you will discuss your experiences with App Hub and Partner Based Solutions. This study will take place between February 7th and February 11th, and the sessions…
-
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…
-
Why do filters break when pivoting a view?
Hi, Why does pivoting a view cause filters to break? This has been a major pain point for our users- is it possible there is a good work around? Thank you.
-
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…
-
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
-
Best Possible solution - Master data changes
Hi, I would like discover best possible solution. The integration happening from SAP to Anaplan (daily basis). The issue is that whenever there is a change in the master data , it is impacting the final #s of budget / actuals / forecast which is obvious. How do you overcome this scenario? Like budget needs to be locked…
-
Are there ways to hide certain line items when end user click drill to transaction?
Hi, I have a query related to drill to transaction. any input will be helpful. I have classic end user dashboard which has information related to employee. Dashboard only contains certain line items from module. but,when end user click on drill to transaction, it went to module and display all line item. I wonder is it…
-
Ability for business user to override a calculated line item
I am having a requirement, where we are having a line item being displayed on dashboard, and it is being autofilled using a formula which is pulling data from another list. Business wants to have the ability where they can edit that value for a particular record. is this possible?
-
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
-
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…
-
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…
-
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…
-
3.3.12 Activity: Create Product Replenishment UX Page
Hello, I am trying to create the UX Page and trying to apply the conditional formatting but, I the conditional formatting is not working on it. So, can anyone pls suggest why it is not working? Regards, Viral Patil
-
How to create an Error action to stop the process
How to create a simply Error action to stop the process, Such as use a False/True filter, I want to stop the process when other user execute the process in the same time… Thanks
-
L3 Model Building Sprint 2 - User Story 3.3
サンプル画像のJanell Wetzelのデータと比較をするが、どうしても少しずれてしまう。 ① SYS01 Time Settings by Monthで、月ごとの年に対する割合を算出した。 ② ①をYearValueを使用したTargetと計算し、月ごとのTargetを算出した。 ③ 月ごとのTargetにNet Commission %を使用し、算出したが計算が合わない。 考えられる原因としては 1.Days in Monthが間違っている 2.Net Commission %が間違っている だと考えているが皆様の意見を伺いたい。
-
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…
-
I NEED HELP ASAP
Hello, I am creating a new model "production" from the revision tag of "dev". The steps i followed : 1- create a model from a revion ( done) 2- doployed the production ( done ) 3- import data from Data Hub ( done ) 4- import data from dev to Production via a revision tag ( failed , the action run correctly but the data…
-
Too many cells for ISFIRSTOCCURRENCE calculation
I Import a C11 list to 2 spoke models from Hub. I use the same DataHub and Same Hub Saved view to import into this list. However the import into list is sucessful for one of the spoke model but not the other. The saved view and the import definition is the same for both the spoke model. For one the process is completed…
-
Quarter to month
Hello ^^ How can I convert a line item formatted in quarters (e.g., Q4 FY23) to a line item formatted in months, displaying the last month of each quarter Q4 FY23 =⇒ Dec Q1 FY23 =⇒ Mar etc Thank you
-
Quarter to Text?
Hello Community, How can i go from the line item Quarter ( Quarter ) to Quarter ( Text ) example : Q3 (Quarter format) to Q3 (Text format) Thank you
-
how to copy a lIne item from a module to another one ( Text format )
Hello, I hope you're doing well. I'm facing a challenge and could use some assistance. I have three line item text formats in a system module, and I need to retrieve the information in text format from the same line item with the same name from another module. Here's what I've tried: I went to the target module and simply…
-
Compare two lines items from different modules
Hello This is my problem. I have a line item A in one module dimensioned by "Depense" list. And I have the line item B in another module dimensioned by "Achat" list. I want to compare if A = B then the item of the list Achat become the parent of the item of the list Depense. I cannot pull any finditem. Is there a way to do…
-
Percentage Format issue on UX page
Description: I have a module with PV(dimension) Filters as dimension and I am displaying the Value line item on UX which is same as the Module dimension. But the Value line item is getting the data from other line item Actual vs Scenario 1 % which has ss_Actual vs Scenario 1% (dimension) - Which is a subset of PV filters…
-
"Invalid name" error
Hi all When I try to import into a list I receive the error "invalid name". Do you know where I can find the explanation of this error? Thank you. Pic attached.
-
Write a DCA logic to prevent entry from another User if the selected row reserved by another user.
For eg. In the above screenshot if I check reserve row Boolean then the entire column of that row should get lock for other user and only editable for the person who reserved it. Also i want to see the name of the user for whom that line is reserved for.
-
Copy of list item
Hi, I would like to ask if there is a workaround for this: If I copy List Item 1, the copy should have a "-1" in its list name automatically. The list is a numbered list. TIA. :)
-
Import Failure
Actual- Mine- Any help here? Edited- After selecting department as sales, still '82' are Ignored Additional info Supply chain - FP&A model, level-1 -