Custom Drillthrough

Topics: User Forum
Aug 11, 2014 at 8:23 AM
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 11:32 AM
Just create a Rowset action linked to the country attribute and put whatever measures and attributes you want in the return clause.


ON 0
FROM [Adventure Works]
,KEY([$Product].[Model Name])
,[Reseller Sales].[Reseller Sales Amount]
,[Reseller Sales].[Reseller Tax Amount]
,[Reseller Sales].[Reseller Standard Product Cost]