-
how to display totals on higher levels when a selector is used on lower level
Hello, I have built a dashboard that gives the user the ability to select which items they want to include on the lowest level of the items hierarchy (C6). I then use the selector module to fitler a reporting module, which works great when it is shown down to the lowest C6 level, but if I try to take that same module that…
-
Enhance ALM to pick and choose objects to sync with production
Description of the enhancement required: Enhance ALM to pick and choose objects to sync with production An example of the enhancement: Currently, we are not able to move only few selected changes from development to production. The model sync will move all changes as on a revision tag. Requesting development team to…
-
L3 Model Building Sprint 2 - User Story 3.3
サンプル画像のJanell Wetzelのデータと比較をするが、どうしても少しずれてしまう。 ① SYS01 Time Settings by Monthで、月ごとの年に対する割合を算出した。 ② ①をYearValueを使用したTargetと計算し、月ごとのTargetを算出した。 ③ 月ごとのTargetにNet Commission %を使用し、算出したが計算が合わない。 考えられる原因としては １.Days in Monthが間違っている ２.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…
-
Unlocking High-Efficiency Data Uploads in Anaplan: A Multithreading Approach
In cloud-based business planning, the ability to swiftly and effectively upload large datasets is an important aspect of maintaining up-to-date planning. This post introduces the concept of multithreading to enhance data upload speeds to Anaplan significantly. This approach, however, is specifically tailored for data…
-
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
-
User role landing pages in UX - Available!
What a gift for a Friday…! Click into here and then you set which page a user role sees when they open up the App. Effectively it's the other way around to how it is in classic.
-
Capture username/timestamp for change to Line Items
Hi all If there is a module where user makes changes to data for a line item, what is the best way to capture the Last Modified Date and Last Modified By information for that Line Item? We can always ask the user to enter their name and date separate line items when they modify anything, but is there a way to automate…
-
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…
-
Function for Contribution
There is no simple way to calculate contributions all children levels to the highest parent level - for product levels, time levels and location levels. The lowest level should be considered the value to express as a contribution of a level you need to select. Examples: Week 1 to 4 belongs to Month 1, which belongs to Year…
-
User Experience / Login Page / Home Page / Launch Page / Landing Page
Hi All, I'm not sure what you would call this but, I would like to know if I can make it so when someone loads into Anaplan, that is a user, if they could be directed straight to a UX page? I'm not sure if I am explaining it well but for example, they login into Anaplan and they are straight on the UX as a landing page. Is…
-
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…
-
Add last login time & UserID (hex value) to Visiting Accounts
At present I am only able to see Last Login Time and UserID for 'Internal Users' but not 'Visiting Users' in Administration. While you can dig into the auditing logs this is very cumbersome. Would like to see this information on the Administration Dashboard pages for Visitor Accounts just like you can Internal Users.
-
Role specific landing page in NUX
Hi, In NUX, is it possible to assign a landing page specific to role. So when the end user log-in - they will directly start in that specific page? Br Bjorn
-
Option to customise or remove automated email to new users added to a workspace
When I add a user to a workspace, an email is automatically generated. 1/ The current content is not suitable - we need the ability to customise it so people do not contact the person who added them for instance as it may be different from the actual point of contact, and we would like to direct people to content or…
-
"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.
-
Anaplan coach’s playbook
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. Seldom has there been a time where a single model builder can solve all an enterprise’s business problems on their own. Anaplan engagements work better with more people than with just the efforts of an individual. That being said,…
-
Anaplan Connect Export stops writing after 30 minutes.
Hi, I have set up export connection to a SQL database. I have 1 connection that takes longer than 30 min to be completed. I have scheduled this one to run overnight. Each time this export is run, it seems that it's timing out exactly after 30 minutes but without a logged timeout error message. See error log (I scheduled…
-
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. :)
-
New List Report Card Type
I would like to be able to include listings as appendices to my reports of record. This would require a new card type that would display over multiple pages and retain the headers on each page, akin to the "Print Titles" option in Excel Card on Report Page Pivot Line Items List 1 Displayed as follows but with page…
-
Management Reporting - Additional Features
Following features needs to be included on the Management Reporting Page 1. Ability to freely change the font size of text, As of now it is restricted five types only (Normal, Instructions, Heading 1, Heading 2 and Heading 3) 2. Formatting the Text with a single click like the way we have in excel. 3. Ability to change the…
-
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 -
-
How to make/create subsidiary view?
Create Shipping Export Module and Create a Saved View In the Supply Chain model, create a module to export the shipping costs by location and create a saved view for export: Module Name: INV05 Shipping Export Dimensions: G3 Location list, Time (months) Category: Inventory Functional Area: Inventory Line Item Format Purpose…
-
Will lag function works for Boolean Formatted Lineitem?
Hello Community As Anapedia says, lag function can take Boolean formatted lineitem I have a scenario as below I have a module dimensioned by Numbered list and Time scale And I have 3 lineitems as below 1. Lag value - — boolean 2. Lag offset Amount ——Number 3. Output lag ——Boolean Formula for lineitem Output lag = lag(lag…
-
Show a "Used in NUX Pages" column on the New Modules View
In Anaplan Classic, in the old modules view, there is the column "Used in Dashboards" which informs of all classic dashboards using each module. This same concept is needed within the New Module View for New UX Pages, so that model builders can quickly identify all NUX Pages using a module. I know that the opposite is…
-
S3 - Anaplan Integration
All - Quick question on the S3 to Anaplan integration. Does Role ARN ? required in order to establish the connection Thanks Krishna
-
Management Reporting - remove the 300 rows on grids limit
It would be great to have the limit of 300 rows on grids removed in the Management Reporting area. Management Reporting may be used to have these fast variance & variance % comparisons but the 300 rows limit makes it unusable in many cases. The 300 rows limit is also applied when exporting to csv - it would be a good first…