About Manuela_Apostol

Manuela_Apostol · ‎02-12-2020

I also come across the same point, and more as a request from the client. Although, validation messages are turned on and technically we will prevent the action to create new elements based on filters, still, will be more visual if the action button will be turning from grey to blue once conditions are met. A great improvement which I support! Good idea @deepakammanna

Manuela_Apostol · ‎02-10-2020

In this case, you will need to create a module to save your data (it still can contain versions if you need to) but your data must be stored on a different list. If you want to have the employee detail you then need to create an alternative dummy list of employees that are not being cleared. Or, you store on a more aggregated levels

Manuela_Apostol · ‎02-10-2020

Hi @gaetan_ed, There are some ways, depending on the way the model is built. Read/Write to versions: from Settings - Version to set edit to and from to None, as well as from the User access -> Roles - Versions set to either None or just Read. This you can use it in combination with formula scope explained below: Formula Scope: In the Blue Prints of the modules which are using Versions, you can set up the Formula scope to only affect some specific versions. So your formulas will apply to some specific versions only and the rest of versions will not be calc (there are few options: All except Actual, Current version only, etc). So, let's say your formula scope is set to "Current Version" then the calculation will apply only to the current version and the rest will not change (data will look like input). Use the settings above to give only read access to rest of the versions, so your data will only be changed for the current one with either read or no read possibility for the rest. Manuela Apostol

Manuela_Apostol · ‎01-03-2020

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

Manuela_Apostol · ‎01-02-2020

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 · ‎01-02-2020

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

Manuela_Apostol · ‎01-02-2020

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 · ‎12-30-2019

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 · ‎12-30-2019

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

Manuela_Apostol · ‎12-30-2019

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 · ‎12-28-2019

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 · ‎12-28-2019

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 · ‎12-28-2019

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 · ‎12-28-2019

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

Manuela_Apostol · ‎12-28-2019

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!