Hi Experts,
I am getting attached error while trying to open cell security cube.
Kindly suggest..
Thanks
Error creating new view......
-
- Posts: 48
- Joined: Thu Apr 11, 2013 7:47 am
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
Error creating new view......
- Attachments
-
- Capture.JPG (56.05 KiB) Viewed 4116 times
-
- 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......
InvalidViewsSubsetArray suggests that a view contains an invalid subset of one or more dimensions...
ET
ET
-
- 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......
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.
If I had done this I think I would have been surprised to see it work. Perhaps I am just a pessimist.
-
- 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......
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.
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.
-
- 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......
Thanks All for providing me the inputs, I will try and hope it will be work fine.
Thanks once again
Thanks once again