https://communities.sas.com/t5/SAS-Enterprise-Guide/Member-property-to-be-used-in-a-set/m-p/46106#M5233 Hi there, I want to use member property to form a valid Set. Is it possible?<BR /> For example if I have a hierarchy<BR /> [TimeDimension].[Year].[Week]<BR /> and if I want to have a lookup for year and week, can I declare 2 member properties for comparison year and week?? say, prev week and prev year and use it in my set like this:-<BR /> [TimeDimension].<B>[iif([TimeDim].currentmember.level is [TimeDim].[Week], <BR /> StrtoValue([TimeDim].currentmember.properties('Preyear')),0)]</B>.<B>[iif([TimeDim].currentmember.level is [TimeDim].[Week], <BR /> StrtoValue([TimeDim].currentmember.properties('Prevweek')),0)]</B><BR /> So if current year is 2008 and I want to get data for a measure say Sales for 2007 for a period which is NOT like for like will this work???<BR /> <BR /> Note: both member property has been assigned to level Week Mon, 15 Sep 2008 14:44:21 GMT deleted_user 2008-09-15T14:44:21Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Member-property-to-be-used-in-a-set/m-p/46106#M5233 Hi there, I want to use member property to form a valid Set. Is it possible?<BR /> For example if I have a hierarchy<BR /> [TimeDimension].[Year].[Week]<BR /> and if I want to have a lookup for year and week, can I declare 2 member properties for comparison year and week?? say, prev week and prev year and use it in my set like this:-<BR /> [TimeDimension].<B>[iif([TimeDim].currentmember.level is [TimeDim].[Week], <BR /> StrtoValue([TimeDim].currentmember.properties('Preyear')),0)]</B>.<B>[iif([TimeDim].currentmember.level is [TimeDim].[Week], <BR /> StrtoValue([TimeDim].currentmember.properties('Prevweek')),0)]</B><BR /> So if current year is 2008 and I want to get data for a measure say Sales for 2007 for a period which is NOT like for like will this work???<BR /> <BR /> Note: both member property has been assigned to level Week Mon, 15 Sep 2008 14:44:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Member-property-to-be-used-in-a-set/m-p/46106#M5233 deleted_user 2008-09-15T14:44:21Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Member-property-to-be-used-in-a-set/m-p/46107#M5234 Just to update this track. Example would be <BR /> [TimeDimension].[2007].[5] and if it retrieves any measure then<BR /> <BR /> ([TimeDimension].[2007].[5], measure1) Mon, 15 Sep 2008 15:09:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Member-property-to-be-used-in-a-set/m-p/46107#M5234 deleted_user 2008-09-15T15:09:50Z