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

cube accessing speed issue Expand / Collapse
Author
Message
Posted Sunday, July 7, 2013 1:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:16 AM
Points: 106, Visits: 469
This is a weird thing I am facing in my project. Just a brief below...

We have an SSAS server and there are 2 users. User A and User b accessing it with same privileges.

User A is accessing a cube of ssas database. the cube has an hierarchy. when user A access the cube and expand the levels of hierarchy (lets say level 4 to 5)it takes 20 mins for cube to expand.

Now, when user b access same cube with similar privileges then it takes 1 minute to expand same level.

Note: both users are accessing cube via. Ms excel 2010 without any extra add ins

Interesting facts:

1. When User A access the cube from another machine then he is able to access the cubes in same time as that of user B.

2. When user A sends the excel file to user B via email and when user B open and access the cube using user A's excel file then even user B face slowness of level expansion.

Note: both user have same access permissions on ssas server and cubes.

when after opening the user A's excel file with ssas server connection user B change the connection properties by opening the properties section under data tab in excel, user b gives his own loging id and connect and then the excel file of user A works fine for user B.

What can be the issue !.?
Post #1470985
Posted Monday, July 8, 2013 6:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:26 AM
Points: 243, Visits: 2,732
Have you checked the connection strings? Are users A and B members of the same role?
Post #1471139
Posted Monday, July 8, 2013 11:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:16 AM
Points: 106, Visits: 469
Yes, both have same roles.
Post #1471444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse