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

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

A Parent Child Dimension for an Unbalanced Hierarchy

Monday, August 4, 2008

I found myself revisiting the Parent Child dimension quite unexpectedly. I'm working on a project which involves the division of the city to different statistical areas. The division of the city into these different statistical areas happens once every 10 years or so, according to the changes in population tracked by the municipality itself and the government in the Census of Population and Housing. Up till now, my cube had in it just the statistical areas distribution from one Census onwards and so had just one sort of distribution I needed to connect to in my cube. However, now...

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

Creating a Report Model based on an Analysis Cube

Wednesday, November 21, 2007

Well I guess congratulations are in order because I finally got around to using a report builder in my project. Turns out that building a report model based on a cube is as easy as 1-2-3. Still I had a problem, as for some unknown reason the translations were showing for my dimension names and my measures, but not for the dimension's attributes... At first I thought maybe this is a problem solved by Service Pack 2 (as my tests were done on a Server with Service Pack 1). Alas, no. So, a further look in the MSDN library,...

The Parent – Child Dimension

Tuesday, October 9, 2007

A Parent - Child Dimension is a special sort of dimension, to be used in case:  You have data even for non – leaf members. For instance, you may have set – up costs allocated for the Category level (the higher level), but profit data for your Product level (the lower level). You have an unbalanced hierarchy. The classic example for this might be the Geographical Hierarchy which at times might look like: Country > State > City, and at other times like Country > City. For an international company trying to track its worldwide business, the hierarchy in the US...

Browsing a Cube and Influencing Aggregations

Thursday, September 27, 2007

You can browse a cube through the cube browser in Analysis Services or through the one in the Management Studio. I usually use the one in the Management Studio, as it gives your more space to look. In the cube I created in Analysis Services, I added a Budget hierarchy in my Budget dimension. I decided to check the data for the new hierarchy in comparison to the money that was assigned to it in the Budget fact table. And it was problematic…I was opening the Budget hierarchy and in the first 3 levels it reacted pretty quickly, but...

Slowly Changing Dimension type 2 in SSAS

Saturday, September 8, 2007

There are quite a few ways of ways of documenting the changes a business entity goes through over time. The most famous of them all (and the most difficult to build) is a Slowly Changing Dimension (SCD) type 2. doing this in a table, you would create a table which would include: an incremental key, the business key, the attributes you'd like to track for that entity, a start date and an end date (for which the information was right) and a flag which would equal 1 when we are looking at the last row available for the member...