EPM Function to Display all Base Members in MS Excel

[Former Member]

Hi everyone,

I need to display all base members of a dimension in Microsoft Excel.

Tried =EPMContextMember(,"DIMENSION1","CALC=N") but don't think it is working as it reads my context, which is a parent node.

What EPM function should I use to do so?

Thanks!

[Former Member · Accepted solution]

Hi Mohammad,

I don't think that you can display the results of an EPM report in once cell.

You could however concatenate the results as a second step.

Regards,

Mark