Skip to Content
Feb 23, 2020 at 10:42 AM

MDX statement user is not authorized

339 Views Last edit Jun 24, 2021 at 01:52 PM 2 rev


I am trying to practice the level hierarchy exercise on HA300 on my HANA express environment, when I use MDX provider on Excel, I get my builded cube calculation view with hierarchy successfully. But when I choose the column from pivot table, I get the error message below.

"sql prcoesing error: Error occurred while executing a MDX statement. The error message is: user is not authorized"

I google and search the community, but still have no clue. Please give me some direction please, thank you.