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

Errors in the OLAP Storage Engine for a large dimension

Monday, March 3, 2014

A colleague of mine was working on a cube. The cube had a fact table that was also a dimension. It had 18 million rows of data. When my colleague tried to process the cube with that fact and dimension, he couldn’t. Both the full and the incremental process didn’t work. He got an error on processing the large dimension with a message of:   Exception calling "Process" with "1" argument(s): "File system error: A FileStore error from WriteFile occurred. Physical file: . Logical file: . . Errors in the OLAP storage engine: An error occurred while the 'RN' attribute of the 'YYYYY'...
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 ...

Power View on SSAS Multidimensional

Tuesday, December 11, 2012

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'm glad that Microsoft is...
no comments

Cascading Measure Values in a User Hierarchy in SSAS

Sunday, February 12, 2012

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 them as related attributes Now,...
one comment

Why are rows (still) missing from a SSAS cube?

Monday, September 19, 2011

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 in the DSV. The...

Query Performance and Partition Scans in SSAS

Sunday, July 17, 2011

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 not suppose to be touched at all.How...

Error Processing a Cube: Key cannot be null. Parameter name: key

Wednesday, July 13, 2011

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\SqlClient Data Provider. And somehow the default definition would always create an error...

SSAS and SSRS in SQL Server 2011

Saturday, November 13, 2010

Don't know if you're aware of it, but Microsoft just rocked your world! I remember interviewing Mr. Ariel Netz, Product Unit Manager for SSRS.  I wanted to hear from him what's planned for Report Builder 1.0 as I didn't feel like Report Builder 3.0 covered all the functionality that was in 1.0. I also wondered what sort of answer we will get for ad - hoc reporting against SSAS in SSRS. Mr. Netz said as much as he could I guess, as things were still under NDA. And now the future of Reporting Services is here... Project Crescent was just presented...

You can see your Dimensions but not your Measure Groups

Sunday, July 12, 2009

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 row in there is "Calculate;" The calculate...
tags: , , , ,