attributes in data tab

Post Reply
Moh
Posts: 43
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 »

hi sir why attributes updated in data tab instead metadata. any particular reason please explain
bgregs
Posts: 77
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 »

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. ;)
tomok
MVP
Posts: 2831
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: attributes in data tab

Post by tomok »

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
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: attributes in data tab

Post by jim wood »

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,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Moh
Posts: 43
Joined: Fri Aug 01, 2014 5:17 pm
OLAP Product: Cognos
Version: 10.1.1
Excel Version: 2010

Re: attributes in data tab

Post by Moh »

thank you
Post Reply