-
Level 2 Sprint 3 3.3.6
Hi, I'm having difficulties in the Shipping Cost and Final Shipping Cost line items. The formula I used for both: Shipping Cost: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Final Shipping Cost:…
-
Importing is not updating correctly
Hi all, I can't figure out why my importing is not updating correctly. the mapping is correct but when i cheek it, the ligne item is not updated. pic attached for more details.
-
Use formula to integrate data at multiple levels of list hierarchy
Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarchy - Total, Fund, and Series - and I want to integrate this data into a unified report as shown below: I need to write a…
-
why is the summary not showing even when its enabled...
i have to refer sum in another module but it shows 0 since the sum is not showing here
-
Formula - limiting values returned
Looking to limit the values returned within a module, which I've made a start on the module showing in the right hand side , where limiting by currency. However, if I then also wanted to limit by say GL Category or GL code, how would I go about this? Any help would be welcomed on this
-
Can I use Lookup Formula in this case ?
Hello all, I'm currently working with a model that provides weekly forecasts for all products. My goal is to obtain forecasts categorized by product type (S or W) instead. However, when I attempt to use a lookup, I encounter this error message : "Format of mapping used for lookup doesn't match any dimension of the source".…
-
Integration Question
Can I know if the Anaplan Bulk API connector for integration is being used, will it send the log report (like we do in manual upload)? I need to know will the user receive the notification of success/fail (error log report) from SAP - > Anaplan. Not from the history I wanted to check because it is a daily process running…
-
Which Tool Is Easy To Handle Complex Data?
Any advice for the below query will be highly appreciated. Would it be easy for someone to learn Anaplan if they have a Salesforce marketing cloud certification with the given skills set? If not, in how much time he can learn the basics of Anaplan? Recently, one of my friends was assigned a task to work on complex data,…
-
Lookup Error message
Hello all, I'm currently working with a model that provides weekly forecasts for all products. My goal is to obtain forecasts categorized by product type (S or W) instead. However, when I attempt to use a lookup, I encounter this error message : "Format of mapping used for lookup doesn't match any dimension of the source".…
-
How to apply logic where we can cumulate the values of list items without time?
Hello Everyone, Can you please help me out in applying a logic where we can cumulate the individual List item. Example: if a person is having 5 sales that he does sale 1 has some revenue, sale 2 has some revenue same as for Sales 3,4,5. In our desired line item: sale 2 value should be the cumulative Revenue of Sale 1 and…
-
NO Time dimesin module to Time dimension module
HI I want bring the data from non time to time module. as mentioned screen shot
-
Restore archived model of a deleted workspace
Hello, It is possible to restore an archived model included into a deleted workspace. Thank you in advance for your answer! Regards
-
Can I have a code in a list mapped to different parent between two time periods?
I wonder if someone have come across of this use case: Our reporting hierarchy is based on Cost Centres i.e. Cost Centres are mapped to Business Units (Parent/Child relationship). There was a request to move a Cost Centre between two Business Units in July going forward, meaning that history remains unchanged. When I…
-
model search
Is this search feature buggy? I don’t think it is working as is. For example see below: I search for ‘calc’ I only want results with calc in it Below also gives results with references that contain c AND a AND l AND c This is not correct. The search is limited here. The Boolean logic behind the search does not seem…
-
Process Ignores one of the Action in it
We have one automated process which has five actions in it which clears the list and reload the new items in the hierarchy. When the automated process runs it ignores the last action which reloads the list. Upon checking we found that the Server has the necessary access to run the action and also the source system(i.e.…
-
SYS08 Product Family issue in Level 2 Sprint 2/3
In rebuilding for the 2nd time due model loss, I am having an issue with getting the products to be assigned to their product family so I can get the correct values in SYS08 SKU Details and then use it in DEM03 Demand Forecast. Images are what is in SYS08 and the Blueprint of it. Where am I going wrong, it has become a…
-
Is it better to use CODE(ITEM( SKU List)) or to use SYS SKUDetails.code?
Hello, I need to concatenate two codes because I am generating a combined list. My first instinct was to utilize the function (CODE(ITEM()), but the example I saw in ANAPEDIA used the the systems module Line item [SYS SKUDetails.code]. Given that I don't even have a system module, I'm unsure if doing it this way is a bad…
-
Sequence of list elements creation during imports
Hi, As part of a requirement, I am looking to gather more information on the order in which the list elements are created. Consider my source as If I want to use the above view as a source and create list elements , 'A', 'B', 'C' and 'D'. Can there be any possibility that instead of creating them in the order , Anaplan…
-
List Item Change
Hi Guys, I have a change in the list item in Anaplan, the list is marked as a non prod list, I have to check the references for the SVs direct update in Filter, is there a quick way to do it? Though I have checked for the list references. Thanks, Anmol Sarna
-
Period Function is not giving the desire output.
Hi Anaplaners , I am using the PERIOD function to populate the month from the date-formatted line item. In my case, it worked fine till FY26, but it is not returning anything after December 31, FY26. My hunch is how Period works with model calendars?