ssas - MDX results to Excel in Power Pivot -

ssas - MDX results to Excel in Power Pivot -

i don't know abcds of mdx. have query handed on me predecessor , needed 1 time in year! time of year happens now! query runs , returns results. however, unable re-create result along rows , column names ssas result window.

googling found options of linked servers, setting query options save result csv etc, using ssis packages , powerpivot.

the first 2 not possible because of restrictions on db. need go on bunch of corporate hurdles necessary permissions.

ssis packages , powerfulness pivot - have same issue. 'bud' named set , referenced in filter below in select statement. both ssis (when typed in oledb source) throws error - dimension [bud] not found.

working powerpivot, executed set create statement separately , pasted code after 'with'. error -the dimension [bud] not found.

any help of how reference bud in select statement powerfulness pivot or ssis? using sqlsever2008r2.

this procedure -

create set [db1].bud nonemptycrossjoin( {[market].[markets].&[europe].children,[market].[markets].[part of world].&[africa].children}, [product].[pl].&[cd] : [product].[pl].&[kz], [plant].[plant].children ) go fellow member measures.callscy1 /* lot of measure calutaions here */ select non empty { [measures].[qty sold], callscy1,costcy1,mtrlcostcy1,labourcostcy1, scr_c,callsry1,costry1,mtrlcostry1,labourcostry1, callscy2,costcy2,mtrlcostcy2,labourcostcy2, callsry2,costry2,mtrlcostry2,labourcostry2, callscy3,costcy3,mtrlcostcy3,labourcostcy3, callsry3,costry3,mtrlcostry3,labourcostry3 } * {[report period].[report periods].[quarter].&[2013-01-01t00:00:00] : [report period].[report periods].[quarter].&[2014-06-01t00:00:00]} on 0, non empty filter( bud, [measures].[qty sold] <> 0 or [measures].[qty service calls] <> 0) on 1 [db1]

does bud need seperate? can't utilize this?

with set [bud] nonemptycrossjoin( {[market].[markets].&[europe].children,[market].[markets].[part of world].&[africa].children}, [product].[pl].&[cd] : [product].[pl].&[kz], [plant].[plant].children ) fellow member measures.callscy1 /* lot of measure calutaions here */ select non empty { [measures].[qty sold], callscy1,costcy1,mtrlcostcy1,labourcostcy1, scr_c,callsry1,costry1,mtrlcostry1,labourcostry1, callscy2,costcy2,mtrlcostcy2,labourcostcy2, callsry2,costry2,mtrlcostry2,labourcostry2, callscy3,costcy3,mtrlcostcy3,labourcostcy3, callsry3,costry3,mtrlcostry3,labourcostry3 } * {[report period].[report periods].[quarter].&[2013-01-01t00:00:00] : [report period].[report periods].[quarter].&[2014-06-01t00:00:00]} on 0, non empty filter( bud, [measures].[qty sold] <> 0 or [measures].[qty service calls] <> 0) on 1 [db1]

ssas mdx powerpivot