« Ongoing De-Evolution of Data Management | Main | MDX Class Schedule Fall '08 »
Wednesday
Oct292008

Drillthrough

It's rare that a cube will contain transaction details. So once a user drills down to the bottom of a cube, it's common to want to see the transactions that comprise a given value. That's what drillthrough is for, or at least that was the case in the old days.

But alas, though SQL Server Analysis Services 2008 as a whole has made big strides forward, such is not the case with the drillthrough feature. Starting with AS 2005 and carried forward in 2008, drillthrough is not very useful.  

Here is a good explanation of the drillthrough architecture. In short, drillthrough no longer executes a sql query; it merely issues a detailed query to the cube. Think of it as a bulk drilldown, not as drillthrough.

Also bear in mind, there's no ability to drillthrough calculated members/cells, which is understandable. Nor can you drillthrough when there's a multi-select, which is not so understandable.

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments (12)

What is Breitling? Do you know Breitling Watches? Buy these Breitling Watches sale on line.More cheap Breitling Watches for sale! 岩姐测试!如有雷同,纯属巧合!

July 8, 2010 | Unregistered Commenterbreitlingwatch

The shape of the stylish Louis Vuitton is between 10 to 15 inches, which is very suitable for she put some office files and diary. Her colleagues did not notice her shining eyes. Although she has announced the Manhattan GM become her most favorite Louis Vuitton Bags so far and she does not going to buy other

August 22, 2010 | Unregistered Commenterpandora

"It had to be used every day, like a replica watches ."The battery life of replica Chanel watches will change, depending on the wireless usage, Schneider said. In one mode, called "Glance," the replica IWC watches will cycle through various data services, running down the battery relatively quickly.

August 22, 2010 | Unregistered Commenterreplica watches

Thanks for taking the time to talk about this, I feel fervently about this and I take pleasure in learning about this topic and I think that I will be coming back tomorrow to continue reading. ysl sunglasses

November 23, 2010 | Unregistered CommenterWilliam A

I, too, am getting frustrated with the amount of content that is now being offered in video form that should just be text. -Frankie Morello mens jeans

July 11, 2011 | Unregistered Commenterbea99777

This is my first time i visit here.replica hublot watches
I found so many interesting stuff in your blog especially its discussion, if can more pictures will be better. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work. Replica Audemars Piguet

July 21, 2011 | Unregistered Commenterabbyabbie

This is a good article,thank you for your share,I like it very much.Our products are superior in quality and moderate in price and are sure to be saleable in your market,by virtue of this superior quality, this product is often sold out in many areas. This new product is really much better than the previous one. You have to try it to believe it

==replica iwc watches

July 25, 2011 | Unregistered CommenterSaraer

I'd be interested in hearing. The TOS seems rather clear that it is not unless expressly approved by Amazon. I guess if the library got it in writing then they would be ok. ijjfwj ijjfwj - Kids Moncler Jackets.

October 15, 2011 | Unregistered Commenterhzyqyk hzyqyk

moreover rain. You may wish to determine whom our jacket is likely to shield cheap true religion jeans away from these components.

November 8, 2011 | Unregistered Commentersping

I recently attended a lecture Cheap Newest Nike Shoes For Salewhere the instructor had showed how to snip the dangling threads

from the top of the piece by tugging on the top thread Nike Jordan 13to pull up the bobbin thread and

snipping both at the same time, rather than cutting Cheapest Nike Shoes For Salethreads from each side with a scissor action.

She claims to Retro Jordan 17save hours of time and strain on her hands. It works.Chain piecing saves

time, as we all know, but also Cheap Vibram Five Fingers Shoes On Saleincreases our accuracy by repeating the same thought

process before Five Fingers For Menwe move to another step.Know your strengths and weaknesses. If you

can Nike Shoes Discounted Saleneedle turn Cheap Jordan Shoesa smooth edge,

don’t spend time basting. If your Jordan Take Flightcutting isn’t as accurate, buy better

