Looking for examples which work against Adventure Works. Suprised that
Googling has not found anything.

This example is a good starting point, but isn't exhaustive.

http://spaces.msn.com/members/denster/Blog/cns!1pvF91EMBBNxnTGlLGUgGehg!296.entry

V

Can drillthrough work on more than 1 measure groups?

Once I tried that, this message is returned
Errors from the SQL query module: Drillthrough columns must belong to
exactly one measure group. The columns requested by the drillthrough
statement are referencing multiple measure groups.

Any workaround for that? Can more than 1 drillthroughs be 'union-ed'
in some ways to achieve the effect?

Hi Voorshwa,

I had found that example. But it doesn't work for me. I get this error:

Query (8, 2) Errors from the SQL query module: The 'Full Name' column cannot
be found in the '$Customer' table.

"Voorshwa" <voorshwa (AT) gmail (DOT) com> wrote

Try this, just a change on the Customer Name and Country Region lines
(as the Adventure Works cube was used as an AS Tutorial tool and the
names got changed at some point in the tutorial lessons)

drillthrough maxrows 100
select
{[Measures].[Internet Order Quantity]} on 0,
{[Product].[Product Categories].[Clothing]} on 1
from [Adventure Works]
return
[$Product].[Model Name] as [Model Name],
[$Customer].[Customer] as [Customer Name],
[$Customer].[Country] as [Country Region],
[$Measures].[Internet Order Quantity] as [Orders],
[$Measures].[Internet Sales Amount] as [Sales],
[$Measures].[Internet Total Product Cost] as [Cost]

That did the job - thanks!

"Rose" <rose.say (AT) gmail (DOT) com> wrote

Drillthrough can only return columns from 1 measure group. However, the cool
thing about it (in my opinion ) is that you can drillthrough on measure A
from measuregroup MG1 and return columns from MG2 -- but all the columns
must be from MG2.

This way, you can create a "virtual" measure group with a pure ROLAP
partition and return whatever information you need as part of modeling this
new "virtual" measure group. Of course, you have to be a little careful with
this so that you don't affect calculations (correctness and performance),
but it gives you some great flexibility.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Rose" <rose.say (AT) gmail (DOT) com> wrote