If you try to generate a SAS^® Profitability Management cube within the SAS Profitability Management client you might receive the error:

   ERROR: File is already locked by another user.
   ERROR: The physical cube cannot be deleted.

The first thing to check is whether the cube is currently being viewed by a user. If a user is actively viewing the cube in SAS Web OLAP Viewer, select ‘Log Off ’ from the SAS Web OLAP Viewer page and then try to build the cube again. In most cases, you should now be able to successfully generate the cube.

However, there may be times when you select ‘Log Off’ and are still unable to generate a cube. Such a case exists if a saved SAS Web Report Studio report is available for viewing in the SAS Portal. For example, if the saved <BabyBank_byRegion.srx> report is available at the SAS Portal, the report is actively being viewed in SAS Web Report Viewer, and you return to the Portal page and select Log Off, you still will not be able to generate a cube. Even if you close your browser, the same error as shown above will be reported if you try to generate the BabyBank summary report cube from which the byRegion report is based.

In this case, you can release the lock by following these steps:

1. Log on to SAS Management Console.
2. Expand Monitoring plug-in ► SAS OLAP Server Monitor ► SASMain – Logical OLAP Server.
3. Select Actions ► Connect and provide credentials for the sasadm user in the ‘Log on to SASMain – Logical OLAP Server’ dialog.
4. In the navigation window, under SASMain – Logical OLAP Server, you will see users who are connected to OLAP cube(s). Select the user connected to the OLAP cube that you are trying to generate a new cube from. When the correct user is selected, you will see a cube name referenced in the display window under the MDX string column heading. For example, if you are trying to generate the ByRegion cube for the BabyBank model, then you will see the string [BabyBank_ByRegion] under the MDX string column.
5. With the user name selected from step 4, select Actions ► Close session. Please note, performing this step will end the OLAP viewing session. If this session is not yours, please check with the user before closing it.

You should now be able to successfully generate a SAS Profitability Management cube.

Operating System and Release Information