Excel Writeback - Security and Leveraging the UPDATEABLE Cell Property

Most of my blog posts chronicle some lesson learned in the heat of battle at a client site. This blog post is a bit different since the lesson learned came from an Artis internal project we started and completed last year. At Artis, our time entry system feeds into an Artis data warehouse and an Analysis Services cube for reporting. We also support writeback against the cube for project managers to enter forecasts for projects. That way, at the weekly staffing meeting, it's pretty simple to see that Greg is forecasted to work 95 hours between four projects next week. At that point, preventative measures can be taken. like alerting local emergency rooms that I may be making a visit.