BookmarkSubscribeRSS Feed
metalray
Calcite | Level 5
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.
5 REPLIES 5
AngelaHall
SAS Employee
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
metalray
Calcite | Level 5
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
AngelaHall
SAS Employee
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
metalray
Calcite | Level 5
Thanks Angela. I will try that.
metalray
Calcite | Level 5
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?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 851 views
  • 0 likes
  • 2 in conversation