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

Donald Farmer on SQL Server 2008 R2, SharePoint and PowerPivot

Monday, June 14, 2010

If you're following this blog, then you know that Sunday, May 30th 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 in Israel, I was like "What? Really? Like, Donald Farmer? Like THE...

Free Datasets, Data Warehouse and OLAP Databases for your use

Wednesday, February 10, 2010

Whether you're doing demos, trying different aspects of applications or just looking for something new, you may want to have a broad and free selection of data to choose from. This post is here to help you out on that.I've collected a number of free data source for you to use: From the PowerPivot blog:Data on the District of Columbia http://ogdisdk.cloudapp.net/DataCatalog.aspx From Andrew Fryer's blog:Data from the UK Government: http://data.gov.uk/data/ Datasets for neighborhoods in the UK (with Geospatial data) http://www.data4nr.net/resources/all/ From Chris Webb's blog:The Guardian Data StoreData from the Greater London Authority http://data.london.gov.uk/ Also, following a post from Mr. Webb...

Slowly Changing Dimension Type 2 Tips & Tricks

Tuesday, September 9, 2008

Slowly Changing Dimension Type 2 Tips & Tricks I've blogged in the past about Slowly Changing Dimension Type 2, and I see that it's a subject that really interests you. I remember quite distinctly how hard and demanding it was to create it for my project (trust me I do!) and even to do it for two business entities. So, hoping that I may assist you even slightly, I thought I may share with you a few thoughts I have on the matter: Do you really need it? Now I know this is going to sound quite obvious, but before...

Creating a Report Model based on an Analysis Cube – Pros and Cons

Thursday, May 15, 2008

Creating a Report Model based on an Analysis Cube – Pros and Cons If you follow my blog, you probably know by now that I developed a report model based on the Analysis Services cube I already had. I even got around to updating the report model. And then, my users started using it. And you know, whatever we do just seems so wonderful to us, until our users find all sorts of flaws with what we did… so yes, my users did open my eyes to...

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

IBM to Acquire Cognos

Monday, November 12, 2007

Well I guess we could all see that one coming: IBM has just announced that it intends to acquire Cognos. News of the intentions themselves surfaced some time ago, and I guess the latest news in the area helped make the final budge. The amount of independent BI companies is again slimming down.
tags: ,
no comments

A Shift in the Market

Friday, October 26, 2007

This week, a couple of things happened. The first big news was that SAP had purchased Business Objects. The move is considered a response to Oracle buying Hyperion earlier this year. Microsoft has acquired ProClarity earlier in 2006. There also remains Cognos, SAS and Panorama as individual players. Still, Panorama has its own sort of news for this week, after it fired 20 of its workers in Israel (the article is in Hebrew). The workers are said to be from the development department and make for a fifth of the entire Israeli office of Panorama (which has 250 workers...
tags: ,
2 comments

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

Synchronizing Roles in Panorama

Saturday, September 15, 2007

Panorama Nova View Analytics is a viewer on a cube which enables you to drag and drop attributes and measures onto a grid, so as to study the influences different slicers and dicers have on a measure. Each combination of slicers and dicers with a certain measure, can be saved as a presentation (the name in Panorama for a dynamic report). The presentation is dynamic, as you can change not only the filters on the existing attributes (as in Reporting Services), but also add new attributes and remove the old ones, creating a new presentation altogether from the one...