Hi experts,

Can anyone help me to find out how drilllthrough works in SSAS2005? I know
that in AS2000 drilllthrough queries retrieved data from the underlying
datasource. Also, I could retrieve any column from any table in the
underlying database. It doesn't seem to work the same way in SSAS2005. First,
I can't include anything which is not measures or attributes. Second, I
stopped the dabase engine service, but still was able to drillthroug the data
in the cube.

Any help would be greatly appreciated.

--
Thanks a lot,

ID

you have to add an action in your cube
a drill through action.

you can create more then 1 drill.
In my case I have 1 drill by measure group and this drill is setup the
default for this particular measure group.

and then use the same MDX command like in AS2000
drillthrouh select ... from cube...

read this article:
http://msdn.microsoft.com/library/de...nservdrill.asp


"exkievan" <exkievan (AT) discussions (DOT) microsoft.com> wrote

The drillthrough in SSAS2005 works differently than in AS2000: it does
not query the underlying relational database, it only query the
processed data (dimension attributes and measures) of your cube.
The only way to query the relational data is to define a ROLAP
database, but you still can't add table fields that are not included in
the UDM model.
Anyway, this should be described in the documentation too.

Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi


exkievan wrote:

This has been updated in the MSDN refresh around July. If you check the
online version which is always the latest,
http://msdn2.microsoft.com/en-us/library/ms145964.aspx, it now states:

In Microsoft SQL Server 2005 Analysis Services (SSAS), the results are
retrieved directly from MOLAP storage, unless ROLAP partitions or
dimensions are queried.


- Chu

Marco Russo wrote: