SharePoint, PowerPivot, Power View and Multidimensional Analysis Services

This article was written to help me sort out SharePoint, PowerPivot, Power View and Analysis Services. Read on to discover the questions that arose as I embraced this technology set and the answers I’ve uncovered.

So what are the options for working with Power View within SharePoint with MDX as the source cube? Let me frame this a bit, I am referring to SharePoint 2013 and SQL Server 2012 SP 1 or SQL Server 2014. It appears that PowerPivot becomes the data source for Power View reports. That is, a PowerPivot workbook saved within a Document Library. So it seems feasible that building a PowerPivot report pulling from an MDX cube, then stored in a Doc Library should work. The first test is the Document Library, PowerPivot and MDX cube test. If this works the same way as using a tabular cube, then we are one step closer to a complete solution.

Continue reading “SharePoint, PowerPivot, Power View and Multidimensional Analysis Services”

SharePoint Workflow Versioning with Visual Studio 2012

I needed a methodology for publishing new versions of SharePoint workflows using Visual Studio. I have a Document Library that has a workflow (we’ll call it version 1). The document, 9-30 Staff Meeting.pdf, is running workflow version 1; waiting on a user to complete a task. However, I’ve changed the code and want new documents to run the workflow with the changes (we’ll call this workflow version 2). Here is the key, while the new document, 10-7 Staff Meeting.pdf,  will run workflow version 2, I need the the already in progress, 9-30 Staff Meeting.pdfdocument, to complete using the existing version 1 assembly. Continue reading “SharePoint Workflow Versioning with Visual Studio 2012”

NW Security for BPC Users

When using NetWeaver security (not AD or CMS) for BPC, the user must have these roles set using the SU01 transaction in order to access BPC:

  1. /POA/BUI_FLEX_CLIENT
  2. /POA/BUI_UM_USER
  3. /POA/CLM_BPC_USER
  4. SAP_BPC_BTCH_JOB
  5. SAP_BPC_CLM_EXPORT
  6. SAP_BPC_CLM_IMPORT
  7. SAP_BPC_SYSADMIN

Setting a XenServer ISO Library Using NAS

Using XenCenter

  1. Open XenCenter
  2. Connect to your server
  3. Click New Storage
  4. Select Windows File Sharing (CIFS) and click Next
  5. Give the SR a name, I used NAS Storage
  6. The Share Name is actually the full path, so: \\nas301.service.softlayer.com\SLXXXXX-X
  7. Check the Use different user name checkbox and enter the user name and password for your NAS (SLXXXXX-X / MxXXXXX)AttachNAS
  8. Click Finish

Continue reading “Setting a XenServer ISO Library Using NAS”