Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 dimension as measure

Author  Topic 

dmgilbert
Starting Member

10 Posts

Posted - 2004-06-09 : 10:34:02
Is there a way to make a data element in a dimension table a measure (or calculated member)

ex. Workorder table that includes the product number, quantity of product, and the time to fill work order. Product table that includes product number and the standard time to fill for quantity 1.

I want to use the workorder fact table and calculate the variance to the standard set for each product on the work order

Thanks in advance
   

- Advertisement -