This project has moved and is read-only. For the latest updates, please go here.

Custom Drillthrough

Topics: User Forum
Aug 11, 2014 at 9:23 AM
Hello.
I want to make some "custom drillthrough", i want to use current member of only one dimension and set members of other dimensions by mdx.
For example, i have pivot table in excel with dimension country(USA,Canada,Australia) in rows and dimension year(2012) in columns and some measure in values.
I want to click at cell (Canada,2012,measure) and make new table with Canada in rows and all years in columns (2012,2013,2014) and some measures as value.
How can i make smth like this?
Aug 11, 2014 at 12:32 PM
Just create a Rowset action linked to the country attribute and put whatever measures and attributes you want in the return clause.

eg.

DRILLTHROUGH
SELECT
([Geography].[Country].CurrentMember)
ON 0
FROM [Adventure Works]
RETURN
[$Date].[Date]
,KEY([$Product].[Model Name])
,NAME([$Employee].[Employee])
,[Reseller Sales].[Reseller Sales Amount]
,[Reseller Sales].[Reseller Tax Amount]
,[Reseller Sales].[Reseller Standard Product Cost]