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

[Palczan]

Hello Everyone,

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

Code: Select all

{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

[Elessar]

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

[Palczan]

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.

[Elessar]

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