The only difference is the transition from the server to the server, basically it's the same cube of the same customer during all weekend passes to backup to another server .
So far not been a problem as well as during all started a week all customers move to the BKP cubes until we Process the new cubes and current customers.
The test was opening two windows of Visual Studio 2008 and trying to slice the data at the level of sub-category, the same cube which is server A and server B for that matter (the cube
was duplicated using a process of BKP & RESTORE and made the experience of SCRIPT CREATE) server A can perform impersonate with details using a random customer and making the slice and get the data.
Replication of the cube, case B we get the data only when we connect the cube as ADMIN, the version of the build server B is 10.50.4000.0.
It is important to note the attempt to 've run on a third server C for with characteristics identical as well as same build version ( 10.50.2789.0 ) was again possible to drill with
Multiple selection at all sub Category disorder when done impersonate .
In light of all the above tests , we assumed that there is a different permission level server settings or something that is not related to the structure and definitions cube itself
as the third server as a control we had no problem despite simulation the case accurately.
It is important to note that the customers are querying the cube through an additional server configured as PAMORAMA , when we got back we realized slowly disappearing weekly data interrogation
at customers moving into cubes backup .
Throughout all the process was not an error As if we did not make multiple selection data were presented in every case and in every server.
Inability to questioning CUBE when you move it between servers
