TM1 Forum

Posted: **Thu Apr 08, 2021 9:20 am**

Hello Everyone,

today I have a problem with mdx. I write a simple MDX. This mdx is bellow:

{FILTER(
{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dim Product] )}, 0)},
[Security Type].(StrToMember("[}Clients].["+USERNAME+"]") ,[Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]) > 0
)}

Unfortunately, I can run this mdx when I am a admin but when I change a user I can't run this MDX. The statement is consecutive:
Get cell value: Cannot get cube cell value

I add permission to this Cube and all using dimensions for all users on server.

Anybody, has a similar problem?

Thanks
Kamil

Posted: **Thu Apr 08, 2021 10:12 am**

Hi,

I assume your user does not have have access to the "Security Type" cube or to dimensions' elements. Try to open this "[Security Type](user, [Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]" in Architect

Posted: **Thu Apr 08, 2021 10:37 am**

Thanks Ellesar for your answer.

Now i have permission to the Cube and Dimensions using in this Cube. I set a WRITE permission on intersection.

On this server I'm using Dataresrvationmode but for different cube.

Posted: **Fri Apr 09, 2021 12:39 pm**

You do not need "WRITE", "READ" is enough

Try to check whether your user can access to this slice in tm1web/architect: "[Security Type](user, [Dim 1].[Total of Dim 1],[Dim 2].[Element 2],[Dim 3].[Element 3]"

Also check if the user has access to }Clients dimension and it's elements

TM1 Forum

MDX Error: Get cell value: Cannot get cube cell value

MDX Error: Get cell value: Cannot get cube cell value

Re: MDX Error: Get cell value: Cannot get cube cell value

Re: MDX Error: Get cell value: Cannot get cube cell value

Re: MDX Error: Get cell value: Cannot get cube cell value