Forum Discussion
Essbase Member Name vs Alias
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
9 Replies
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.
When you connect to Essbase by PBI, it disables the Transform button.
Such a sad huhu.
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.
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.
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!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!
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!
