December 22, 2013 at 7:43 am
Hey everyone.
I am having a very strange situation.
No Data when doing multiple selection cube.
The thing is that the situation is created only in the transition between the servers, who have a different Build but both of them are SQL 2008R2 servers.
The Build of one of them is 10.50.2789.0 and the other one is 10.50.4000.0 (SP2).
The other properties of the cube are the same, it's Not possible to retrieve data from the cube on the server with the "SP2 when we the slicing is at the level of sub-brand and removed even one item mean we passed a multiple selection ,
This is possible only if we connect the cube as Admin .
While the server with the older "Build" the problem to perform the above operation when connected as a user not exist.
What can cause this problem,and how can we fix it?
thank's a lot.
December 23, 2013 at 6:49 am
A copy of your query may help. Is it possible the that tuple does not exist.
December 23, 2013 at 7:44 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply