Hi, You can not slice by two different member from the same dimension. My adivse is to create a new member that aggregate the members you want into 1 memeber and then use it to make a slicer: data _null_; call symputx('y_s',put(year("&period_s"d),4.)); call symputx('q_s',compress('Q'||put(qtr("&period_s"d),2.))); call symputx('m_s',put("&period_s"d,yymmn6.)); run; data _null_; call symputx('y_e',put(year("&period_e"d),4.)); call symputx('q_e',compress('Q'||put(qtr("&period_e"d),2.))); call symputx('m_e',put("&period_e"d,yymmn6.)); run; proc sql; connect to olap (user="corp\sasprod" pass="{sas001}c2VwdGVtYmVy" host="sasprod" port=5451) ; create table prem as select * from connection to olap (with member MEMBER [Period].[All Period].[filter] as 'aggregate({[Period].[All Period].[&y_s].[&q_s].[&m_s]:[Period].[All Period].[&y_e].[&q_e].[&m_e]}') SELECT { [Measures].[STPBRTSUM] , [Measures].[PLMLY] , [Measures].[PLM], [Measures].[PLMYTD],[Measures].[PLMLYYTD] } ON COLUMNS , {[Agent].[Sub-Deal].[SUB_AGENT_NM].Members } ON ROWS FROM [Production] WHERE ([Period].[All Period].[filter] ) ); disconnect from olap; quit;
... View more