TM1 Forum

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.

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

Right, I get how it's a slice of an n-dimension cube. That makes sense. At least two of those dimensions are represented on the crosstab. Let's say for arguments sake I have two cube views. The first shows Sales Reps on the row edge of the cross tab and the second shows Products on the row edge of t...

I'm not thinking in database terms. A cube view is a crosstab with a row edge and a column edge, or two axes in MDX terms. I know the rule I specified is valid but I need it to be generic so that it will always apply to the consolidation of whatever dimension elements are on the row edge/axis. Make ...

Is it possible to define a rule that will calculate a percentage of column total that will be valid in any cube view regardless of what dimension is on the row edge? For example say I have a cube with dimensions Product, Sales Rep and Day, and measures Quantity, Net Amount and Percent Total, where P...

Brilliant! That worked! Thank you. So simple.

Does anyone know the admin password for the Rules Guide Data sample TM1 server that ships with TM1 10.1? I tried apple which is the password for the other sample servers and that doesn't work.

Thanks.