Analysis Server Pivot Table shows DimensionPermission warning while starting refreshing

Stefan Radtke 1 Reputation point
2021-03-03T10:35:17.047+00:00

I´m an Analysis Server Admin. I opened the SQL Server Management Studio and connected to Analysis Server Database. Then I opened a role and add a new member. The new member opened Excel and connected himself to the Analysis Server Database. If he load the Cube the warning "DimensionPermission (1, 1) The EqualTo-Function expect a string or a numeric expression for the 1-argument. A level expression was used." appeared. All other users in this role can refresh the data in the pivot table without the warning. Do anyone have an idea how I can fix the problem?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,102 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,796 Reputation points
    2021-03-04T02:56:24.337+00:00

    DimensionPermission (1, 1) The EqualTo-Function expect a string or a numeric expression for the 1-argument. A level expression was used.

    From the warning description, I am guessing there is some dimension security set for this user. You need to check the dimension level security expression for this user. Try to find somewhere in a equal expression , see if level function was implemented.