vijaya_friendly

 Profile Answers by vijaya_friendly 

• Oct 29th, 2008

 

Attribute is a Dimension. Attributes provide the business model with a context in which to report on and analyze facts. Ex: Month, Product, Customer, Year..
Fact is numeric and it is aggregatable. Examples of facts include sales dollars, units sold, profit, and cost.

ashu_eureka

 Profile Answers by ashu_eureka 

• Jun 11th, 2009

 

Facts: You can think of facts as numerical data which can be aggregated. The facts provide insight of how the business is performing.
E.g., Sales, profit etc which are numerical and gives information about whether the business is running fine or not, are generally used as facts.

Attributes: Attributes are context which provide meaning to the numerical data (facts). In other terms they add different dimension to the data giving us complete picture of what the numerical data means.
E.g.,
If we just say Sale is 2000 than we don't get complete information about the sale.

But if we say that Sale for Year 2009 is 2000 than we know more about the sale.
Similarly, Sale of Item - Book is 5000 gives meaning to the sale figure.

Vivek Jain

 Profile Answers by Vivek Jain 

• Jan 17th, 2011

 

Attribute: This the schema object which provides information about data. for example customer Name, country Name and Year.

Fact: This kind of object used for the actullay data which is used to perform analytical calculation. facts are used to create metric in microstrategy to calculate report data.
EX. Revenue, Profit, Cost.

srinivas rotti

• Mar 7th, 2012

 

Attribute: It is a schema object, and has many forms such as descriptions,id etc. each form is related to a field in metadata repository.Many times attribute will not be a numeric value unless it is primary key or id form.

fact: A fact is way to access numeric field or metric from data warehouse.According to me, facts are not aggregatable but metrics are aggregatable.

sivaleela prasad

• Apr 16th, 2012

 

Attribute: Attribute is a catalog of information and it is a structure
Fact: Fact is a numerical information such as revenue,quantity

Mahipal

• Oct 19th, 2012

 

Attribute: An attribute is a schema object, an actual data holder of the organizations data. For example, customer name, city, Payment type etc.

Fact: Fact is also a schema object which is numeric most of the times. For example, revenue, profit, number of stores etc.

Pritika

• Apr 11th, 2013

 

Attribute is descriptive part of database. like Name,City etc.
Fact is measure part of database. like sales,Commission etc.

Jayadev

• May 6th, 2016

 

Attibute is a schema object which typically maps the descriptive data in the data warehouse