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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: atkas
  • Order by date
  1. atkas

    Currency Exchange as a dimesnion

    I tried using a dimension but seem to be missing something. I can't seem to pick up the exchange rate I need in my calculated measure. The fact table basically has: date amount (in Canadian dolloars) The dimension has: date cc_code exch_rate The currency code for Canada is also in the...
  2. atkas

    Currency Exchange as a dimesnion

    All of the amounts are in Canadian dollars. The exchange rate is intended to allow the user to view the results in the currency of choice. I had not not considered the use of a virtual cube, but since time seems to tbe the only common dimension, I was only able to get the exchange rate to apply...
  3. atkas

    Currency Exchange as a dimesnion

    I have a fact table with amounts that are all in Canadian Dollars. I have created calculated measures for each of these amounts and would like to know how I can display the cube in any of the defined exchange rates in the dimension. The exchange rate dimension consist of time, currency code, and...

Part and Inventory Search

Back
Top