|
|
-
|
|
Value field is needed in parameter pick list or drill-through hyperlinks
When working with Reporting Services, we often provide users with parameter pick list such as this one:
We also provide users with hyperlinks so users can drill through to see more ...
|
|
-
|
|
If you are familiar with T-SQL, then you are not a total stranger when it comes to MDX scripts. If you have written formulas in Excel, then you should be comfortable with calculations in MDX.
The difference is that in MDX, we don’t enter calculations in e...
|
|
-
|
|
If cube processing allows errors and missing keys, automatic notification process should be in place to check the data counts in the cube against the data counts in the fact table.
Although I’ve known that we can create MSOLAP linked server, and send pass-...
|
|
-
|
|
I am no expert on the subject of Visual Business Intelligence. As a matter of fact, I often struggle with the choices of presentation styles, colors, and other visual effects in my Reporting Services report designs.
While attending an online seminar from ...
|
|
-
|
|
Expand or collapse the inner most row group is a common practice
If you have ever created Row Groups in reporting Services, you must also have tried to give users a chance to expand or collapse the inner most row group, such as the Details group.
I believe...
|
|
-
|
|
Believe it or not, in the BI development world, waiting is fact of life. We often have to wait for the data is ready, or wait till it’s time to do certain things.
I had some examples in my blog showing how to use the Foreach Loop Container.
I often use t...
|
|
-
|
|
I have a blog, SSIS #108 – The Makeover of the Lookup Data Flow Component in SSIS 2008, a few months ago. Because of the two improvements of the lookup data flow component in SSIS 2008, the cache mode and the redirecting rows to no match output, I find mys...
|
|
-
|
|
No matter how much we were told that we are better off leaving TSQL behind when we are learning MDX, we are still trying to draw parallels between these two query languages.
One command every SQL developer is very familiar with is the TOP 100 (or any numbe...
|
|
-
|
|
Dimension attributes are always pre-sorted
In my previous post, MDX #7 – Get only 10 elements from a MDX query, I mentioned that dimension attributes are always pre-sorted.
This is obvious with the following query.
Parent-child hierarchy is sorted from t...
|
|
-
|
|
Very often, we are asked by our business users to explain certain behaviors of PivotTable in Excel. Our first instinct is to capture the MDX queries fired from Excel. Once I have the actual MDX query, I can analyze the query and the result, and will ...
|
|