Error creating new view......

Post Reply
Tm1andTm1
Posts: 48
Joined: Thu Apr 11, 2013 7:47 am
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Error creating new view......

Post by Tm1andTm1 »

Hi Experts,

I am getting attached error while trying to open cell security cube.
Kindly suggest..

Thanks
Attachments
Capture.JPG
Capture.JPG (56.05 KiB) Viewed 4116 times
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Error creating new view......

Post by EvgenyT »

InvalidViewsSubsetArray suggests that a view contains an invalid subset of one or more dimensions...

ET
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Error creating new view......

Post by Duncan P »

So did you create a cell security cube on an element security cube?

If I had done this I think I would have been surprised to see it work. Perhaps I am just a pessimist.
jstrygner
MVP
Posts: 195
Joined: Wed Jul 22, 2009 10:35 pm
OLAP Product: TM1
Version: 9.5.2 FP3
Excel Version: 2010

Re: Error creating new view......

Post by jstrygner »

Applying element security on a dimension results in creating }ElementSecurity control cube with this dimension and with the }Groups dimension.

Applying cell security on a cube results in creating }CellSecurity control cube with all dimensions of that cube plus the }Groups dimension.

In your case you kind of "requested" a cube with two }Groups dimensions. TM1 does not allow using same dimension twice in a cube. If somebody from Iboglix would forsee such operation it should just result in some kind of an "creation error" message. I assume (at least in your TM1 version) that is not the case and TM1 somehow tried to create it but in a corrupted way.

If you try to create cell security cube on element security cube then I am assuming you do not understand correctly those security concepts.
I would say those are described well enough in documentation to learn from there.
Tm1andTm1
Posts: 48
Joined: Thu Apr 11, 2013 7:47 am
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Re: Error creating new view......

Post by Tm1andTm1 »

Thanks All for providing me the inputs, I will try and hope it will be work fine.

Thanks once again
Post Reply