Leaf elements in cube view greyed out

Post Reply
nerph
Posts: 7
Joined: Tue Jan 15, 2013 11:59 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010

Leaf elements in cube view greyed out

Post by nerph »

I have a cube view filtered so that it's showing the leaf elements but the cells are all greyed out and I can't figure out why. There are no rules on the cube. Is there any other reason that would cause a leaf element to be greyed out? Thanks.

Cheers,
Greg
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Leaf elements in cube view greyed out

Post by tomok »

nerph wrote:I have a cube view filtered so that it's showing the leaf elements but the cells are all greyed out and I can't figure out why. There are no rules on the cube. Is there any other reason that would cause a leaf element to be greyed out? Thanks.

Cheers,
Greg
What about the title elements in the view? Are you absolutely certain they are not consolidation elements? What about security? Do you have WRITE access to the elements?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Leaf elements in cube view greyed out

Post by lotsaram »

Do you have admin access? If not then it's probably something to do with security.

If you are admin and you are sure that the leaf cells are not rule derived then it could be to do with locking (which is like an extra level of security on top of the standard security model). Check that 1/ the cube is not locked, 2/ that any of the elements in the view you are looking at are not locked.
nerph
Posts: 7
Joined: Tue Jan 15, 2013 11:59 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010

Re: Leaf elements in cube view greyed out

Post by nerph »

Ah yes, my mistake. One of the title elements was actually a consolidation with a very similar name to a leaf element. It's working fine now. Thanks.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Leaf elements in cube view greyed out

Post by Alan Kirk »

nerph wrote:Ah yes, my mistake. One of the title elements was actually a consolidation with a very similar name to a leaf element. It's working fine now. Thanks.
Don't forget that if you come across this situation in future you can right click on the cell (in Cube Viewer) and choose "Edit Status". It will pick up issues like that and sometimes tell you where the problem lies.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply