Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem to questioning CUBE when you move it between servers. Expand / Collapse
Author
Message
Posted Sunday, December 22, 2013 8:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 7:08 AM
Points: 4, Visits: 20

Hello everyone ,
I am having a problem in the transition between given source cube questioning about USER and ADMIN , and my backup cube to which I refer clients while that I make the process of the original cube .
In switching between user settings ( impersonate ) to ADMIN I can not make multiple choice questioning of the cube .
However on another server I can retrieve data and perform multiple selection at the level of sub-category .
Cube has been copied from the server where I could drill it to the server has problems making multiple selection mode impersonate .
The difference between the servers is mainly at the level of the update , this is where a problem is the level of update 10.50.4000.0 (SP2 ) . And a server without a problem level of the update is 10.50.2789.0 .
Servers are 2008R2 servers .
I think this involves different authorizations at the grand,
Does anyone have a different direction or idea what to do,
To allow my clients to continue working at the same level of questioning without restrictions .
Post #1525360
Posted Monday, December 23, 2013 7:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 7:08 AM
Points: 4, Visits: 20

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.
Post #1525544
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse