Recommended SSAS whitepapers

Monday, January 31, 2011

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 people. In the meanwhile, go brush up on SSAS management and maintenance through the whitepapers.

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

Finding distribution in a list of values

Thursday, September 18, 2008

I had a friend of mine ask me a question not long ago. He had developed a site for posting ads on selling houses for a certain company. The managers of the company were now trying to analyze the data on people posting ads. One of the things they were asking him to do, was give them a graph on how many people were posting ads on a certain span of prices. They weren't going to define him the span of money, but rather wanted him to give them the span, according to the amount of people that existed...

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

BIDS Helper for SQL Server 2008

Sunday, August 17, 2008

I know I had recommended the BIDS Helper for you before, but as a new version of this Visual Studio add – in just got out this Saturday with support for SQL Server 2008, I thought it's a great time to remind everybody they should check it out. Most of the features in this release are available only through their source code, which is there for you to compile and deploy yourself. My personal favorite feature would be the Non-Default Properties Report, which helps you track the settings in your SSIS Package or your SSAS cube and...

How to avoid breaking reports based on your Report Model

Sunday, June 8, 2008

Almost every post I made about Report Builder, be it the pros and cons of creating a report model on a cube or refining a report model based on a cube, brought the same question - what makes reports based on a report model to break and how can you avoid it? Well I didn't know the answer as I admit it never happened to me, (sigh of relief), but the question did bother me enough for me to try and research it a bit more on the internet. And yes, I'm happy to say there is more than...

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

Visual Totals in MDX and Role Security

Wednesday, February 6, 2008

Well I thought today we'd go over visual totals in MDX and also see how they may have an impact on how you assign role based security in you SSAS project. Visual Totals in MDX are there to give you just what they describe – a sum on the children in a certain set. Child members which are not in the specified set will be ignored during the calculation. For instance, if I have a set that consists of: USA, New York, Washington and California, when I look at the total for USA, I will only see it's sum...

A PowerShell Provider for Analysis Services

Thursday, December 6, 2007

  Well I admit I never thought I'd be interested in PowerShell, but I guess it's time for me to learn something new. Darren Gosbell has developed a great new tool: PowerSASS, which is just as the title states, a PowerShell provider for Analysis Services. The tool actually gives you the ability to look at the information from the AMO library as if it was a drive. You can look just as easily at the Roles you defined in your cube or at the Server properties. As I am still learning it all, so for further information I would recommend...

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