Security Considerations

Although Security is handled within the PandA model, typically by a developer/consultant, a user may encounter a login screen upon opening the model and pressing F9 to connect (see next image). In such case, the user will simply enter an assigned Username and Password.

Security within the model is, essentially, infinitely configurable for each user. This ensures that in a multi-user model only those users with security privileges can see or enter data where allowed. You may encounter this if your model is eventually set up with a more complex security schema that precisely matches your business needs.

The following screen shot—which, please note, is not from the PandA model—serves as an illustration. With the User (who has a unique Username and Password) created and the data rule(s) saved for that User, the next time he or she opens a PowerExcel Slice, only Canada data will be visible (highlighted in yellow in the image). The user would be able to “read” and possibly also “write” values in Detail intersection cells, assuming that were part of the application (e.g., a budget or forecast planning exercise). Note that all other cells show #ACCESS.