MDX Expression to get LevelX All Member Properties('X')
Hi Guys, I am fiddling around with a small MDX expression and thought someone around would have an idea. Intead of the default member name on Level SalesRep I want to get the MemberProperty "AliasName". I tried all the MDX expresssions but had no luck: (SalesRep).Properties('AliasName') OR [SalesDimension].AllMembers.Properties('AliasName') I would be gratefull for any help
December 22nd, 2010 9:31am

Hi Polynaux2008, Did you ask this question on Reporting Services or Analysis Serivces? If on Reporting Serivces, you can get the member properties using the expression like this: Fields!FieldName("PropertyName"). See http://msdn.microsoft.com/en-us/library/ms156477.aspx for more details on using Extended Field Properties for an Analysis Services Dataset. If in Analysis Services, look into the following mdx example based on AdventureWorks cube: with member measures.productcolor as [Product].[Product].currentmember.Properties("Color") select measures.ProductColor on 0, [Product].[Product].members on 1 from [Adventure Works] See http://msdn.microsoft.com/en-us/library/ms144821.aspx for mdx properties syntax and examples. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2010 2:02am

Hi Jerry, Thanks for your feedback. I am not using either of those it was just a general question regarding MDX-Expressions. right now, I have as an MDX expression "MySalesDimension.Saleshierarchy" to get all member of that dimension and its hierarchy.
December 28th, 2010 4:07am

Hi polynaux, If the attributes which are used in Member Properties are not diabled (its AttributeHierarchyEnabled is set to True), then you can crossjoin the attribute and its Member Properties attribute to show the attribute themself and their "Member Properties" member. However, if the "Member Properties" Attributes are disabled, the attribute properties members can be only queries in calculated members as my first post. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
December 29th, 2010 1:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics