https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70285#M15213 This may or may not be the correct forum section for this, but I've read an interesting article in the past about tracking usage using certain log files as source data, then analyzing using whatever SAS component suites the mood. Wed, 09 Sep 2009 17:35:03 GMT StephenOverton 2009-09-09T17:35:03Z https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70282#M15210 I'm trying to refresh data for a cube but someone continues to have the cube locked for editing.<BR /> <BR /> Anybody know how I can 1) figure out who has it locked and 2) disconnect them so I can refresh the cube? I'm on a linux OS.<BR /> <BR /> Thanks! Wed, 09 Sep 2009 13:01:04 GMT https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70282#M15210 StephenOverton 2009-09-09T13:01:04Z https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70283#M15211 Check with your linux admin; you can't do it using SAS tools. Wed, 09 Sep 2009 17:22:55 GMT https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70283#M15211 Doc_Duke 2009-09-09T17:22:55Z https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70284#M15212 What if I could see who the last person was to read this cube using the metadata? Wed, 09 Sep 2009 17:29:03 GMT https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70284#M15212 StephenOverton 2009-09-09T17:29:03Z https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70285#M15213 This may or may not be the correct forum section for this, but I've read an interesting article in the past about tracking usage using certain log files as source data, then analyzing using whatever SAS component suites the mood. Wed, 09 Sep 2009 17:35:03 GMT https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70285#M15213 StephenOverton 2009-09-09T17:35:03Z https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70286#M15214 Hi!<BR /> Here is how we do it:<BR /> - Uses two OLAP Schemas<BR /> - The cubes metadata exists in both OLAP Schemas.<BR /> - Only one cube exists physically except when the cube is updating<BR /> - Always update the cube in the none default OLAP Schema<BR /> - Swap/change the updated cube into the default OLAP Schema with the current<BR /> - Remove the cube physical in the none default OLAP Schema Thu, 10 Sep 2009 11:44:19 GMT https://communities.sas.com/t5/SAS-Programming/Refreshing-Data-Locked-by-Another-User/m-p/70286#M15214 FredrikE 2009-09-10T11:44:19Z