Amit Chandra (6/26/2016)
Here is the MDX -SCOPE ([Measures].[YTD Rolling POD Outlet],
[Outlet].[Customer].AllMembers,
[Date].[Fiscal Month].[Fiscal Month].MEMBERS,
[Item].[Brand Category].[Brand Category].MEMBERS,
[Item].[IPL].[IPL].MEMBERS,
[Item].[IPL Familyand Bottle].[IPL Familyand Bottle].MEMBERS
);
THIS = IIF ([Item].[Price Segment].CurrentMember IS [Item].[Price Segment].&[L],
IIF ([Measures].[YTD RAD] > 0.2395,1, 0),IIF ([Measures].[YTD RAD] > 0.4835, 1, 0)
);
END SCOPE;
Problem is with Outlet dimension. I need to find a way to exclude [All] member from my Outlet scope definition. Help?
Okay, well as I said the all member can be excluded by using EXCEPT or DESCENDANTS (or FILTER or "-" if you don't feel like typing). As I mentioned if you have large dimensions then that sub cube you are defining could get pretty big. Think about when and why this calculation would be used and consider refining it.