# CUBEMEMBERPROPERTY Function

### Question

• Hi All,

I'm working on reports partially based on Excel cube formulas. I have no problem with all cube functions except CUBEMEMBERPROPERTY. This function always returns #N/A. There's another topic about this issue but with no real answer.

I have created a linked table in Excel imported in PowerPivot to explain you the trouble. It's french data, all fields name have the same meaning in English except Ville which means town.

Région Département Ville Population
PACA 13 MARSEILLE 1000000
PACA 83 TOULON 200000
PACA 83 NICE 150000
RHONE ALPES 69 LYON 1500000
RHONE ALPES 42 ST ETIENNE 250000
RHONE ALPES 38 GRENOBLE 300000
RHONE ALPES 1 BOURG 100000

If i understood well, this function gives the value of a property for a specific cube member. So in my case i'm trying to get the property value for property "Région" for the member of the cube ville (town) LYON. The name of the table in PowerPivot is Tableau1.

To get this, i wrote these formulas with absolutely no success :
=CUBEMEMBERPROPERTY("PowerPivot Data","[Tableau1].[Ville].[LYON]","Région")
=CUBEMEMBERPROPERTY("PowerPivot Data","[Tableau1].[Ville].[LYON]","[Tableau1].[Région]")
(i have translated the french formulas by remplacing ";" by "," and the function name PROPRIETEMEMBRECUBE).
In the same time the function =CUBEMEMBER("PowerPivot Data","[Tableau1].[Ville].[LYON]") is working fine and even CUBESET and CUBEVALUE or RANKEDCUBEMEMBER.

So i'm asking you're help for this function which is not very well documented in the web. I even wonder if i understood well the function, if i'm not totally wrong about it. Maybe this function is not usable with PoxerPivot ?

Regards.
PS : Excuse me for my poor English.

Thursday, October 10, 2013 7:34 AM

• As far as I know, Power Pivot doesn't expose any member properties via MDX, so this function is useless when connecting to a Power Pivot model. It's only useful when you connect to an Analysis Services Multidimensional model.

Regards,

Chris

Thursday, October 10, 2013 11:43 AM

### All replies

• As far as I know, Power Pivot doesn't expose any member properties via MDX, so this function is useless when connecting to a Power Pivot model. It's only useful when you connect to an Analysis Services Multidimensional model.

Regards,

Chris

Thursday, October 10, 2013 11:43 AM