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