More Lessons While I Am At It
Posted by Alan on September 25, 2008
Since I get a breather today to get caught up on things like e-mail and a couple other projects here are a couple more lessons learned that have come to mind:
- If a user is in two or security roles, the user will receive the permissions that are the MOST LIBERAL and not the most restrictive. Meaning if onje of your security roles has permission set to NONE for the members of a certain dimension and one of your security roles has permissions set to READ + WRITE for that same dimension, they receive the READ + WRITE permissions. I personally think this goes against good system security design which should err on the side of caution when a conflict arises.
- You will be amazed by the sheer number of times you will open the same form template, tweak it, save it and republish it to get it “just right”.
- You can’t get through a project without some form of MDX coding. It just ain’t gonna happen.
- You might get through a project without some VBA coding behind the sceens but don’t count on it.
- Believe it or not, you can have enough dimensions and dimension members on a form that it is too large to submit because how the data is parsed in the backend. This will stress you and the client out to the n-th degree.
I am sure there will be more along the way.