Hi @neg177 Simplest approach here is to change the pivot of the data feeding the chart to show versions as rows and line items as context selectors. From your screenshot it looks like versions are set as context selectors. Swapping them with line items should give you what you want. Good luck
... View more
Make sure they are not try to create the report in My Pages. It is not possible to create a report page in My Pages as it must be done in the app.
... View more
To use a filter you need to add a dimension to a systems module and then allow the user to select which items to use via a boolean which can then be used to feed into a filter function. The straightforward way of doing this when filtering line items is to create a line item subset and use this as the dimension in the filter module. However, line item subsets can only be created for number formatted line items. Therefore, the best way to achieve what you are looking for is to use a list to collect the data rather than line items. Then use this list in a filter module to allow a user to filter the view. Also, be mindful that you will need to include the user list in the module that feeds into filter so that the outcome is user dependent. Good Luck!
... View more
Hi All, On a number of occasions when reviewing subsidiary views I have found that I am not able to return to the default view. Despite, selecting 'default view' from the tool bar I am forwarded back into the blueprint. The only remedy I have found that gets me back to the default view when this occurs is to close the module down and reopen it. There doesnt appear to be any discernible pattern or logic to why this occurs but I would simply like to know if there are any tips to avoid it happening in the future as its just annoying. Thanks, Chris
... View more
@UshaPriya Did you copy the formula from the training materials? Do not do this as the formula relies on the use of correct spelling as per your model. Instead, write the formula out from start to finish referencing line items directly by clicking on them as you construct the formula.
... View more
@jimfeng5 To account the change in the number of weeks in a year use a time systems module to count the number of weeks. Add a new line item formatted by year and use parent(item(time)) to return the year for each month. Then finally add a third line item called number of months formatted as number. Reference the first line item and use LOOKUP to reference the full year value so that you return the number of weeks in the year for each week of the year. Use this in your LAG or OFFSET function.
... View more
@EmmelineM You are able to make changes as I suspect you have not changed your role in user settings and you are still set up as having full access. Change your role to Regional Sales Exec and check that the selective access is operating as expected. Remember to allocate yourself a sales region too.
... View more
@abhi12K The system module SYS00 Time Settings by Month should contain a boolean which indicates the time periods (months) which fall within the planning period. You are required to use this line item to populate a boolean in SYS01 Time Settings by Week module to indicate which time periods ( this time weeks ) which fall within the same planning period. As there is an inherent parent child relationship between month and week it is possible to use a function to tell Anaplan which value to retrieve from SYS00. Review Anapedia to determine which function will do this for you. The difference between the two is that the first requires the parent of week (month ) to also be populated while the second only requires the time periods (weeks) to be populated. This is a matter of using different summary settings which can be changed within the blueprint of the module.
... View more
@tylerstimpson Check the summary settings as they are not set correctly. The screenshot suggests they are set to SUM. Summing a ratio up a hierarchy will not generate the correct outcome as they need to be recalculated at each level to provide the correct ratio at that level. Therefore, use Formula summary settings which will tell Anaplan to use the inherent line item formula to derive the ratio at each level of the hierarchy.
... View more
@rstewar5 think logically about what you are trying to build. The SKU is a combination list containing two items; product and distribution centre. One of these is the parent.
... View more
Hi, I am little late to the party regarding the new modelling environment. However, I have started to use it and the experience seems to be very posititve. However, I have been unable to directly reference lists from general lists when requiring them in a formula. I am finding that when trying to reference a list directly in function such as FINDITEM when I try and pull the list name in by clicking on the list in general lists they are not populating in the formula box. Is this a know issue or do I need to do it differently. Cheers,
... View more
@kmillet Check how you have defined the decimal separator and thousand separator in the import. If your source data has changed how these are defined you will need to make sure that you can use a more consistent source.
... View more
@julioarrastia Bear in mind that Anaplan uses lists to define relationships. Therefore, if you are trying to map data from one list to another you will need to use list formatted line items as you bridge between dimensions. When importing the role data it may need to be updated or changed in the employee system module before it can be used in a formula to reference data. Good luck.
... View more
@zoecassell Check the tabs in the import definition to ensure that the columns in the source are mapped to the correct line items in the target. They may need to be manually assigned to the correct line items. Always check the mappings in these tabs before running the import.
... View more
@mahendra7 Check that you have not added a new filter to the line items tab. If so, this is incorrect. Click on the minus sign, " - " to delete it. You should then be able to proceed.
... View more
@CamdenMaggos Create a phasing module dimensioned by employee and department. Allocate the % slip across employees and department and use this to adjust your final costs.
... View more
@hannaaberg Check the settings in the import to ensure that you are recognising the decimal and thousand separators correctly. I suspect the current settings are recognising dot as the thousand separator and comma as the decimal separator. Be mindful of the formatting of the source data when importing.
... View more
@sp40684 Are the summary settings set to SUM? Also, make sure the Department and Role line items in the Employee systems module are populated and correctly formatted as the relevant list
... View more
If you do not want to use switchover you can simply delete the time period in version settings. Alternatively, you can disable switchover at the line item level in the blueprint of the module.
... View more
