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.
FROM [Adventure Works]
,[Reseller Sales].[Reseller Sales Amount]
,[Reseller Sales].[Reseller Tax Amount]
,[Reseller Sales].[Reseller Standard Product Cost]