This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
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.
Is this issue resolved ? Have you checked the dimensions, did you find something that is suspicious ?
Sorry for the late answer.
There is one role for different users. The warning only occures for users which I now add to the role. Where can I set an dimension level security expression for only one user? The only opportunity to set rights that I know is the role and in the role I set the rights for all users. Here is a section of the statement for one of the dimension which is used in the cube. The path for dimensionpermission shows roles, but nothing only for the user:
<DimensionPermission>
<ID>DimensionPermission</ID>
<Name>DimensionPermission</Name>
<RoleID>Role 3</RoleID>
<Read>Allowed</Read>
</DimensionPermission>
Yes, it is set in the role. And you only have one role here, some user in it has this issue but some others not ?
Yes, that´s my problem.
I am wondering back and forth here, can't really find anything,since the Pivot Table send MDX query when querying data. I am not sure if which particular dimension cause this?
Could you try to find the error causing dimension or the mdx expression which will sure boost the debugging.