If multiple users are using the same dashboard , How could be the performance?
And how to increase performance if there is large data load and multiple users are loading into same module at same time?
Hi @PujithaB
When more users are using the same model, performance is worse than the case if less users are using the same model. Then the question becomes:
1. How many total users are added to the model?
2. What's the % of users who are concurrently using the same model?
Please refer to https://community.anaplan.com/t5/Model-Concurrency-Testing/tkb-p/Customer-Performance-Testing-Database
Regarding your question of "And how to increase performance if there is large data load and multiple users are loading into same module at same time?", i would suggest looking into 2 possibilities:
1. Create a data hub. Please refer to https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866
2. Split the 2 activities, eg schedule the large data load to happen during an offpeak period, so that when your business users are online, they won't be affected by this large data load.
And as usual, please refer to the best practices in https://community.anaplan.com/t5/Best-Practices/tkb-p/communitykb to design an optimal solution.
Thanks,
LipChean
@PujithaB
As @LipChean_Soh already mentioned that more the robust design less the performance issues. Anaplan handles it quite well even if there are dozens of concurrent users on the same dashboard provided we'd followed the best practices in the model design.
On Data Load - See if you can break the load in chunks - you can take it to 30, 40 chunks etc. and make sure that the load doesn't happen during peak time.
Data Load from End users - Now this is something that is the bone of contention. Let me share my views: If there are end users who start loading their data at the same time then it might take sometime (here we are talking about 10 seconds to 20 seconds - based on the size and the number of users). If your processing time is higher than a minute or two then it might be worth to break the calculations link based on the input line item and stage/store end user driven numbers into standalone module and then pull the data for calculations later (schedule the job later during offpeak period) - this you have to take a buy in from end users that there will be a trade off between the performance and the real time
Hope that helps
Misbah
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
