TI code to suppress a attribute of dimension in cube

Post Reply
k2g
Posts: 11
Joined: Tue Jun 14, 2011 4:17 am
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2010

TI code to suppress a attribute of dimension in cube

Post by k2g »

I have a cube with 5 dimension e.g. A, B, C, D, E (in order). I don't want to show such attribute of E having all zero value.
Request you all TM1 expert to please tell TI code to suppress such attribute in cube. Thanks
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: TI code to suppress a attribute of dimension in cube

Post by tomok »

I suggest you take some training, or at a minimum, read the manuals. Zero-suppression is quite easy in the cube viewer and in active form reports.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
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: TI code to suppress a attribute of dimension in cube

Post by Alan Kirk »

k2g wrote:I have a cube with 5 dimension e.g. A, B, C, D, E (in order). I don't want to show such attribute of E having all zero value.
Request you all TM1 expert to please tell TI code to suppress such attribute in cube. Thanks
Tomok is correct in saying that zero suppression in a data cube is a basic skill but that doesn't seem to be what you're asking. In fact, I have no idea what it is that you are asking.

You're talking about a TI function to suppress an attribute? Are you talking about the attribute having a zero value? Are you talking about the source data having a zero value?

You say that you don't want to "show" it; show it to whom, and how? A TI process simply processes data and metadata, it doesn't actually display data output to a user.

It would be better to describe exactly what you are doing, and what you're trying to achieve, including the code that you already have and sample data. Please read the Request For Assistance Guidelines at the head of this forum if you haven't already done so.
"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