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:
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.
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.
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?