Problem Connecting from Panorama to PowerPivot

Sunday, May 19, 2013

We installed Panorama Nova View Flash 6.2.5 and wanted to use it to connect to PowerPivot. While beginning the work, we couldn't connect to the PowerPivot files and would get an error message. My colleague Tomer Horev was in charge of SharePoint installation and also found the following solution. We understood what the problem was through the help of Panorama support. We tried to connect to the cube that's created for our PowerPivot file through the Management Studio. That meant connecting to the SSAS DB with the name of: http://servername/foldername/filename.xlsx ...

The refresh operation failed for PowerPivot on SharePoint 2010

Thursday, April 11, 2013

Yes I know. I can hardly believe it myself. I'm here again. And I'm glad to be back. So… to business! We wanted to create reports on an excel file our user was updating. We loaded the data into PowerPivot, published the Excel 2010 file into a SharePoint 2010 library and then created Panorama Flash views on top of that (and that's me making a very long story short!). The daily Excel data update worked fine until… one day it didn't. Obviously it's just a few days before a presentation to our head of department :) My colleague Tomer Horev,...

MOC 50429 SharePoint 2010 Business Intelligence

Monday, August 27, 2012

I've decided to make a post to round up all the learning days of MOC 50429 SharePoint 2010 Business Intelligence. Hope this somehow helps you reach all the data: SharePoint 2010 BI Center and Excel Services SharePoint 2010 PerformancePoint Dashboard SharePoint 2010 Designer SharePoint 2010 and BI: PowerPivot and Entity Profile Page Access and Visio Services and Spatial Data in SharePoint 2010 Reporting Services and JavaScript in SharePoint 2010   I would also like include for all us beginners videoes with basic steps on all the services you have for BI in SharePoint 2010.

Free eBooks on SQL Server, SharePoint, Office and more

Wednesday, August 8, 2012

So the price is still right - and yes, it's free! Marina my colleague from work sent me a really great link so obviously I had to share it with all of you. In his blog about Microsoft SMS&P Partner Community Blog, Mr. Eric Ligman has published a very extensive list of free Microsoft eBooks on SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more. The list is very comprehensive and I recommend you go over it and also look at the additional post he's linking to for even more eBooks...

Reporting Services and JavaScript in SharePoint 2010

Saturday, July 21, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the sixth post in a series of posts that I am making from the material of the course: Reporting Services 2008 R2 In Report Builder 3.0 we can use report parts that exist on the Report Server. In Reporting Services in Visual Studio,...

Access and Visio Services and Spatial Data in SharePoint 2010

Wednesday, June 27, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the fifth post in a series of posts that I am making from the material of the course: Access Services Making the data in access available to everybody – just like with the Excel files in Excel services.This enables us to manage the...

SharePoint 2010 and BI: PowerPivot and Entity Profile Page

Tuesday, June 19, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the fourth post in a series of posts that I am making from the material of the course:   Entity Profile Page If the entity I’m using is for instance a customer, and the table describing that customer has a long list of columns...

Free Lesson for SQL Server and SharePoint

Tuesday, June 12, 2012

Via BI/BPM - The SeeQueL, I have recently learned of a great new site I would like to share with you: MSBIAcademy. MSBIAcademy is a site created by Rob Kerr, SQL Server MVP and CTO at BlueGranite. The site currently offers lessons on: Excel, Integration Services, Data Warehouse Design, SQL Server, Mobile, SharePoint, Analysis Services (both Tabular and Multidimensional) and PowerView! Quite the impressive list. Most lessons are on the latest version of SQL Server, but guide lines given in them are true for earlier versions as well. I highly recommend you check out MSBIAcademy as in short lessons of...

SharePoint 2010 Designer

Sunday, June 3, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the third post in a series of posts that I am making from the material of the course.   Business Connectivity Services (BCS) Business Connectivity enables me to connect to an external data source. Allowing the SharePoint user to update\ delete\ insert rows to...
no comments

SharePoint 2010 PerformancePoint Dashboard

Monday, May 21, 2012

I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the second post in a series of posts that I am making from the material of the course.   PerformancePoint PerformancePoint Dashboard Designer is the place where we connect the different parts of the dashboard one to another. We build the different reports, (scorecard, filter), and...