|
|
-
|
|
In my last post, I had quickly h......
|
|
-
|
|
As a response to my previous post, one of my readers asked me this question – “ why are you hell-bent on making a star schema? You yourself have told that a snowflake schema would give the best performance during cube processing and once the cube is processed, it doesn’t matter which schema was used......
|
|
-
|
|
<p align="justify"><font size="2">One of the best practices while designing a SSAS solution is to decouple your source database (which is in ideal cases, the data warehouse or the data mart but could also be an OLTP database) with the help of a semantic layer or view layer. Even though the Data Sour......
|
|
-
|
|
The last couple of days, I have been fiddling around with an interesting mdx query passed on to me by Hrvoje Piasevoli (blog | twitter | MSDN). Though I wouldn’t be explaining about the query as Hrvoje himself would blog about it soon (once he gets off the SSAS forums and twitter, which could be nev......
|
|
-
|
|
Yups, 10 days have passed since I attended the SQLBits by the Seaside, and I am yet to recover from the hangover. And nopes, I am not talking of the hangover from the beer I drank (though I must admit I did guzzle down a few too many, thanks to all the wonderful sponsors who were way too generous ha......
|
|
-
|
|
Recently I got a very interesting query from one of my colleagues. He was trying to sort a table in a SSRS report based on an integer member property, but the sort results were coming wrong according to him. He said that the report was treating the property field as a character and claimed that this......
|
|
-
|
|
Nowadays, the project that I am working on is keeping me quite busy and all the documentation work is driving me nuts (you wouldn’t believe me if I said I hate documentation ). But somehow, I do find time to respond to the steady flow of queries that keep coming to me. And today, when one of m......
|
|
-
|
|
What do you do when you want to re-use an image in one of those old forgotten reports that was developed by that weird guy who left your company an year ago? No matter how much you hate or abuse that guy now, it is not going to do you any good as he didn’t save those images in a source or version co......
|
|
-
|
|
I have been always interested in the potential of map reports. So naturally, when I found out a site which had quite a number of shapefiles for free, I decided to blog something just for the fun of working with map reports. Being around in the forums, I had seen a lot of posts asking how to drill do......
|
|
-
|
|
<p align="justify"><font color="#000000" size="2">Why do people write blogs or help other people in the technical forums? This was a frequent question that I used to ask to people around me. For some reason or the other, I couldn't fathom why people would want to spend their personal times on such s......
|
|