Persist SSAS 2008 R2 OLAP Roles For Project Server 2010 RRS feed

  • Question

  • Is there a way to persists the custom OLAP roles in SSAS 2008 R2 for Project Server 2010? I found the Codeplex solution for Project Server 2007 at Is there a similar solution for Project Server 2010?

    I'm using an account for Sharepoint 2010 Secure Store which is not a user in PWA. That account is part of an AD group say EPMReportAuthors which has been added to a custom OLAP Role say EPMBIReports for Excel Services report to work. My excel services reports work fine when I add the AD group to OLAP role. But after the next nightly cube build process, the AD groups are removed from the EPMBIReports  role. That causes dc refresh error when launching my excel services reports.

    The default OLAP role ProjectServerViewOlapDataRole has all the PWA users added to it as normal.

    Wednesday, June 29, 2011 3:51 PM