-
List item has nothing showing in 'Referenced in Formula', but it is referenced?
I have a list that shows no references, and i was removing ‘dead’ lists however, when i tried to delete it i got an error saying it was used in a module. And after looking i found it was indeed used So why does the reference not appear in the list information?
-
Anaplan-Power Bi Connection using Basic auth-Blank source
Hi, I am trying to connect Anaplan & Power bi, I followed steps metioned on Anaplan community, but I was not able to see data in Power Bi. In Anaplan I have created one test export action. In Power bi I have entered below url in next step, I'm using my Anaplan User name & Password associated with the models. but I'm not…
-
Additional practice models/builds
Hi Anaplan Community! I've completed the certified builder program, but am wondering whether there are any additional practice builds out there that I can attempt? e.g. I'd like to practice building an ICM/SPM model. Thanks!
-
LOOKUP not working as intended
Hi Anaplaners, I'm having an issue with IF ELSE Statement. I expect the ‘ELSE’ part to go accross opposite direction than the ‘IF’ condition. But it seems to not be working using a LOOKUP function but works with a SELECT function. I want to promote it to PROD but I can't do it with using a SELECT BUT INSTEAD A LOOKUP.…
-
Schedules Mapped by Entity Name in Anaplan
In Anaplan, I have a schedule that needs to have the name of an entity name change to the English version. I was put on notice recently, that the schedule is being mapped by the entity name. Can anyone provide guidance on how I would be able to see in Anaplan exactly how that schedule is being mapped by entity name and…
-
User Access Between Schedules and Snapshots
I have a user who has access to schedules but doesn't seem to have access to the corresponding Snapshots. A few things I have tried so far, are: 1.) Confirm their role and that they have access to the schedules 2.) Used my account as a test account to recreate the issue. When I tried to recreate the issue, I was able to…
-
SKU to Format, Flavour, etc
Hi Guys. I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3. The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore…
-
Handling Gap in Data Stream
Hi all, Due to a 2-3 weeks of gap in the data stream, I need to ignore the data for those weeks from all computations in an Anaplan model that is nearly 50GB in size. If those weeks remain as null/no data, those cells would still remain part of the computation particularly if the logic indicates Sum/#N Weeks or moving…
-
how it work for sales manager
how our platform work for a sales manager who is responsble for profit and loss account of food products marketing company
-
Sum based on Parent in Hierarchical List
Hi, I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item. How can I calculate this sum, as it is the sum of all items in L3 under L2 a…
-
Retrieving user selective access in module
Hi, I have an issue in my Workforce Planning model I can't quite get my head around. The scenario is the following: I have an organisational hierarchy with Cost Centers and then Individuals as childs. I have selective access enabled to my cost center list and only certain users have access to certain cost centers (and…
-
Getting Monthly and Quarterly totals in Weekly model
Hello all, I'm building a model with a weekly time scale. The client wants to see the Monthly and quarter totals also. Do you have any suggestions on how to get these totals? I created time filters to get a Month and also manually did a Quarter line item. But when I do a lookup, it doesn't come through.
-
Putting values in territory field from multiple quota assignment rows of an employee into one field
Hi Experts, Appreciate your brainpower on below challenge. Using below test employee as an example, we would like to have a field show “PKI, BCT” in the same row same cell, similar to concatenate or textjoin in excel. Expected result like below (using excel as demostration) Thanks a lot!
-
Is it possible to have a "Create" Action on a list with no parent?
Is it possible to have a "Create" Action on a list with no parent? If not then is there a workaround?
-
How to Auto-hide line items
I have a table which include value from Q1 FY21 to Q4 FY23 as line items, and want to hide which the value is 0. But when I use filter on line item will hide other line items like KPI Name (it is TXT format). How can I hide these line items which value is 0 and does impact other no number format line item? Thanks!
-
Display months as M1, M2 instead of Jan, Feb
Hi! My company uses a 4-4-5 work week calendar. Currently, the system shows the months has Jan, Feb…Dec. but I would like it to display as M1, M2….M12. The reason being is that our M1'23 has a date range of 12/31/22 - 1/27/23, therefore, saying Jan is misleading. Thanks for the help!
-
Can you link to a specific record on a new UX page
I have a list of projects and i have a line item that is a link to the project page, but would like to go to the specific project they are clicking on. The html for the page is the same no matter what the item, but can you add a tag to the html at all, like you can in other apps?
-
Import Sources
Hello Anaplan community, There are several notions related to import sources that I have trouble comprehending. These are : Source Labels, Source object, Source model (in Actions) and Source models. I can not understand what each term means, what is the difference between them, how should I manage the import sources in ALM…
-
Sum from a model Applies to Fiscal Year and a customized numbering list to another w numbered list
Hi Experts Appreciate your prompt help to provide a solution! We are working on Quota Management based on Territory hierarchy. In module A (Applied to Fiscal Year, Mapping List with items like PSM1, PSM2, ..PSM1600), users can assign different territories to one employee assignment (employee assignment is not the same as…
-
DCA by User´s role
Need to generate a DCA module that depends on users role. I have seen that there is no capability to extract the users role, any suggestions? br