#ProjectServer 2013 Build OLAP Cube via #PowerShell #SP2013 #PPM #PS2013

February 18, 2014 at 1:18 pm | Posted in Administration, Configuration, Customisation, Functionality, Information, PowerShell | Leave a comment
Tags: , , , ,

One potential issue for many organisations with Project Server 2013 is that users need access to Central Admin if they want to build the OLAP Cube. Usually the PMO / PWA Admins would not have access to Central Admin, they only have access to Project Web App. If they want to build the OLAP Cube on demand, they would need to raise a request to the team that manages SharePoint Central Admin. To get around this, they can use PowerShell from the local workstation. The script can be downloaded from the script gallery below:

http://gallery.technet.microsoft.com/scriptcenter/Server-2013-build-OLAP-Cube-13a4346c

image

Once the script is downloaded, the uri will need to be updated to use the correct URL, update the http://vm753/pwa part of the URL. You will also need to update the cube GUID. You can get the cube GUID from the URL in Central Admin when you access the OLAP cube settings page. See the highlighted URL below:

image

Obviously someone with access to Central Admin will need to get the OLAP Cube GUID for you.

The users running the script will need to correct permissions in Project Server. They will need Manage Cube Build service and Mange Site Services.

Advertisements

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: