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.
I had trouble getting the OLEDB Provider from IBM Client Access to work. It was pulling data, but due to CCSID issues, many columns didn’t translate properly. To resolve this, I had to use a T-SQL query so I could set Force Translate=0, when adding the LinkedServer. Continue reading “Adding LinkedServer to AS400/DB2”
To get items manually approved by SAP, use the XX-SER-SAPSMP-SDM component or application when submitting a support message.
See SAP Note 1678822 for what versions of IE, Office, Windows Server, Windows Desktop, IIS, SQL Server, Citrix and .NET are supported.
I recently built a new BPC application/web server. The existing App Sets were large; in the 2 billion rows category. So doing a backup and restore would be time consuming. The backup/restore was also unnecessary because the OSoft share was not on the app server and I wasn’t bringing up a new database server. Continue reading “Recover Existing BPC MS AppSets”
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”
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:
- Open XenCenter
- Connect to your server
- Click New Storage
- Select Windows File Sharing (CIFS) and click Next
- Give the SR a name, I used NAS Storage
- The Share Name is actually the full path, so: \\nas301.service.softlayer.com\SLXXXXX-X
- Check the Use different user name checkbox and enter the user name and password for your NAS (SLXXXXX-X / MxXXXXX)
- Click Finish
A SharePoint list was filling up rapidly and had exceeded 5,000 items. Not wanting to use filtered views, the user instead wanted to archive the older items. This seemed like the perfect automation nut to to crack open with the PowerShell ISE editor. Keep reading to learn how to archive a SharePoint list. Continue reading “Archive a SharePoint List”
I have some rather complex SPD workflows built. Complex meaning multiple approval levels and multiple tasks. Recently we applied SP1 to our SharePoint Server 2010 environment as well as a recent Cumulative Update (CU). After the update 2 of the workflows began showing this error: