question

StefanRadtke-7943 avatar image
0 Votes"
StefanRadtke-7943 asked LukasYu-msft commented

Analysis Server Pivot Table shows DimensionPermission warning while starting refreshing

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

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.

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Is this issue resolved ? Have you checked the dimensions, did you find something that is suspicious ?

0 Votes 0 ·

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>

0 Votes 0 ·

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 ?

0 Votes 0 ·
Show more comments

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.

0 Votes 0 ·