"Oh my God! Oh my God! Oh my God! Oh my God!"
And that was just my initial reaction when I discovered my post about the latest cumulative update for SQL Server 2005 SP2 got a mention on the opening page of Microsoft Israel!
Yes! It's true!! I could hardly contain myself! J
Still, I waited till I got home before doing my little dance of happiness in front of the mirror hearing in my ears "I'm so excited, and I just can't hide it…" (the Pointer Sisters for those of you who were not around in the 80's).
…like for instance, it could all of a sudden turn into a ball! J
Ok bad computing joke.
So this time around I thought I'd tell you about a weird incident I had with my cube. I found out I could see my cube in the Management Studio and even browse it, but when trying to run an MDX on it (again, in the Management Studio) it would tell me I didn't have any cubes for the MDX to run on.. I could still run MDX scripts on it in my SSAS project so I continued as usual, thinking to myself...
Today I thought I'd tackle a subject even more complicated that SSAS Best Practices (yes, it's possible!), so today's topic is BI in the government (though you were probably quick enough to get that from the title..)
As you may have read in my first post, I work for the Tel Aviv Jaffa municipality. Panorama hosted an event not too long ago with a panel. It so happens that Avi Ketko, head of the whole computing service in the Tel Aviv municipality (which would translate into my boss's boss's boss J) said something in that panel which didn't...
We define names for our tables and columns following the guidelines defined in our company. we might even adhere to international naming conventions. Still, nothing promises us the names we give our DB objects will be comprehensible to our customers.
And this is where SSAS steps in - Analysis Services enables you to give alternative names to your dimension attributes in the following two ways:
Translations may be given to: dimensions, dimension attributes, user hierarchies, measures, measure groups and to many other objects. The translation usually appears in a separate tab called (surprise) "Translations". This tab enables us to...