RE: can a dimension table contains numeric values?
Dimension table will have only textual values only.Some dimension table will have numeric values for eg.Cust number in a Cust_dim only thing here to remember is the object type of the Cust number should always a Char type.for ref you can see these in the universe just right click the cust number object and view definition tab of the object there you can see a list down box will show your object Type to be Char.
for further query pls do send a mail r.isrepus@gmail.com
RE: can a dimension table contains numeric values?
Absolutely!
For example a perishable product in a grocery store might have SHELF_LIFE (in days) as part of the product dimension. This value may for example be used to calculate optimum inventory levels for the product. Too much inventory and an excess of product expires on the shelf while too little results in lost sales.
RE: can a dimension table contains numeric values?
As commented by Gurus in this question I think dimension table can have numeric values also since it is business requiremnt driven model. For example you can a currency table which will have the currency conversion values. which you can used in fact table for conversion values.
RE: can a dimension table contains numeric values?
Yes Dimension tables can contain Numeric values like "Code" "ID" or anything else.It has no restication on the datatype.It depends upon Business logic. What is important is that on the reporting side you cant treat it as MEASURE. A dimensional data should alwayas be treated as DIMENSION irrespective of its DATATYPE. eg you must have Customer Codes to identify your Customers but obviously you neither require nor put SUM() on Cust_Code? So its not about datatype its about functionality what you want to acheive.
