Essbase Member Name vs Alias

[MJR]

Hello all

Newbee here.  I have connected my essbase cube to PowerBI - no issues with connecting.  However, when PowerBI creates the tables it uses the alias table for member names.  I want it to use the member name.  

Has anyone every been able to address this?  I suspect no as I have scrubbed the internet for answers and found none.  Hoping someone here might have knowledge if its even possible.  Thanks

[Annie_Do_1413]

Hello , 

You can create another table alias with no alias and assign it as an active table in Essbase Administration Service . 

After that , when reconnecting PBI , it gets member name only 🙂

Try by urselft. 

Thanks!

[Annie_Do_1413]

Hello , 

You can create another table alias with no alias and assign it as an active table in Essbase Administration Service . 

After that , when reconnecting PBI , it gets member name only 🙂

Try by urselft. 

Thanks!

[NikhilChenna]

Hi @MJR ,

Can you check the below link ,

https://knowepmbi.wordpress.com/2015/10/21/essbase-using-mdx-return-member-name-instead-of-alias/

Regards, 
Nikhil Chenna 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Ashokrajm]

Hi @MJR, did you get any soulion for this. Even we are having same issues.

[MJR]

I did not get any solution as of yet.  Somehow we need to reference the member properties name.  I just dont know where or how.  I suspect there is a way to do that in MDX but I dont know.  Would prefer to do it right in the query itself.  

[Ashokrajm]

I did it with MDX but not with PowerBI(in Qlik with MDX we can swtich). But with PowerBI MDX is not working as expected. Hope someone can help.

[MJR]

Same here.  Did it in Qlik.  So far my work around is to load data with the aliases and have a separate table with the names to reference.  Not my prefered method but should work until I can figure out how to pull names.

[v-yangliu-msft]

Hi  @MJR ,

It may be that the wrong table was identified in Power Query, can you provide a screenshot of the table and error related information?

You can do it in Transform in Power Query

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Annie_Do_1413]

When you connect to Essbase by PBI, it disables the Transform button. 

Such a sad huhu.