Before beginning, document the current install by making screen shots of the Server Manager screens into WordPad.
For the ABAP SP retrieve the .SAR file from the SAP Marketplace
NOTE: ABAP BPC Support Packages are NOT cumulative, so download all the SPs between your current version and the latest. Continue reading “Installing BPC 10 NW Support Packages”
Remember our blog post where we learned how to create a site template? Have you found out that you couldn’t do it, or maybe you are trying to locate and use the Content Editor Web Part only to discover it wasn’t there? A SharePoint site setting needs to be adjusted and I’m happy to report that we have a solution for you!
Smile 🙂 and read on…
Continue reading “Content Editor Web Part Missing”
So your boss approaches you and says, “That SharePoint site you created for our dept., is great! Can you duplicate the site for all our depts.”? At that point you hit the palm of your hand on your forehead and say to yourself, “now if I could only remember how I did all that, and I wish I would have taken notes”.
Take a deep breath and read on… Continue reading “Creating a Site Template”
We recently ran into a situation where a client needed to change the filter in an Excel report that is using the CUBEVALUE and CUBEMEMBER functions. The report was built using a pivot table going against a cube. We then used Convert to Formulas so we could control the report format. This approach worked great for the current data, but lacked a simple way to update the report every month by selecting a new period from a drop down. After some struggles and some seemingly dead ends, we had enough information to solve the problem. Continue reading “Dynamic Excel CUBEVALUE and CUBEMEMBER Functions”
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”
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”