-
I want to appear for Level 1 model building certification
Hi, I am unable to appear for Level 1 model building certification
-
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
-
Level 3 sprint 2 - 1.3 data hub
1.3 Check Your Build As you complete the model building activities for Process 2 Assigning Accounts to Territories, User Stories 2 1 to 2 5), you do not need to manually assign the accounts to a territory. You will be provided a data file to check your model in the Check Your Build section for User Story 2 5 Hi Please…
-
Excel add-in: breaking the connection's cell range
Hi Anaplan Community, I have a question regarding the Excel add-in. I was reading about refresh conflicts on this Anapedia page. If you break a connection's cell range, it may not refresh properly. To include a cell range in a Refresh, keep the cell range together at all times, rather than break or split it. You can insert…
-
Cloud Works integration
I apologies in advance if this idea has already been posted🙂. In Cloud works if we delete any integration by mistake is there any solution or process for reverting it back again or to see what we have deleted and revert it back .
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hi All, good evening, I am doing the activity but did not get what we are asked for. First, what is a stock exception count? How to add it on an user page? And, is there any faster way to have the context selectors than sync diff charts or tables ? Thank you in advance for your help BR Arthur Robbe
-
Anaplan API to pull metadata at Module Level only
Hi all, I want to retrieve metadata from a model at the Module Level ONLY. Reason being is I have DataTags identifying which modules are Critical, Medium, or Low and would like to parse through this data. Currently utilizing this api: https://anaplan.docs.apiary.io/#RetrieveIDNamesModuleModel but only lists the model ID…
-
Initial Page based on Selective Access
When publishing a module on a dashboard you can specify an Initial Page, an item from Page Selector that will be selected once you reopen a dashboard. For reporting dashboards, I normally put it on Total level (Total Zones). If Selective access is enabled for the Zone list, and a user has access to a specific Zone, the…
-
Process Filter in Role->Action in User Access
It would be usefull if I could filter to one particular selected process can configure all actions within that process. Yet i can only search action by action and set it up slowly Also how often get one action forgotten because its just too many of them. This would be prevented if i can see the (filtered only) whole list…
-
SYS07 Distribution Center Details | Default Shipping empty
Hello everyone, I’m stuck because the column 'Default Shipping' in the Supply Chain Model is not populated after I run the import from SYS07 Location Details —> Import Distribution Center Details saved view (Data Hub Model). Can anyone help me please? Thank you
-
How to find the average of the same month for different years?
I have 5 years of data. I need to find the average of the same month for the 5 years. For example, (Jan 19+jan 20+ jan 21+ jan 22 + jan 23) /5. Similarly i need to find for feb, march, April… I used month and model calendar for the time dimension. How do i develop this in anaplan? thank you
-
Datatype mapping used for aggregation doesn't match any dimension of the source?
I am trying to pulling billings from a calc modules, the source and target modules are both dimensioned by country but I keep getting this error. Note: I am trying to pull in billings from CALC02 which is sourced from CALC01. CALC01 is pulling from a flat data module. Please advise…
-
What to do with highly sensitive data?
If a customer has highly sensitive data and really needs the most controls from an access standpoint, does Anaplan recommend…. The data lives in a model it's own workspace The data lives in a model in it's own tenant that only has the data.
-
Should version be in the unique ID when importing into a spoke?
I am looking to import these dimensions below. I am wondering what should be included in a unique ID? -Version -Time -Product -Country I think Unique ID in this case is Product and Country, but can someone confirm?
-
When exporting to other systems, is it better from Spoke or from Data Hub
I feel I get conflicting answers when I try to research this question. In the Anaplan Model Builder training, they say export from the Data Hub to other models. Likely because model to model import is less time, and this will make the spoke have less downtime. However, in forums, I see people saying either one is okay. If…
-
Creating list members
What is the best practice for users list member creation. Say…. 200 users say they need to create 15 list members…. Is it best for…. Have them fillout 1 form per member. Add 1 member in dashboard at a time with "Create List Member" action. Do upload template where users can import 15 at once.
-
Ranking of Formula Performance
Is there any 1 place that does all the rankings of formulas in terms of performance? The formulas I am trying to rank are…. Moving sum, YTD sum, cummulate, and timesum. In ranking fastest to slowest, I would guess…. YTD Sum, Moving Sum, timesum, cummulate.
-
How can I get the "Model Builder" Certificate file after succeding all the steps?
Hello, I don't know where to find my final Certificate of "Certified Model Builder" file. I already got my Level 1 & 2 Certification and I passed The Anaplan Way. (+ Foundation 101) Thanks
-
1.6.3.1 Create DAT04 Distribution Center Parameters Module
I don't find SKU flat list. What did I missed please
-
Multiple models & Comparison in a single Page
Hi there, Just wondering if we are able to link 2 or more models in a single page? If multiple models can be linked in one page, can we compare the data from different models and have the comparison in the page? Thanks! Kelly
-
Creating General list from A module's line item
I have a module called Project. It has line item called "Project name". Project name line item contains only those projects which are approved (used formula to get these) My question is can we create an general list from the Project name line item, as i have to use this list as format to one of my screen. One possible…
-
Switch from Context Selector to Boolean - Scope of view
I'm trying to optimize a module for space. At current the module alone occupies 33 GB of space. The module is a cross dimension of 4 lists as seen in the picture above. with time month granularity. The idea is to reduce the dimension count to 3 by removing one list. The 9LE List shown in the applies to above. It has two…
-
Process to refer to Module for Mapping or Bulk Process to allow user to select Source/Target
I would like the end user to be able to copy one scenario inputs into another scenario. It would be nice to be able to under manual have the ability to select a module as the mapping so long as the wording is correct. Or under the Bulk Process that you can leave it for the end user to select Source and Target. The way to…
-
'Home' button to link back to landing page/app page index
Whilst somewhat hidden in classic UX, it would be useful to have a 'home' page link clearly visible for users to jump back to either, Their role-assigned landing page (if assigned), or The app index with all the pages listed With the landing pages now available, it seems a bit clunky to have to click into multiple tabs to…
-
How can we use OAuth integration with Cloudworks and BQ
We are evaluating Cloudworks to integrate Anaplan with Google BQ. Our security team advised that they prefer OAuth-based integration. I could not find documents on how Cloudworks can use OAuth. Can Cloudworks use OAuth ? If yes, where can I get material to understand how to use Oauth with Google and Anaplan using Cloudwoks
-
Include Calculation Effort metric in Anaplan Classic
I have found this feature available in Polaris to be very valuable. So I would like to request it to be included in Anaplan Classic as well. Thought there was already an existing idea request for this but couldn't find it. When I encountered performance issues during a list item insert that was taking 90 seconds to execute…
-
Import Scripts run successfully but target module did not update as expected
Hi, We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected. It seems like it is still importing the old csv file instead of the new one. Also, we…
-
<remove>
.
-
How to traverse hierarchies: The power of loops
Introduction Whenever you use a hierarchy, there will often be times when you are required to seek specific information which will necessitate some way to traverse the nodes and map out their connections. What you seek may be a list entity, a specific value, or a unique identifier, and this can become complicated if the…
-
Sample Dashboard Screenshots for Investment and Cost Management
Hi there, I am looking for sample screenshots of Dashboard reporting for ICT Investment and Cost Management. Appreciate if you can point the links and resources. Thanks!