Browse by Tags
All Tags »
SSAS (
RSS)
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...
Microsoft recently released a CTP of Power View on SSAS Multidimensional , (and yes, I know I'm a bit late writing about this, but I still wanted to give my two cents on it). So we're edging closer towards the point where Power View and Excel will be able to cover all of your viewer needs (or at least most of them :)). Years ago when I wrote about Report Builder on a cube and all the problems that that relationship created, I wondered when that would be fixed. Now that we have Power View...
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
This is a summary of a lecture given in the last BI User Group meeting in Israel by Mr. Itay Braun : SSAS will give you better performance on top of a DWH of a few Terras (2+) rather than Tabular mode. That's because of the data summary and compression SSAS does to the data. Tabular is not necessarily faster than MOLAP. Tabular mode is a new DB engine with 2 possible modes of interaction: 1. Tabular Mode - Column store - In memory - Compression (~1:3) - All the data copied 2. Direct SQL - Queries...
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...
I had a new measure to add to my cube a new measure. My fact table up till now was with a monthly granularity. I assumed that I would have to define a scope in MDX for the intermediate period and the monthly period. I connected the fact to the year level in the Period dimension and got this message: If you select a non – key granularity attribute, the server will not be able to aggregate data properly unless you make sure that all other attributes are directly or indirectly related to it by specifying...
Not too long ago my boss Yaniv got a telephone from one of our customers saying that he thought a cube was missing some values from it. The thing is that at first that didn't sound logical to us because usually we would get an error on that. We expected the process of the cube to fail, or something of that sort. But not this time. Now, there's a few reasons why there are rows missing from a cube as recently blogged by Richard Lees. But our reason was slightly different. We were using a view...
This blog is SUPER SUPER excited, because for the first time, after four years, we have a guest! I met Mr. Kobi Deutsch in the SQL Explore Convention held about two weeks ago. During a session we both took there, he mentioned something I wasn't aware and I thought maybe I'd bring it to you as well. So, I'm leaving the stage for Mr. Deutsch: Sometimes, when we check the MDX requests in the Profiler, we see that there is a partition that was scanned and loaded into memory although it is...
I recently opened a new project in SSAS 2008 R2. After finishing developing the cube, I deployed and processed it on the server. I got a really weird error message that meant, unfortunately enough, nothing to me: " Key cannot be null. Parameter name: key " So what's a girl to do? Well actually, I remember that every so often when I was developing a cube, I would have a problem with the data connection. The default I had defined for me when I opened a new connection was .Net Provider...
Vidas Matelis had put out a very good post with a great SSAS Whitepaper list. I strongly recommend you check it out as it summarizes some very important info about Management and Maintenance of SSAS. If you’re intrigued about what SSAS Maestro is, it's a program incorporated from lessons learned at SQLCAT and given by Solid Quality Mentors. The description sounds fascinating! I admit I’m slightly jealous at anyone going, but I believe the information will be gradually available to more and more...
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...
If you're following this blog, then you know that Sunday, May 30 th 2010, I went to the SQL & BI Data Platform convention held in Tel Aviv. Specifically, I went to Mr. Donald Farmer 's seminar on Data Integration in Large Organizations . I did live blogging from most of the event, though actually, I didn't manage to blog about the last part of it, because I was preparing for something that was pretty big for me.... I'll start over. When I first heard Mr. Farmer was coming to lecture...
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...
A colleague of mine ran into a peculiar problem with her cube. She deployed it just fine and didn't get any error messages. Still, there was a problem. She could see the dimensions in her SSAS project just fine. She could see her cube as well. But she couldn't see any of her measure cubes. So what was the problem? She was missing the calculate statement from her cube. If you look in the BIDS at your cube on the Calculations tab with a Script View, you'll be able to see that the first...
I was recently approached by SiSense to have a look at their product SiSense Prism . The product gives you a solution for "Dashboards, Reports, Guided Analytics, Business Presentations and everything in between", as SiSense would put it, and I dare say the definition is quite correct. The tool enables you to build a dashboard really within minutes the application is quite simple to get used to. Even if you do get lost along the way, there is also a collection of shorts videos to guide you...
More Posts
Next page »