AS 2005 Local Cube Drill Through

#1

I have a challenging set of requirements involving creating a local cube with
SQL drill through. Now that AS 2005 stores SQL drill through data directly
in the cube, it would seem possible to build a local cube (disconnected
functionality) with drill-through functionality. Is this possible ? Anyone
try it ?

Thanks

#2

Hello Mark,

Based on my scope, drillthrough action is drillthrough statement returned
to the client application. However, the detailed information of
drillthrough is stored in source dimension/measure table that is not
included in local cube. Therefore, I think it is not able to drill through
direclty via local cube.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:

Thread-Topic: AS 2005 Local Cube Drill Through
thread-index: AcYyYzTaxXq6hK1kQvudydjr0alwZw==
X-WBNR-Posting-Host: 12.177.68.254
From: "=?Utf-8?B?TWFya0dzY2g=?=" <markgsch (AT) noemail (DOT) noemail
Subject: AS 2005 Local Cube Drill Through
Date: Wed, 15 Feb 2006 11:08:29 -0800
Lines: 7
Message-ID: <CFA321E7-E4F9-40D4-9A4E-81DFE88AE8F3 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.olap:67261
X-Tomcat-NG: microsoft.public.sqlserver.olap

I have a challenging set of requirements involving creating a local cube
with
SQL drill through. Now that AS 2005 stores SQL drill through data
directly
in the cube, it would seem possible to build a local cube (disconnected
functionality) with drill-through functionality. Is this possible ?
Anyone
try it ?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

AS 2005 Local Cube Drill Through

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

AS 2005 Local Cube Drill Through - 02-15-2006 , 01:08 PM

RE: AS 2005 Local Cube Drill Through - 02-15-2006 , 09:15 PM