A user can’t see Panorama view on a new cube

Friday, March 28, 2014

We had a book in Panorama NovaView which we had made about a year ago. The book had views that were all based on the same PowerPivot cube which was published to a SharePoint Server (so it was recognized as cube by the viewer). So, a year had passed and we needed to add to our book new views which would be based on a new PowerPivot cube. The data in both cubes was about workers in different units and the authorizations on the cubes were given so that every manger would see just the workers in his units....
no comments

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,...

Excel 2013: PowerPivot, Power View and migration to Office 365

Tuesday, September 18, 2012

I have recently been to the last BI User group which hosted a lecture from Mr. Dany Hoter, Senior Program Manager at Microsoft. Last time I saw Mr. Hoter speak was about Excel 2007. Yes, it's been a while. But I dare say that the fact I remember his lecture, speaks volumes on how much I enjoyed hearing him. This time around, Mr. Hoter spoke to us about Excel 2013 (how time flies...) The lecture itself was filled with demos Mr. Hoter did and showed on an Excel 2013 workbook he put at an Office 365 site, which is at...

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.

A Comparison between SQL Server 2012 BI Tools

Saturday, July 28, 2012

I have recently posted an article in Silicon India comparing SQL Server 2012 BI tools and means of development. I addressed there the tools in SQL Server 2012: SSRS, Report Builder 3.0, Power View, Tabular and Multidimensional Analysis Services.Though I tried to cover much ground in the article, I would still recommend some additional reading: A short comparison between Tabular mode vs. PowerPivot A more detailed comparison between Tabular mode vs. PowerPivot vs. Multidimensional SSAS ...

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...

Mr. Kamal Hathi on SQL Server 2012, PowerPivot, SharePoint and Azure

Monday, April 30, 2012

In a short newspaper article a friend stumbled upon, he saw that Mr. Kamal Hathi, Director of Program Management at Microsoft is coming to Israel for the Think Next Convention. It was also detailed that Mr. Hathi was responsible for the SQL Server Business Intelligence technologies. As the time of the convention drew nearer, I felt more and more interested in trying to catch him for an interview about SQL Server 2012. At the end, I had to finish my questions quickly as Mr. Hathi did not stay till the convention, but I did feel like I had quite...

OfficeWriter v8 for SSRS

Wednesday, April 4, 2012

SoftArtisans have approached me to write a review about OfficeWriter v8 integration with SSRS. Your first question would be: what's OfficeWriter? :) OfficeWriter is an application that works with Reporting Services in two ways: 1. It Allows you to design a report in Word or Excel and render it to an RDL 2. It allows you to take data from an RDL report and use it in a Word or Excel document I believe just those two point hold within them quite a lot, but we'll get to that shortly. I decided to try my hand at creating a report on Adventure Works data: I...