22,209
社区成员
发帖
与我相关
我的任务
分享
declare @mdx varchar(max)
set @mdx= '
select {[Measures].[Year_Pres_Quantity],[Measures].[Month_Pres_Quantity]} on 0
,non empty ([material].[material_name].[material_name],[city].[city_name].[city_name]) on 1
from [cube_1]'
exec('
select cast("[material].[Material_name].[Material_name].[MEMBER_CAPTION]" as varchar(200)) as material
,cast("[city].[city_name].[city_name].[MEMBER_CAPTION]" as varchar(200)) as city
,cast("[Measures].[Year_Pres_Quantity]" as numeric(18,0)) as Year_Pres_Quantity
,cast("[Measures].[Month_Pres_Quantity]" as numeric(18,0)) as Month_Pres_Quantity
From OpenQuery(olap,'''+@mdx+''')
')