About Manuela_Apostol

Manuela_Apostol

That is a very good short term solution given the circumstances! Thank you!!

Manuela_Apostol

All the best in the new position! You will be missed! Thank you very much for all the knowledge and advice you have shared! So happy to hear that Planual V2 is going to be released!

Manuela_Apostol

Thank you ! It is definetely a good time to re-start the discussion of ALM functionality !

Manuela_Apostol

Thank you @usman.zia for your help. See bellow my answers: How many different data areas / logs does the data hub contain - for example how many unique files / sources - could these be split into their own data hubs? ---> There are two main data sources - History and daily (which contains transactional data) and few other very small loads for set up lists' structure At any one point does all the data need to be in the datahub? - could time ranges be used and copies of the datahub be archived? -> yes, for now we I need the 2 years of history plus on going months Does the client have a database / data lake? - then it could be possible to run uploads of the required data to the datahub? -> yes Does your data validation create an exception report (all the changes) which is then refreshed in the orginal data source? -> no, data validation only for data sent to spoke models

Manuela_Apostol

Hi @agni_gold., Welcome to Anaplan world. Best is to start on the learning platform with Level 1 and Level 2. What I also like a lot is the Anaplan Essentials course, which walk you through the Anaplan capabilities, how hyperblock works, connected planning concept, etc. So you can take Level 1 and Essentials together, then follow by a more advance model building course with Level 2!

Manuela_Apostol

and can you attach the error messages you get with the new mapping? I don't think the weeks is the problem

Manuela_Apostol

HI @Sravan_Kumar , You have to map Time to columns 3 weeks (and apply the match item indicated in a post above) and Column Headers to Data03

Manuela_Apostol

Thank you so much for your reply @Jared Dolich . The article and PLANUAL are amazing and went through many times. I've been also doing a lot of improvements and work with the client to deliver data in the best format. So steps have been already taken, however, still need more space. Regarding ALM, this is only available for Enterprise clients, so not an option. The biggest challenge is the amount of data needed. We are loading transactional data, every month containing about 4-5 millions of transaction some months even 12million and each transaction brings about 30-35 fields which are needed. Business is growing so we expect to even more next year 🙂

Manuela_Apostol

Thank you David! Sometimes I forget how easy is to use substract and add with time. Sometimes we also need to go outside of the defined time period and include those time ranges in our calculation. In this case, what would you recommend to do?

Manuela_Apostol

Hi @Stan, The community looks great once with those new releases and I am looking forward to the next ones. I don't know if this happens to any other users but I thought I would let you know. Every time I am opening a new page or even add a comment on community I am logged out and need to log in again. Happy holidays!

Manuela_Apostol

hi @sudhakarp , Have you found meanwhile what the error was ?

Manuela_Apostol

What are best practices when is needed to create a new Data Hub due to workspace space limitation to 130GB? I have already built the Data Hub which contains historic data and data validation processes. I still need to load further years. The only option I have, without deleting the data already loaded is to create a new Data Hub model on a different workspace and feed the models from both DHs. I am aware of best practices, why Anaplan should not be a DW, but besides this, I am sure there are clients which are using multiple Data Hub due to space limitation of one workspace and I would like to know the challanges and best practices on setting this up. Thank you!

Manuela_Apostol · ‎10-17-2019

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?