I have a field in a fact table - QTY. I have a unit of measure conversion field - CONVERSION_RATE - in another table. My cube needs to display a value that is QTY/CONVERSION_RATE. How do I do this if both columns are not in the same fact table? The only way I can see is to use a view as the fact table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Claculated Measure - Different Tables
- Thread starter warpped
- Start date
A view is going to be the best method to accomplish this. I make it a practice to set my fact and dim sources as views to allow for these types of issues and other issues they can arise when a table is the source.
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question