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

Post Reply
Palczan
Posts: 22
Joined: Tue Apr 14, 2020 8:57 am
OLAP Product: TM1 Cognos
Version: 11.3.0.27
Excel Version: Office 365 MSO 64bit

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

Post by Palczan » 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:

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

User avatar
Elessar
Community Contributor
Posts: 243
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Location: Russia

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

Post by Elessar » 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
Best regards, Alexander Dvoynev

Palczan
Posts: 22
Joined: Tue Apr 14, 2020 8:57 am
OLAP Product: TM1 Cognos
Version: 11.3.0.27
Excel Version: Office 365 MSO 64bit

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

Post by Palczan » 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.

User avatar
Elessar
Community Contributor
Posts: 243
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Location: Russia

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

Post by Elessar » 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
Best regards, Alexander Dvoynev

Post Reply