topic Re: MDX Expression to get LevelX Member Properties('X') in SAS Web Report Studio

MDX Expression to get LevelX Member Properties('X')

metalray — Wed, 22 Dec 2010 10:04:40 GMT

Hi Guys,
I try to add a Data Item Property Expression in my Info Map.
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:

InfoMap Expression Editor:

(SalesRep).Properties('AliasName')
OR
[SalesDimension].AllMembers.Properties('AliasName')

"invalid and cannot be used in a query"

I would be gratefull for any help.

Re: MDX Expression to get LevelX Member Properties('X')

AngelaHall — Wed, 22 Dec 2010 13:19:21 GMT

Included are some examples from Microsoft: http://msdn.microsoft.com/en-us/library/ms144821.aspx

Your examples below appear to be at a higher level than what the documentation states - you will need to select an individual member.

Example:
[SalesDimension].[SalesHierarchy].[Region].[State].[City].Properties('AliasName')

If you still get the error message in Information Map Studio you can choose to move forward anyway. I would then suggest grabbing the MDX code from the IMap Test Screen and testing in Base/EG.

~ Angela

Re: MDX Expression to get LevelX Member Properties('X')

metalray — Wed, 22 Dec 2010 13:46:24 GMT

Hi Angela,
thanks for that. I was afraid I had to select an individual member and unfortunately
this does not helpe me 🙂 Depending on the information map I want to display the AliasName instead
of the real name. Different hierarchies does not work either since the levels would not change just the member name.
Thanks again

Re: MDX Expression to get LevelX Member Properties('X')

AngelaHall — Wed, 22 Dec 2010 13:51:31 GMT

This sounds like a situation where using a stored process with your custom proc sql mdx code would be appropriate. You could then setup the information map to access it and define the table for your Web Report Studio users.

My #SASTalks webinar on Thursday last week covered how to do this for switching a query on an RDBMS - but the method would be the same in this case.

~ Angela

Re: MDX Expression to get LevelX Member Properties('X')

metalray — Tue, 28 Dec 2010 09:13:24 GMT

Thanks Angela. I will try that.

Re: MDX Expression to get LevelX Member Properties('X')

metalray — Tue, 28 Dec 2010 11:42:55 GMT

Hello,
I have had a look at opening a cube in EG and it seems I have to define a slice and temporary table as well. associating the stored process to an information map also requires a table. now, this is getting a bit too component heavy.
I was hoping to build a query or mdx expression (to just get the member property e.g. alternative naming of members in a different language) that queries the cube without going all the way through sas data sets, tables,views, slices, etc. is that possible?