attributes in data tab

Post Reply
Posts: 42
Joined: Fri Aug 01, 2014 5:17 pm
OLAP Product: Cognos
Version: 10.1.1
Excel Version: 2010

attributes in data tab

Post by Moh » Wed Oct 10, 2018 1:56 pm

hi sir why attributes updated in data tab instead metadata. any particular reason please explain

Posts: 25
Joined: Wed Sep 12, 2018 11:19 am
OLAP Product: TM1 / Planning Analytics
Version: 2.0
Excel Version: 2016

Re: attributes in data tab

Post by bgregs » Wed Oct 10, 2018 2:01 pm

In simplistic terms, metadata is the "mapping/webbing" behind the scenes where objects and data structures are linked together. When you update an element by adding it to a dimension in the metadata tab, you are creating this linking of element to dimension.

The data tab stores individual values in a data structure (in this case a cube). When you add an attribute to an element, you are literally storing data in the attributes cube for that dimension. You are not necessarily creating a "linking" to anything behind the scenes per say, but more so storing data in a cube about a certain element.

Hopefully that was clear. I tried to keep it high level, but obviously there is more than just that occurring behind the scenes. ;)

User avatar
Posts: 2483
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

Re: attributes in data tab

Post by tomok » Wed Oct 10, 2018 3:20 pm

In database terms metadata represents the structure in the tables; columns, indexes, etc. Data is the rows in the table. Since attribute values are data it is be done in the Data tab. If you were adding an attribute to a dimension, meaning the structure, and not actually adding the values for the attribute, than would be done in the metadata tab.
Tom O'Kelley - Manager Finance Systems
American Tower

User avatar
jim wood
Site Admin
Posts: 3600
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA

Re: attributes in data tab

Post by jim wood » Wed Oct 10, 2018 5:47 pm

Something to consider is commitment... Now then fellas don't all run away!!!

I mean when TM1 commits changes. Unless you're using the add direct formula the elements aren't committed to the dimension until once the meta tab has been completed. As others have others have stated attributes are simply data held in a control cube, so when TI was first created the attribute write was put in to the data tab as the element needs to exist before any data can be written to it, hence the write comes after the creation commit,

Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply