Hi,

I have table A[ID,GRP,SID,INFO] and table B[SID,SNAME,SADD]. I want to
define a dimension with levels [INFO,GRP_SNAME, ID] in that order,
INFO being the highest level. The member name column is set to A.INFO
for the INFO level, and A.ID for the ID level.
I want the members of the GRP_SNAME level to be concats of A.GRP and
B.SNAME. How do I specify this in the level properties? When I set the
member name property to "A"."GRP" + "B"."SNAME", I get a message
saying Invalid Column.
Itried creating the dimension using Snowflake schema with A and B as
the tables. Yet the problem remained. Does this mean that the member
name column can have an expression made up of columns from a single
table?

Please help
Yash