Re: Drilltrough Question

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:
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:
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

.

Relevant Pages

  • Re: Internet class differences...
    ... The database and web interface to the server is produced by a different ... Initially a WebClient class was used. ... This worked fine for submitting the query. ... retrieve the results but, instead, is sent to a login page from which it ...
    (microsoft.public.dotnet.general)
  • Re: Drilltrough Question
    ... not query the underlying relational database, ... that in AS2000 drilllthrough queries retrieved data from the underlying ...
    (microsoft.public.sqlserver.olap)
  • Re: How can I reduce the number of queries to my PostgreSQL database?
    ... SR> all books in the database, and all authors for each book. ... retrieve a list of all book_ids and book_titles. ... That's one query, if you're willing to make it advanced enough, ... although you need to make an aggregate to enable PostgreSQL to ...
    (comp.lang.python)
  • Re: Datetime within past week
    ... Prior to adding a new record to the database, I want to run a query to ... retrieve all of the records uploaded in the last 7 days. ...
    (comp.lang.php)
  • Re: Need help improving authorization
    ... >roles stored in the database. ... Currently, I retrieve the the ... >I think a more efficient approach would be to query the database only once ... >a delimied string and stored in cookie or a session variable. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading