Platform

Manuela_Apostol

HI, The workaround would be to make those selections dynamic. To identify where those items are referenced (you can go to general lists, select the list you want to check and look at "Reference in formulas"). Then, create a module (no dimensions) and Line items - list dimensioned - and pick up the element from the list you refer to. Therefore, instead of referencing the list item directly in the formula you lookup that specific Line Item which was created in a module. In this way, you remove every direct reference to your list elements

Manuela_Apostol · ‎10-14-2019

Thanks for sharing this! Such a clear explanation!

Manuela_Apostol · ‎09-26-2019

I think is beacuse enabling the option "Adjust Duplicate Names" you are getting to the point that you will have two names "Name1" and "Name1~(#)" mapped to the same code. Although you are using Name only, two items in a list cannot have same code. Can you share the error log perhaps? (if is not too confidential)

Manuela_Apostol · ‎07-18-2019

I really like your solution Anirudh and I don't see a disadvantage. I would add that you can, however, import line items into a module and automatise that, only that the import must be done in Blue Print (so no data will be affected but the line items)

Manuela_Apostol · ‎07-15-2019

Hi @guidopolisena, It will be possible by disabling the Toolbar Option. This I assume it should be done for each module published on the dashboard. As well, disable the import and export for each module, as well as Open Source Module. I recommend you to test this using a user profile, as with an admin profile you will still be able to see the Toolbar. See section "Toolbar options — end users" below: https://help.anaplan.com/anapedia/Content/Dashboards_and_Visualization/Work_with_Data_on_Dashboards/Dashboard_Toolbar.html

Manuela_Apostol · ‎07-12-2019

HI @usha.cherukuri , You have to turn off contents on that specific Functional Area. However, you can only turn off for new contents, so the ones you already have displayed you need to remove them manually (see attached ) Best practice is to use different functional areas for modules and for dashboards, so you could turn off contents for all modules only. I usually use capital letters for Dashboards's functional areas to distinguish from modules. Kind regards, Manuela Apostol

Manuela_Apostol · ‎06-24-2019

I am sorry to hear. When was the model removed? Did Anaplan mentioned something about a min/max time from which they can recover a model?

Manuela_Apostol · ‎06-24-2019

HI @aashca9 , As an admin you cannot restore a deleted model. You need to contact Anaplan Support. They will know what to do. However, it depends when you deleted the model. Some years ago when I bumped into this problem it used to be a 24h or 48h time since removal so they could recover it. Right now I am not sure. Best is to contact Anaplan as soon as possible and see if they can help you! Good luck!

Manuela_Apostol · ‎06-24-2019

I would like to have the possibility to Show and Hide the line items in the Blue Print as well as the column headers (Parent, Format, Applies to, etc). I would like to have this selection available while the module is open, without the possibility to save the view. This functionality will make it easier while working with modules having 30+ line items and only using few lines, sometimes located at the end of the module. As well, this can provide a better visualisation of the line items you want to work on and quickly remove information which is not relevant at the moment (Example: Show only the line item's formula, "Applies to" and the "Referenced by" column)

Manuela_Apostol · ‎06-23-2019

HI @Marble_Rock , I would not have selected FY 15 but just Jan 15. As you do not have the time dimension in your source file, my understanding is that what you have is information of a specific month. Other than that, there is no way you can get months information (an extra column) in your source file?

Manuela_Apostol · ‎06-22-2019

Please find attachment for your reference

Manuela_Apostol · ‎06-22-2019

Hi @Marble_Rock , I see that your target module has TIME as a dimension, while in your source file there is no such column as time. Therefore, I would add for the Time "Ask each time import is ran" so then you import month by month, for Products and Versions is okey (although for versions you can also add "Ask each time..." but is up to you) and Price Book is column headers (and then in the last tab you will get the option to map Unit Cost and Unit Sales Price. Good luck!

Manuela_Apostol · ‎06-22-2019

HI @Marble_Rock, That tab will show you all the Anaplan models from which your current model receives data. For example, if you import a hierarchy from Data Hub via an action, that model will appear in there. Please refer to the information here, it shows you more in depth information about when can be useful: https://help.anaplan.com/anapedia/Content/Modeling/Manage_Models/Source_Models.html Good luck! Manuela

Manuela_Apostol · ‎06-20-2019

HI @Alessio_Pagliano., This is quite an interesting topic but I have mixed feelings about it and I don't see immediately the added value of this enhancement. Is true that is not always possible to use TIME and are some challenges we face as model builders, though the workaround with creating Time Dimension List is at hand and there are not many disadvantages. I would like to know the opinion of our community guru @DavidSmith Cheers, Manuela

Manuela_Apostol · ‎06-19-2019

Happy I could help!

Manuela_Apostol · ‎06-18-2019

SUM can only be used on numeric line items, not on text, list or boolean formatted line items

Manuela_Apostol · ‎06-17-2019

Hi @Shweta, Has the answer helped you in solving your issue? If so, can we close this topic or you have more questions? Cheers, Manuela

Manuela_Apostol · ‎06-17-2019

Hi @Ruud Has any of the solution listed below helped with in solving your case?

Manuela_Apostol · ‎06-17-2019

Hi @Ruud, I have two solutions, one will be to keep the list published on the module (although, I do not recommend to publish a list directly on a dashboard) and the second to publish a system module instead. 1. In case you cannot remove the top level of Account Managers, you can create an alternative hierarchies which contains exactly the same items as Account Managers lists (!! but without Top level) and use that list instead in the property of Customers. Then, in order to find the property from the correct list you can use Finditem in a technical property, or in the system module of the list. 2. Other solution would be to use a Dependent Drop Down based on a dummy list to restrict showing the Top Level, but I am afraid will not work when you publish directly a list on the dashboard, but you can alternatively publish a system module. See example below: The System Module for Customer List format of Account Manager LI Account Managers property format Kind regards, Manuela

Manuela_Apostol · ‎06-14-2019

Hi @Ana_M , At the moment there is no equivalent in Anaplan with the NOW() function as in Excel. What you can do, however, is to set up a daily import via Anaplan Connect to have a daily update. I have seen an idea posted on the community. I also think it will be very useful, but so far there is only the workaround with Anaplan Connect (or manual daily entry). This is the thread, but it needs community support: https://community.anaplan.com/t5/Idea-Exchange/Current-Date-and-Time/idi-p/46550 Kind regards, Manuela

Manuela_Apostol · ‎06-12-2019

HI @ArunManickam , I understood, that was my understanding that you need the comparison with today's date. Sorry if I read your answer, in fact the issue is with getting the Posting date in Anaplan? The best is to make an import, then instead of using Today's date use the one imported.

Manuela_Apostol · ‎06-12-2019

Hi Arun, As a first step you need to calculate the difference between the Date of Today and Previous Posting Date. At the moment Anaplan does not have a formula integrated as Excel to retrieve Today's date (NOW()), so you need to import that everyday using Anaplan Connect or select it manually. However, for the testing purposes, you can just create a module and manually select the date of today. Then as simple using (Today-PSTNG Date) you will get 'Days since Previous'. On the same line item (in blue print), you can change the summary method to Average, and get the result you are looking for. You can chose to calculate the average as well in a separate line item (use Select: Total). Please find below a simple example I created in Anaplan based on my explanation. As well, there are other ways of calculating this, also depending of what do you want to do further with the result. If is statistics related, I recommend you to check for Statistics best practices on Anapedia. Hope it helps! Manuela

Manuela_Apostol · ‎06-10-2019

Unexpected reward! Thank you very much and compliments to everybody! Special congrats for my former colleague @alexpavel for his out of the box thinking and always clear explanations!

Manuela_Apostol · ‎06-10-2019

HI @Shweta , merit increase it does affect the salary, and as explain above, the base salary and other components. Can you give, however, more details of your case, so I can better help? Thanks

Manuela_Apostol · ‎06-07-2019

HI, Is 299 mandatory also for model builders who got their TAW certification based on their hours worked? Thank you!

Manuela_Apostol · ‎06-07-2019

I like this idea. That would indeed help! Also, would be handy to be able to see those views!

Manuela_Apostol · ‎06-07-2019

I love this idea! I had recently bumped into this problem on a Data Hub model which is updated daily

Manuela_Apostol · ‎06-07-2019

It is always good to have the conditional formatting improved. Number only formatting can be sometimes not intuitive.

Manuela_Apostol · ‎06-07-2019

Good idea. As well, a greater improvement is what @Guido.kaandorp suggests, not only local actions, but also the actions triggered by other models.

Manuela_Apostol · ‎06-07-2019

I think it will somewhat help. Before I would clean an LI I would still want to know if it's referenced in an import/export (in the model and by other models) and in filters.

Platform

Academy

Master Anaplanner

Programs

About Manuela_Apostol