IDT 4.0 MDX code: how to get Member Unique Name of a dimension?

[florencialimongi]

Hi,

I have several dimensions such as Office, Sector, etc.

I need an MDX code to insert in IDT to get the Member Unique Name of the Office dimension.

Any ideas? Thanks in advance!!!!

Florencia

[florencialimongi]

I need an MDX code to insert in IDT to get the Member Unique Name of the Office dimension.

Does anyone know why the none of this codes are working?

[Oficina_Comercial_JOC01].[MEMBERS].[UNIQUENAME]

[Oficina_Comercial_JOC01].[UNIQUENAME]

([Oficina_Comercial_JOC01].[UNIQUENAME])

([Oficina_Comercial_JOC01].[CURRENTMEMBER].[UNIQUENAME])

([Oficina_Comercial_JOC01])

([Oficina_Comercial_JOC01].[CURRENTMEMBER].[NAME])

([Oficina_Comercial_JOC01].[NAME])

[Oficina_Comercial_JOC01].[CURRENTMEMBER].[KEY]

[Oficina_Comercial_JOC01].[KEY]

[Oficina_Comercial_JOC01].[Oficina Comercial JOC01].[HIERARCHY].[COUNT].[LEVEL]

[Oficina_Comercial_JOC01].[Oficina Comercial JOC01].[MEMBERTOSTR].[NAME]

Any ideas?

Thanks in advance!

[Former Member]

what is the data source of universe? What is the exact version of your BO 4.0?

Thanks

Mallik

[florencialimongi]

Hi, thanks for your reply!

Data source of universe: OLAP cubes

BO 4.0 sp4 fix pack 3

data source: SQL 2008 r2

And I attach a screeshot with the MDX expression I'm trying to use, and the error I get:

[florencialimongi]

I attached the image of what we've been trying and the error we got!