To access the Project server 2007 OLAP cube from Non-Domain workgroup environment:

Issue description:

      The Cube building creates a default Role ProjectServerViewOlapDataRole that automatically adds all the Project Server users to this Role. But during the standard Cube Building process in Project Server 2007, any manually added OLAP Roles in an OLAP database will be deleted.

Please follow the steps below to access the cube from non-domain environment and persisting the manaully added roles with the cube.

To access the Project server 2007 OLAP cube from Non-Domain workgroup environment:

·         Create a local user account in the Analysis server

·         Create a role in the OLAP cube along with “ProjectServerViewOlapDataRole”

·         Add the local users with that Role

·         Create the account on the workgroup computer with the same name and same password.

·         Login though that account on the computer to access the OLAP cube

To add the roles through a schedule job, please follow the steps below.

Workaround:

1.       Open Analysis server, expand database, expand Roles

2.       Add a new role and add the users manually

3.       Click on "Script" drop down in the Edit Role window

Select “Script Action to New Query Window”

Copy that XMLA script

4.       Create a job under SQL Server Agent

5.       In that job select “SQL Server Analysis services command” as step type.

6.       Paste the XMLA script in to the command portion

7.       Schedule the job to run after the OLAP cube completion, So that the role will be added after the OLAP cube created.

Please find the link below to schedule the job in SQL server 2005.

Backup Strategies with SQL Server 2005 Analysis Services:

https://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx

 

Disclaimer: All messages posted to this blog are provided "AS IS" with no warranties, and confer no rights. Use of any script or code samples is subject to the terms specified in the Terms of Use.