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

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

Can’t see all the rows in your drillthrough report in report builder?

Sunday, December 13, 2009

I'm developing a report model in Report Builder 1.0 at the moment. I felt like it was finished and started testing the model with some sample reports I knew my client needed. And then I got the oddest thing…I would get a report saying something like:   Gender              Marital Status                Amount of SalesNA                    NA                                865Male                 Single                            30Female             Single                            36NA was what I chose to put in case I was using referential integrity. I was looking at the sales table and the employees table and if I found a sale which didn't have an employee, then I created a fictitious employee for...
no comments

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

Recreating a Report Model

Wednesday, October 31, 2007

Remember how I taught you to recreate your Analysis Project? Well, let's say this time you have a model you deployed to the Reporting Services Server, but you have changed it since then and want the old version back. So how would you recreate the model you have on the server?  First of all, create a new Data Source View in your Analysis Project. It doesn't have to include all the relevant tables, as you'll only use it as a shell to build upon. After you've finished defining the DSV, save the project. Then, right click the new DSV...