Question

Point out the wrong statement.

(a) Transactions are stored in the fact table in local currencies for many-to-many conversion

(b) Transactions are stored in the fact table in the pivot currency for one-to-many conversion

(c) If you choose a many-to-many or one-to-many conversion type for your currency conversion, you need to specify the reporting currencies

(d) None of the mentioned

This question was posed to me in an interview for job.

My enquiry is from Analysis Services topic in division Business Intelligence of SQL Server

Answer 1

Right choice is (b) Transactions are stored in the fact table in the pivot currency for one-to-many conversion

Easiest explanation: Transactions are stored in the fact table in the pivot currency, and then converted to one or more other reporting currencies.