tools, take a class Nike Jordan 14or trade services with a friend.

November 10, 2011 | Unregistered Commenterexpensive

Go the Salvatorre Ferragamo way- Need to pep up your day at work? Do it with style and rightly so coach purse outlet. Get a smart and sassy fashion handbag inspired by a Salvatore Ferragamo. Make sure it comes with a dual buckle in pastel shades of lime greens and lemon yellows. The entire look should be compact yet the coach outlet store online interiors should be spacious with loads of compartments.

Go the Guess way- Need a tiny and trendy handbag for an evening out at the coffee shop then make it look like an exclusive piece from the coach purses outlet Guess fraternity. Single straps that have a silver tone, lots of studs on elegant faux patent leather can take you places! Look out for embellishments and rhinestones that louis vuitton add a designer element to your piece.

Go the Prada way-If you need a fashion handbag that is large on space and louis vuitton outlet also chic then go in for pretty pinks with elegant top and center stitched detailing. Ensure it comes with magnetic snap closures for easy access when you are on the go. This spacious cheap coach purses can look sophisticated when accented with silver tone rings.

Go the Calvin Klein way- If you have a fetish for clutch bags, then go in for a silver colored one or make it pure black to match your exclusive gowns. Get a long frame for a classic look. A smooth and sleek curved clasp would be the icing on the cake to achieve this look. Look for an inbuilt shoulder strap, which makes it more versatile.

If you are not fortunate enough to own a trendy designer-labeled louis vuitton outlet then you can source stores that offer beautiful creations on the lines of a Gucci or a Christian Dior. Perfected with precision, these fashion handbags are bound to save you a few bucks and you can be a fashion diva without really spending like one!

A trip through any trendy mall will reveal a plethora of brands that offer a multitude of designs, shapes, textures and sizes. Dolce and Gabbana, Fendi, Christian Dior, Louis Vuitton, Chanel, Versace and coach purses many such brands have rewritten the traditional norms of fashion and the way handbags are being made today.

When fashion goes the designer way; it does not always adhere to branded clothes or branded shoes. Women are known to carry one-of-a-kind coach purse to add some bling to any subtle outfit. All fashionistas spend hours scrounging through the most sought-after branded outlets in their search for the ultimate trendy louis vuitton outlet. An important part of any ensemble, designer handbags can either make or break your entire look! It’s about finding the right match and using it with great élan.

November 23, 2011 | Unregistered Commentercoach purse outlet

Tory burch flats are a very good investment when it comes to shoes, these kind of replica replica tory burch replica tory burch shoes sale boots tory burch boots tory burch replica shoes for sale reva tory burch outlet tory tory burch boots online burch reva flats shoes tory tory burch outlet online tory burch factory outlet online store burch outlet online tory burch boots cheap fake will last a long time.If tory burch boots replica tory burch sale replica you are looking for a fashionable,modern tory burch boots online shop and be up fake tory burch boots replica tory burch flip flops replica tory burch bags to date with the latest flat styles without tory burch outlet online replica tory burch flip flops going over your tory burch flip flops budget, tory burch tory burch flats flats are the right option tory burch outlet sale online replica tory burch flats for tory tory burch replica flats burch replica boots you.Tory burch flats are are well designed with a a large,metallic, tory burch replica bag circular logo placed near the replica tory burch bags toe does little more than draw the eye along the length of replica tory burch boots the foot, the ballet flats are available in assorted colors,from grass green to orchid pink, purple and papeete turquoise,stylisy and colorful.Tory burch flats are perfect for busy days about town when compromising on style is not an option.The best choice in tory burch flats is the reva flat. This type goes with any style and shall remain a Tory burch boots classic for years to come. Before you head out to buy your tory burch flats, This will ensure that you are getting shoes of the best quality of materials that will be comfortable for tory burch replica shoes your feet.Tory burch flats are the closest to what i would call a must-have pair of shoes.

December 2, 2011 | Unregistered Commenterhemin

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>