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

Panorama Necto

Monday, August 1, 2011

We're currently using Panorama Nova View 6.2 in the municipality and we had a presentation of the upcoming version - Panorama Necto. So what's new? Well, first of all - now there's just one entry point to Panorama, both for the user and the developer. So that's one entry point instead of one for the flash, java, desktop and dashboard. We're still using the desktop environment in Panorama 6.2 and we've come across more than once that things work in the desktop but for some reason don't show on the web. This should put an end to that problem. Pages...
one comment

BI Semantic Model – the new solution for SSAS and PowerPivot

Saturday, May 28, 2011

TechEd North America 2011 wrapped up last week with big news about PowerPivot and SSAS. Just in case you haven't read it already somewhere else, I'll give you a very short re-cap. In SQL Server 2005, the UDM was supposed to encapsulate the solution for modeling your project. In SQL Server 11, codename Denali, it's going to be replaced by BISM - the Business Intelligence Semantic Model. All the reporting tools in the Microsoft BI Stack will work against this model. In Denali, you will be able to use BISM both for tabular model in PowerPivot and for cubes...

PowerPivot and Panorama Nova View

Wednesday, August 11, 2010

Mr. Amir Netz, Distinguished Engineer at Microsoft, came to lecture about Self - Service BI and Panorama, along with Kobi Averbuch, VP of R&D at Panorama. These are a few of the major points in their lecture: PowerPivot IT cannot meet all demands. People will try to find a solution themselves.We need a technology to bridge the gap. How to build a PowerPivot application We start by installing the PowerPivot add - in. PowerPivot runs in - memory using the Vertipaq engine that ensures quick time response.All this is without indexing and caching. We connect to the various data sources and bring the data...

Panorama now integrates with PowerPivot and SharePoint 2010

Monday, March 15, 2010

A while ago, I saw Panorama was advertising a webcast detailing how Panorama gives a complete solution for the entire Microsoft BI platform, including PowerPivot. I have to admit, just seeing Panorama and PowerPivot in the same sentence seemed odd to me, as PowerPivot seemed like a completely full solution for its purpose. I didn't see what Panorama had to add to the equation. And so I began asking Panorama a few questions... So where does Panorama offer any added value? Well, if your organization is considering using SharePoint 2010 Enterprise Edition along with PowerPivot. If you are going to deploy...

Panorama Nova View 6 Reviewed

Wednesday, September 9, 2009

I’m very glad to say that not too long ago I got to see a demo on Panorama Nova View 6 with the rest of the BI team, enabling me to further give you detail on it.The demo covered quite a few of the major products:NovaView Analytics – which existed in previous version though it’s UI has changedNovaView Flash Analytics – which is one of the new features in this versionNovaView Smart ReportingNovaView Dashboards NovaView Executive DashboardsNovaView Universal Data Connector – which is another major new feature in this release   Looking at the new Flash Analytics, I really...
no comments

Panorama unveils Nova View 6 RC1

Friday, April 3, 2009

Well I guess this means Panorama wants a bigger piece of the pie. In a very impressive and interesting webcast which was given Tuesday, March 31st, Panorama showcased Nova View 6 RC1. So what are the promises given in the webcast and what was shown? Well for me, the biggest news was that from now on, Panorama Nova View will connect not just to cubes, but also to RDBMS – yes, a relational data source! And, you'll be able to create a dashboard which includes a report on both data sources. This however, was not demonstrated in the webcast...
3 comments

Panorama Nova View v5.5 is coming!

Friday, April 4, 2008

In a newsletter I received the other day from Panorama, I read some interesting news. Remember how I told you I was waiting for the .Net version of the Panorama Nova View? Well, I guess I really will have to wait some more... In their newsletter, Panorama promises to release Nova View version 5.5 What's new to the product? Better UI and "elements of flash components and more robust dashboarding features." A check with customer support gave me some more details, the most important of which is that the platform for the new Nova View v5.5 will still be Java. I...
one comment

Panorama partners with Google

Sunday, March 23, 2008

Well I’m waiting for the .Net version of Panorama Nova View. But I guess I can see there are more important people in line… Today I found myself reading in the news that Panorama has joined forces with Google Apps to give the Pivot Table and Pivot Chart capabilities to the Google spreadsheet. Up till now I have seen Panorama’s add – in to the Microsoft Excel, but as Microsoft has been pushing Proclarity forward, Google might well be a fresh alternative! So if you’re using Google Apps, you might very well want to read more details about the...
no comments

Discovering your MetaData

Saturday, December 29, 2007

I have recently discovered a brand tool to help me better understand my work. It's a free tool from the Microsoft SDK. Specifically, I'm talking about the Rowset Viewer. The Rowset Viewer was intended for you to "view and manipulate OLE DB rowsets, with the added ability to call and manipulate other OLE DB methods from the data source, session, command, rowset, transaction, and notification objects supported by any OLE DB provider." I found myself using the tool so as to understand what was problematic in my cube. Basically,...