I have dimensions with custom security on them in my cubes. Every night the security definition gets corrupted and thus won't let my clients view the cubes.
A little background. The server is backed up using Veritas 9.1 every night starting at 8 p.m. and lasts until 10:00 p.m. At 11:05 p.m. every night, we perform an IIS reset. Every Sunday evening we re-boot the machine. We are utilizing the access db repository.
Each morning I check the access and find that the custom definition for the secuity is missing.
I would agree that we should migrate the repository to SQL because we are a SQL shop.
My questions are:
1. Is the select or deselect method of assigning custom security more stable?
2. Has anyone across this issue and how did you resolve it?